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