Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Using Multiple MailMerge
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 "Doug Robbins - Word MVP" wrote: 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 "Bojingles03" wrote in message ... 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge multiple query's | Mailmerge | |||
Mailmerge opens multiple Access | Mailmerge | |||
Mailmerge from multiple Files | Mailmerge | |||
How do I use multiple worksheets when doing a mailmerge | Mailmerge | |||
Using COM for MailMerge need multiple output files | Mailmerge |