Mail Merge Excel, Word, Outlook 2010

[kls]

I have an Excel spreadsheet with multiple email addresses in one cell separated with semi-colons; other rows may have only 1 email address. I would like to send a document using mail merge where the TO is to all email addresses in each row. There are 100+ so I didn't want to create distribution lists or contacts. Is there a way around this?

 

[Macropod]

Unless you create distribution lists, the only options are:
1. create a separate record for each recipient; or
2. automate outlook using VBA. For an addin to do that (and much more), see: Merge Many To One