I am currently trying to create an email that will be sent to multiple people based on data in an excel sheet. I am well aware of mail merge, but to my knowledge, it will only send out 1 email to 1 person. I want to be able to populate the To: field with multiple email addresses based on values in the excel sheet.
for example, if in excel the columns have
then in the to: field, i'll want the email to be sent to firstname.lastname@example.org; email@example.com
I was hoping to make this is VB so that I can include it in some excel macros that sort the data.
is this possible?