Mail Merge conditional statements

K

kermit21

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.
 
G

Greg Maxey

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.
 
S

shelajn

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.
 
C

Cindy M -WordMVP-

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.
Click to expand...
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 :)
 
Top