How to Send One email with excel to Multiple Recipients

My workflow is scheduled to run weekly with an updated excel. Currently, the recipients(3) are based on a column

(i.e.USER_EMAIL) that has email addresses listed. This recipient list can vary depending on the week. My issue is that when I'm testing with my email as the recipient(To: MYEMAIL@EMAIL.COM), I get 3 separate emails when I should only get 1. How do I make sure that the recipients only receive one email? Also, everyone listed actually gets an email?

Thanks in advance!

Output

Apps

App Builder

Accepted answers

All comments

alexnajm

However many records are going into the Email tool are the amount of emails you'll send - get it down to a singular record and concatenate the user emails with semi colons!

ekim

I have a temporary excel filepath so it creates the temporary excel. I then appended it with a summarize tool to concatenate the emails. Will this work then?

alexnajm

I don't see why it would not work - but were in your workflow are you actually using the temp file path to create the file? That needs to happen before the email tool - you can use control containers to sequence the execution if needed

ekim

I used a Block until Done tool and have the temporary file created first. Then the rest of the workflow runs with the temporary filepath column being created

Capture.PNG

alexnajm

ok!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335