Mail Merge using Excel DataLocked
I have an excel spreadsheet that lists all of my contractors. Many have multiple e-mail addresses. When I try to do a mail merge in Word to an e-mail using the excel sheet as a data source, it ignores the rows that have multiple e-mail addresses listed. I have tried separating the data in the spreadsheet using semi colons, colons, commas, etc. and this does not work. Is there any way to format the data so that word will not ignore it and hopefully send to all email addresses without making each unique e-mail address a separate row within the excel document. This work around will render the spreadsheet useless for my other tasks. I am using Office 2002. Help please!