web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to copy the data/t...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 203

Hi Team 

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

I have the same question (0)
  • AS-06081019-0 Profile Picture
    1,736 Super User 2024 Season 1 on at

    @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.

  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    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

     

    Nived_Nambiar_0-1657474239520.png

     

    Nived_Nambiar_1-1657474257664.png

     

    Here i had used the input as excel file 

    Nived_Nambiar_2-1657474302743.png

     

    Output i got from this flow is a table which can be added in email (html format)

    Nived_Nambiar_3-1657474377219.png

     

     

    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

     

    Nived_Nambiar_4-1657474576823.png

     

     

    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

     

     

     

  • CanaRed Profile Picture
    2 on at

    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 !

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard