Hi all,
I have run into an issue creating a VBA macro which is supposed to send out mass-emails through Excel. I've attached my code below. Essentially, this macro works by pulling the information for the e-mail from various cells in Excel and continues down the rows where the information is stored, through a for loop. Currently, the body of the e-mail is something I have to store in column N in order for it to copy through. However, due to the character limit and formatting, as well as overall functionality I would like to implement a way where I can set a word document as the body of the e-mail for all the e-mails generated in the spreadsheet.
I have viewed many implementations of "word-doc as e-mail body in vba" but the issue I'm having is that it does not work with the code that I have written which has to iterate through all the rows of e-mails and copy the same body to them. Is there a way I can implement this functionality inside my code? Thanks.
---
Bookmarks