A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

mail merge data into multiple documents



 
 
Thread Tools Display Modes
  #1  
Old May 21st 07, 10:18 PM posted to microsoft.public.word.mailmerge.fields
Steve-cmfi group
external usenet poster
 
Posts: 1
Default 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.
Ads
  #2  
Old May 22nd 07, 04:47 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,832
Default 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  
Old May 22nd 07, 05:43 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I merge multiple documents with one data source? RMO Mailmerge 3 October 4th 06 09:26 PM
Can you do a mail merge using multiple data sources? MatthewLong Mailmerge 1 November 14th 05 08:14 PM
Can mail merge pull from records from multiple data sources? Nursery School Volunteer Mailmerge 2 August 7th 05 05:08 PM
How do I consolidate multiple mail merge data files into one file Robert Mailmerge 6 July 7th 05 10:11 PM
How do I merge data into multiple documents? revelent Mailmerge 1 March 25th 05 07:50 AM


All times are GMT +1. The time now is 06:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.