You’re offline. This is a read only version of the page.
Hi Team
How to copy the data/table from excel and paste it in Outlook/Email? please help ?
If you need to keep Excel spreadsheet format when pasting to Outlook Mail, make sure "Use Smart Cut & Paste" is UN-checked.
Go to: FILE - OPTIONS - MAIL - EDITOR OPTIONS (top right of window) - ADVANCED (left column) - Scroll down to CUT, COPY, PASTE section. Un-check 'Use Smart Cut and Paste'. This worked for me. Good Luck !
Hi @Ahmedmuz
You can try this approach of pasting the excel to outlook mail. Here it will be a background process of converting the excel table to html table and then appending to the mail using outlook mail actions
The overall flow of excel table to html table is like below
Here i had used the input as excel file
Output i got from this flow is a table which can be added in email (html format)
This is the html format table.
in the flow screenshot, you can see that i am writing the final_text variable to a html file. You can use the same variable in the send outlook mail action like below
You need to enable the option to write the body as html
This way you can send the mail with table
Let me know if you have any questions
Kindly mark it as solution if it helps 🙂
Thanks & Regards,
Nived N
Try this in PAD -
1. Launch saved excel file
2. Copy a specific range of cells
a. After copying the data, you could use the 'Get clipboard text' Action to store the data into a variable. This variable could be passed to the body of the email. Here the issue could be with the formatting. If you encounter formatting issue then try using sendkeys ctrl+v to paste in Outlook email.
OR
b. use the 'Read from Excel worksheet' Action to store the Excel data directly into a variable
refer this video: https://www.youtube.com/watch?v=dgE5_qo-SNg
3. Launch Outlook
4. Send an E-Mail
Hope it helps!!
Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
