View Single Post
 
Old 12-06-2010, 02:17 PM
amym amym is offline Windows XP Office 2007
Novice
 
Join Date: Dec 2010
Posts: 1
amym is on a distinguished road
Default 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?
Reply With Quote