View Single Post
  #2   Report Post  
Posted to microsoft.public.word.newusers
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Merge Logic Functions

Hi joe925c,

You could code your field as:
{IF{IF{MERGEFIELD First_Name_M} "" 1 0}+{IF{MERGEFIELD First_Name_F} "" 1 0}= 2 "{MERGEFIELD First_Name_M} and {MERGEFIELD
First_Name_F} "{MERGEFIELD First_Name_M}{MERGEFIELD First_Name_M}"}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[MVP - Microsoft Word]


"joe925c" wrote in message ...
Word 2007 Windows XP Home.

Recipient List
Merged Output Desired
First Name M First Name F Surname
Jim Fir
Jim Fir
Joan Beech
Joan Beech
Pine
Pine
Paul Dianne Oak
Paul and Dianne Oak

Basically want IF {First Name M} AND {First Name F} ARE not blank then PRINT
{{First Name M} and {First Name F}} ELSE PRINT {First Name M}{ First Name F}

Have tried to work with the IF..THEN..ELSE "rule" including nesting IFs but
no luck. Any solutions?