Consolidation of Duplicate Recipients to 1 Email per Recipient

[crazymazy]

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

[jaslake]

Hi crazymazy

Try the Code in the attached...

[crazymazy]

Jaslake - sorry for the delay in response.....I was on vacation all last week.

The code you provided works beautifully! I can't thank you enough. I will mark this thread as 'solved'.

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

[varauz]

Hello Jaslake, great code, congrats!!I would like to enter an html text before the table, and (only if possible) one image in the header, and my Outlook signature afeter the table, could you help me??thanks in advance..regards!!

[jaslake]

Hi varauz

Welcome to the Forum!!!

Please start your own Thread...hijacking is frowned upon in this Forum.

[varauz]

I'm sorry, I thought it was a friendly forum to use it.