mail merge data into multiple documents Steve-cmfi group 5/21/2007 9:18:01 PM 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.

Re: mail merge data into multiple documents "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/22/2007 3:47:31 AM 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 "Steve-cmfi group" <Steve-cmfi group[ at ]discussions.microsoft.com> wrote in message news:7F8EB95B-FD98-4467-AC1B-5D89F3C3D6B3[ at ]microsoft.com... [Quoted Text] >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.

Re: mail merge data into multiple documents "Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 5/22/2007 4:43:52 AM 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: [Quoted Text] > 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.