mail merge data into multiple documents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve-cmfi group - 21 May 2007 22:18 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - 22 May 2007 04:47 GMT

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

Signature

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

>I have one excel file. I will include a cell in the excel file as a flag
>for
[quoted text clipped - 13 lines]
>
> Steve, DM Div cmfi group, Inc.

Reply to this Message

Graham Mayor - 22 May 2007 05:43 GMT

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.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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
[quoted text clipped - 8 lines]
>
> Steve, DM Div cmfi group, Inc.

Reply to this Message