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.

Hi daz,

You can use probably Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial, in the 'Sticky' thread at the top of this forum:
Microsoft Word Catalogue/Directory Mailmerge Tutorial
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

For a recent, worked example, see the attachment to post #13 at: https://www.msofficeforums.com/mail-...nt-dollar.html

Alternatively, you may want to try a Many-to-One Mail Merge add-in from either:
• Graham Mayor at: Merge Many To One
• Doug Robbins' Windows Live SkyDrive page at: Microsoft OneDrive - Access files anywhere. Create docs with free Office Online.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi Paul,

That is literally exactly what is required and as stipulated we are using Word 2010 for the mail merge.

Thanks for all your help. I will spend some more time tomorrow trying to get my head round it.

Daz