Hi I am reasonably new to mail merge and am using Word 2010 and the wizard to attempt to create a mail merge email. But there only seems to be one email field so I am unable to send this to multiple addresses. The source will be a xls or csv generated by FIM 2010.

Our scenario is we are five hospitals who are merging and we using FIM 2010 to migrate to a new SMTP address for the merged hospital i.e firstname.surname@mergedhospital.com. FIM will report on duplicates with the persons name and conflicting email addresses all on one row but separated by column.

There are 30000 users at the five hospitals so we anticipate some name duplication however due to the fact these hospitals are within a reasonable distance some duplicates will be the same person and some will be legitimate duplicates. We wish to email the person at up to five different legacy email addresses advising them that they have an address at up to five organisations. So they can clarify firstly which legacy address is their primary and also if the other addresses belong to them if not we are then investigating a potential duplicate which may need suffixing for the new global address list.

Our mail merge will need to look something like this:

Dear <firstname>,

I.T are currently working on providing all staff with email addresses for the new 'merged hospital' organisation. These addresses will be made available to staff prior to May 1st.

In the course of our work we have identified the following email addresses which may relate to you:



<Firstname.lastname>@legacyhospital1.com>
<Firstname.lastname>@legacyhospital2.com>
* - Potentially there could be up to five addresses using two as an example

Please can you confirm by reply whether both of these addresses relate to yourself and if so, which is your primary email address? If you receive this message on multiple mail account you only need to respond once. If no response is received a new address will not be created for this account.

Thank you for your cooperation.

So I need to use mail merge to email a person at potentially two or three different addresses and use mail merge to insert their Dear <firstname> (which seems very easy) and also insert the email addresses we are emailing (potential duplicates) into the body of the message i.e <firstname.lastname@legacyhospital1.com> and <firstname.lastname@legacyhospital2.com>.

I hope someone can advise how best to accomplish this.