Selecting merge field based on whether or not text is present
I'm building a letter template that needs to respond in different ways based on whether or not there is spouse information for a given record. If there is text in the spouse column (column B), I want that information to appear. If the spouse column is blank, i want it to return the information in column C instead. Is it possible to set this up with an if...then...else formula?
|