#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
ALT + F9 to display Field codes
Don't type the brackets. When you need them, press Ctrl + F9 to insert the brackets. Code:
{IF{MERGEFIELD Spouse}= "" {MERGEFIELD "COLUMNCFIELDNAME"} {MERGEFIELD "Spouse"}} |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Selecting specific text out of a series of columns | speedycorn1 | Word | 3 | 11-01-2010 02:58 PM |
Merge after selecting client | kennethc | Mail Merge | 0 | 09-02-2010 01:49 PM |
merge field formatting problem with "text to be inserted before" | wissam | Mail Merge | 0 | 12-13-2009 12:50 AM |
Selecting a Text Box | gajesh | Word | 0 | 09-02-2009 11:45 PM |
Text field after word merge in Word 2000 | brianlb | Word | 1 | 06-29-2009 07:50 AM |