How to copy the data/table from excel and paste in Outlook/Email

(0) Share

Report

Posted on by Ahmedmuz

203

Hi Team

How to copy the data/table from excel and paste it in Outlook/Email? please help ?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report

@Ahmedmuz

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.

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
CanaRed 2 on at

Like (0)

Report

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 !

Was this reply helpful? Yes No