Title
Merge field - conditional "and"
Post
I have a merge field: <<last name>>, <<first name>> <<spouse name>>
Is there a way I can insert an "and" between the first name and spouse's name ONLY if there is a spouse (so that it won't put a random "and" after the first name if they have no spouse)? Or can you think of a better way?
Thanks for your help! :)
Use a calculation field set to return text in place of these separate merge fields:
Last Name & ", " & first name & If ( Not Isempty ( Spouse name ) ; " and " & spouse name )