How to Send One email with excel to Multiple Recipients

[ekim]

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!

[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

[alexnajm]

ok!