Hello Everyone,

I am reaching out for assistance today in regards to auto generating an e-mail that will consolidate duplicate rows for 'column a' in my attachment. The key here isn't necessarily deleting the rows... What i really need is vba code that will enumerate through the table and auto generate an e-mail for each individual. For each individual, i need the code to generate a table in the body of the e-mail & attach the activity for that recipient and the date. The trip up here is when a recipient has two activities associated to their name, and their name shows up multiple times in the data set. I need the code to a) identify the duplicate recipient, b) send out 1 email for that person, and c) attach each activitiy/date (2 or more) to a table. Please let me know anyone can help.

Thanks,
-CrazyMazy


Automate the Consolidation of Duplicate Recipients to 1 Email (2).xlsm