Mail Merge

[cweidler]

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.

 

[Peter Jamieson]

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 }" }