Automatically send emails from Excel with PowerAutomate

(1) Share

Report

Posted on by HM-21031206-0

Hello,

I have followed instructions on this site to send automate emails from Excel.

https://www.myonlinetraininghub.com/automatically-email-reminders-from-excel-with-power-automate

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.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @HM-21031206-0

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.

Was this reply helpful? Yes No
Suggested answer

rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi @HM-21031206-0,

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.

Was this reply helpful? Yes No