Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Ipal++Y4ujc3e36LtwOk4g
Power Automate - Building Flows
Suggested answer

Automatically send emails from Excel with PowerAutomate

Like (1) ShareShare
ReportReport
Posted on 21 Mar 2025 12:12:01 by
Hello,
 
I have followed instructions on this site to send automate emails from Excel.
 
 
Is there a way of adding person name in the body of email? e.g. I have a column in excel table Forename, so would want name to show in email, e.g. Dear Bob.
 
The email column is Person_Email_Add and the other columns are Forename, Surname, ID, Supervisor_email_add
 
The flow works fine, also is there a way of adding CC in the email from the field from the excel table Supervisor_email_add?
 
Thanks in advance.
  • Suggested answer
    rzaneti Profile Picture
    4,028 Super User 2025 Season 1 on 27 Mar 2025 at 17:45:37
    Automatically send emails from Excel with PowerAutomate
     
    Inside the email body input, you can combine both dynamic and static content. For your use case, you can simply add the dynamic content corresponding to the Forename column in the body, like this:
     
     
     
     
    You can also refer to the following videos and blogs related to your issue (the first video and the first blog explore a very similar scenario to yours, combining dynamic and static content in the email body):
    - Video: How to send emails from multiple Excel records with Power Automate: https://youtu.be/jzwoA0d8qW4
    - Video: Using dynamic content in Power Automate: https://youtu.be/jpledJfaEPQ
    - Blog: How to send bulk emails from an Excel table using Power Automate: https://digitalmill.net/2025/03/17/how-to-send-bulk-emails-from-an-excel-table-using-power-automate/
    - Blog: Using loops and accessing array elements in Power Automate: https://digitalmill.net/2023/07/12/using-loops-and-accessing-array-elements-in-power-automate/
     
     
    For the CC, you can simply show the input from the Advanced Parameters, click in Switch to advanced mode and use the dynamic content for Supervisor_email:
     
     
    Let me know if it works for you or if you need any additional help!
     
    If this is the answer to your question, please mark the post as Accepted Answer.
    If this answer helps you in any way, please give it a like.

    Check more Power Platform content on my website.
    Lets connect on LinkedIn.
  • Michael E. Gernaey Profile Picture
    42,048 Super User 2025 Season 1 on 27 Mar 2025 at 17:19:44
    Automatically send emails from Excel with PowerAutomate
     
    While maybe others will, most of us are not going to look at that video. It doesn't for sure show us what you did. We need you to share your flows, your data, your inputs and outputs, your logic and explain it, not ask us to get it from a video.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 103

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 82 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 60 Super User 2025 Season 1

Overall leaderboard
Loading started