Answered

Multiple Email Address in Excel

(1) Share

Report

Posted on by DB-18111541-0

Hello,

I have multiple email addresses separated by a semicolon in one Excel cell. For example, cell A1 has name1@email.com; name2@email.com. Is it possible to use Power Automate to send one email to both of the addresses listed in cell A1?

Thank you,

Dorian

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @DB-18111541-0

yes, the input to send emails, for either outlook or outlook 365 is exactly what you have there.

So read in the data from Excel and send an email

That or read it in, split on the ; and send a separate email to each.

You will need either

1. A table around the data

2. Use Graph API

3. Use an Office Script

One of these to read the value you want, then send your email

Bingo, bango easio :-)

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No
Verified answer

Raymen Deol 75 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi,

This is a task that power automate can handle easily. It depends on if you want to send a single email with multiple recipients or new email for each email address.

For a single email to all recipients - it's easy - you directly pass the value of the cell directly into the "To" field of the email action because it accepts multiple addresses in the following format test1@test.com;test2@test.com :

For a new email to each recipient you will need to split the email addresses using something like this:

split(items('Apply_to_each')?['Emails'], ';') and then loop through this ouput to send the emails:

2 people found this reply helpful.

Was this reply helpful? Yes No
DB-18111541-0 8 on at

Like
a
(1)

Report
Copy link

Link copied!

@Raymen Deol, thank you for your help. The first solution (single email to all addresses) is what I was looking for and worked perfectly! I was wondering if you can help me with the next step I am trying to accomplish, or suggest someone who can help?

Here is a sample spreadsheet:

I am wondering if there is a way to have one email sent per Dept, and in the body of the email list all the courses associated with that Derp.

For example, one email will go to email1 and email 2 that would list all the courses associated with ENGL, and another email will go to email5 and email6 with all the courses associated with MATH (example below). Thank you for you help and any suggestions you may have!

Was this reply helpful? Yes No