Dynamic email with unique attachments

[rob_lawson]

Hi

I have a report that generates fresh each day that I want to parse and send emails, with attachments, but I want the recipients to only receive the rows that belong to them. The number of rows and combinations of emails will be totally unique each day.

Attached is how far I've gotten. I need the recipients for the first two rows to receive an email with attachment that only includes the data from those first 2 rows. The second group of 4 rows would only be sent to those email addresses.

I also want the email tool to pick up those concatenated email addresses and insert them into the TO: field.

Appreciate any help!

Thanks

Rob

[martinding · Accepted solution]

Hi @rob_lawson ,

You could dynamically filter the data to a subset belonging to each unique concatenated email address and send the email based on the subset by using a batch macro.

Please see attached packaged workflow as an example.

[rob_lawson]

Thanks @martinding 

That got me unstuck!