Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge data into multiple documents
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge data into multiple documents
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/cindy...r/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 "Steve-cmfi group" Steve-cmfi wrote in message ... 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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I merge multiple documents with one data source? | Mailmerge | |||
Can you do a mail merge using multiple data sources? | Mailmerge | |||
Can mail merge pull from records from multiple data sources? | Mailmerge | |||
How do I consolidate multiple mail merge data files into one file | Mailmerge | |||
How do I merge data into multiple documents? | Mailmerge |