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 / Paste Excel range of v...
Power Automate
Unanswered

Paste Excel range of values into the body of an Outlook email

(0) ShareShare
ReportReport
Posted on by 11

Hi everyone, 

 

I have copied a range of cells in Excel and I want to paste that to the body of an Outlook email with the as-is format. Like you would do with Control V. How do I do that?

 

I've tried the send keys action and it is possible that I didn't do it correctly, but I couldn't work it out. Please help me out.

I have the same question (0)
  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    There's no nice way to do that. You would in fact need to automate the user interface of Outlook, which is a huge pain to do in most cases. If you do try it and have used the Copy cells from Excel worksheet action to copy the range, you can try the Send keys action to send {Control}({V}). This is the correct syntax to send Ctrl+V. It should work in theory, but it will paste it with the default paste options.

     

    Is your formatting very difficult to reproduce? I would suggest to instead use Read data from Excel worksheet to get the data into a list/data table and then process is according to the format you need. You would then not need to automate the UI of Outlook, as you could simply use the Send email through Outlook action to send the message.

     

    -------------------------------------------------------------------------
    If I have answered your question, please mark it as the preferred solution.
    If you like my response, please give it a Thumbs Up.

    If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

     

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

    Hi @franconasello 

     

    This would be recommended approach 

    https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Format-Data-Table-in-Power-Automate-Desktop-to-include-in-email/td-p/1401474

     

    as per second point told by @Agnius 

     

    Hope it helps !

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 245

#2
David_MA Profile Picture

David_MA 216 Super User 2026 Season 1

#3
Valantis Profile Picture

Valantis 212

Last 30 days Overall leaderboard