Hi,
I have to send vendor manuals out to over 1000 vendors. I have a spread sheet with their email addresses in column C. I have two email templates with the vendor manuals attached in the template.
For each template I would like to sort by Vendor # (column A), concatenate all emails under said vendor # (column C, up to 5 addresses) and input the address into the .To field of the email sub.
Is there a way to create this type of macro? I have attached the excel file that contains all vendors email address.
Any Help with this would be much appreciated.
Bookmarks