Mail Merge conditional statements

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kermit21 - 28 Jan 2004 19:51 GMT

Trying to merge fields from Excel XP into Word to create labels or document. I would like to have a conditional statement that will merge either the Nick_name field or the First_name field. Not both.

Reply to this Message

Greg Maxey - 28 Jan 2004 21:30 GMT

Kermit,

Tested with REF fields but not MergeFields. Try { IF {MERGEFIELD NN} <>
""{MERGEFIELD NN}{MERGEFIELD FN}}

Where NM is the nickname mergefield name adn FN is the first name mergefield
name.

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org

> Trying to merge fields from Excel XP into Word to create labels or
> document. I would like to have a conditional statement that will
> merge either the Nick_name field or the First_name field. Not both.

Reply to this Message

shelajn - 29 Jan 2004 16:11 GMT

Could you please go into more details about how to solve this problem? I am trying to do the exact same thing and I don't understand your reference to the REF field, etc.

Reply to this Message

Cindy M -WordMVP- - 03 Feb 2004 23:23 GMT

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

> Could you please go into more details about how to solve this problem? I am trying to do the exact same thing and I don't understand your reference to the REF field, etc.

Don't worry about the REF field.

Use Ctrl+F9 to insert the { field brackets }; Alt+F9 to turn the field codes on/off. If you need more information, please tell us where you've gotten stuck.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
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 :-)

Reply to this Message