I have an excel work book that has a list of emails in A, a list of subjects in column B and a list of different files that need to be attached to their respective emails in C. I would like to create a macro that goes line item by line item creating a new email for each line item, using the different information from each line item. The only piece of information that would be the same for every email would be the body. Unfortunately this is beyond me expertise.
Thank you in advance for you help!
Bookmarks