View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default mail merge data into multiple documents

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

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


Steve-cmfi group wrote:
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.