mail merge data into multiple documents

[Steve-cmfi group]

I have one excel file. I will include a cell in the excel file as a flag for
match to a specific word document. I have different word documents
(letters)-up to 6 word documents. I wish to sort the excel database through
my mailing software(BCC) export a finished database to be mail merged into 6
different letters. John Doe-flag 1-to letter number1. Mary Doe-flag 2 to
letter number 2. Bart Jones-flag 3-to letter number 3. Karen Smith-flag
1 to letter number 1. Bob Hines-flag 6 to letter number 6. Etc. until the
entire database is merged. I would appreciate any help that I can get. Have
a great day.

Steve, DM Div cmfi group, Inc.

 

[Doug Robbins - Word MVP]

Depending upon the degree to which the letters are different, you could do
this by having another field in the spreadsheet that included the filename
of a file that contained the relevant text for each of the letters and then
use an IncludeText field in the mailmerge main document to pull in the
relevant text in a similar way to the insertion of graphics into a mail
merge.

See the "Graphics from data base" item under the "Special merges" section of
fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
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

 

[Graham Mayor]

Mail merge in Word starts with the premise that you merge a data source into
a document and not merge documents into a data source. You could use six
separate merge documents one for each variation of the flag, or as Doug
indicates, if the letters are sufficiently similar you could conditionally
merge the required vaariable content into the source document.
eg {IF{Mergefield FlagNameField} = 1 "Type this"} {IF{Mergefield
FlagNameField} = 2 "Type this"} {IF{Mergefield FlagNameField} = 3 "Type
this"} etc
"Type this" could be more or less anything including autotext and
includetext fields.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>