A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combining multiple merge documents



 
 
Thread Tools Display Modes
  #1  
Old June 15th, 2005, 12:48 AM
cth5c
external usenet poster
 
Posts: n/a
Default Combining multiple merge documents

In Word XP, I have several mail merge letter templates, each just slightly
different from each other (different letter signer, small variations in
language, margins differ). Each letter uses the same Excel data source. The
data is filtered by one field before the merge of each template. If the
field contains X, Y, and Z, then Merge Template X is opened and merged, then
Merge Template Y, then Merge Template Z. It is extremely repetitive.

Is there any way to combine the merge templates, without having to set IF,
THEN statements at each place where the letters differ? For instance,
depending on whether I've filtered for X, Y or Z, can it skip all the merge
language for X and jump to Y or Z? Can this all be contained in one template?

C. Baber
  #2  
Old June 15th, 2005, 11:14 AM
Cindy M -WordMVP-
external usenet poster
 
Posts: n/a
Default

Hi =?Utf-8?B?Y3RoNWM=?=,

In Word XP, I have several mail merge letter templates, each just slightly
different from each other (different letter signer, small variations in
language, margins differ). Each letter uses the same Excel data source. The
data is filtered by one field before the merge of each template. If the
field contains X, Y, and Z, then Merge Template X is opened and merged, then
Merge Template Y, then Merge Template Z. It is extremely repetitive.

Is there any way to combine the merge templates, without having to set IF,
THEN statements at each place where the letters differ? For instance,
depending on whether I've filtered for X, Y or Z, can it skip all the merge
language for X and jump to Y or Z? Can this all be contained in one template?

Only using IF fields, I'm afraid. Although you could "tighten things up" a bit
by combining the IF with IncludeText to bring in the conditional stuff from a
separate file. This would make the whole thing easier to maintain.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

 




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 Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Open multiple documents? Dawn Rhoads General Discussion 0 June 3rd, 2005 09:10 PM
Combining Text in Multiple Lines JimFor General Discussion 5 October 30th, 2004 11:04 PM
edit Punlisher version in multiple documents Emilie Publisher 1 August 25th, 2004 08:47 PM
Merging with Access queries - Multiple CPutnam Mailmerge 5 August 21st, 2004 01:11 PM
Multiple Many-To-Many Tables Tom Database Design 7 May 15th, 2004 03:47 AM


All times are GMT +1. The time now is 01:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.