Using Multiple MailMerge

[Bojingles03]

Is there a way to use multiple contacts lists in with one Mail Merge? I have
two or three saved and want to combine them.

Also, will it recognize contacts that repeat between the lists?

 

[Doug Robbins - Word MVP]

The answers are No, and No.

As Word can only use a single flat file as the data source for a mail merge,
you will need to combine the lists into one data source.

You could do that by creating a Directory Type mail merge main document in
which you insert the mergefields into the cells of a one row table. In
turn, attach each data source to that mail merge main document and execute
the merge to a new document. For each data source, this will give you a
document containing a table with a row of data for each record in the data
source. Copy and paste these tables into one document so that they form a
single table. To remove the duplicated records, see the article "Find and
Replace using Wildcards" on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/replace_using_wildcards.htm

Finally, insert a row at the top of the combined table into which you insert
the field names to be used in your mail merge process.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[silent_tiger]

If I could suggest merging the data sorces as an excel file, by referancing
the origional sorces, this also makes the final file "live", and use excel to
filter the dupes, and I found this is a lot more efficient, i.e. if origional
data sorces change, the mail merge is kept up-to-date