So I am having a problem with email merge using Word to house my document & excel as my data source. I would like to send a single unique email to multiple email addresses as well as to individuals. To illustrate this, see the sample Word and Excel files below.

Excel_File.jpg

Word_File.jpg


What I'd like to do in this instance is send exactly 5 emails—1 to Adam, 1 to Betty, 1 message with the 3 guys in the "To" field, 1 to Chris, and 1 message with the 4 ladies in the "To" field. The problem that I'm running into is that I cannot use an email merge in this instance because I can't have multiple email addresses in a cell with MS mail merge, as seen in cells B4 and B6.

Now I know that I can do this by using distribution lists, however I want the recipients to all believe that I am sending a normal email one at a time and not using any sort of mail merge or distribution list.

Does anyone know how I would go about accomplishing this? Any help or suggestions would be appreciated.

Thank you!

-RW