Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2004

Tip: Looking for answers? Try searching our database.

Optional Merge Fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pete Bennett - 24 Aug 2004 10:11 GMT
Hi,

I have a letter template (in Word 2000) that can optionally be used to
create a merge master letter (simply by inserting AutoText containing merge
fields).  The mail merge operation is being handled entrirely by VBA by the
way.

This works fine, except I would now like to have the same template to have
the capability of handling two data sources (both CSV files).  Many of the
fields will be the same, but one CSV file will have more fields than the
other.

Is there any way that I can use truely optional merge fields, as conditional
merge fields can only function if the merge fields are actually there.  I
want to avoid (if at all possible) any messages about "this merge field
doesn't exist".

Thanks,
Cindy M  -WordMVP- - 24 Aug 2004 16:41 GMT
Hi =?Utf-8?B?UGV0ZSBCZW5uZXR0?=,

I don't think there's any way to do this as you envision; no way to "blank out"
unused merge fields. Two alternate approaches occur to me, right off hand:

1. Create both letters as AutoText entries. If the one data source is used,
insert that entry; if the other data source is used, the second entry. As each
autotext entry will contain the fields specific to the data source used, the
problem shouldn't occur.

2. Create both data sources with the same fields. Some of the fields will
always be empty (because they'll never be filled with data), but at least
they'll be present in the data source, so IF fields will work with them.

> I have a letter template (in Word 2000) that can optionally be used to
> create a merge master letter (simply by inserting AutoText containing merge
[quoted text clipped - 10 lines]
> want to avoid (if at all possible) any messages about "this merge field
> doesn't exist".

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 :-)

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.