|
|
|
|
#1
12-06-2010, 02:17 PM
|
|||
|
|||
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
12-07-2010, 05:14 AM
|
|||
|
|||
|
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 |
Windows XP 
Office 2007
Hybrid Mode