For a school directory, Iwant to print the student's name in one column and parent's names in another. Fields are Parent1 and Parent2.

I want to print both if both are populated with the word "and" between them, and only Parent1 if Parent2 is blank. In other words:

If Parent2 is blank, print Parent1 else print "Parent1 and Parent2"

Example:

Student Parent

John Smith Chris and Debbie
Tina Jones Barbara



I can't figure out how to print both parent names if they are both populated in the else clause. Just listing them {MERGEFIELD Parent1} {MERGEFIELD Parent2} does not work -- it only prints Parent1.

Can anyone give the proper syntex?