Try
{ IF "{ MERGEFIELD phone_no_1 }" = "" "" "Phone: { MERGEFIELD
phone_no_1 }" }
where /all/ the {} are the special field braces you can insert using
ctrl-F9.
If that does not quite work, try
{ IF "{ MERGEFIELD phone_no_1 }" = "" "" "
Phone: { MERGEFIELD phone_no_1 }" }
--
Peter Jamieson
http://tips.pjmsn.me.uk
"cweidler" wrote in message
...
I need to do a catalog mail merge from Excel 2000 into Word 2000. Here is
a
brief example: «name»
«addr_1»
«city», «state» «zip»
Phone: «phone_no_1»
Fax: «fax_no»
I need a command/formula for the merge not to print the word "Phone" or
"Fax" if there is not a phone number or fax number listed for that member.