Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-06-2010, 02:17 PM
amym amym is offline Selecting merge field based on whether or not text is present Windows XP Selecting merge field based on whether or not text is present Office 2007
Novice
Selecting merge field based on whether or not text is present
 
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
  #2  
Old 12-07-2010, 05:14 AM
Kimberly Kimberly is offline Selecting merge field based on whether or not text is present Windows 7 Selecting merge field based on whether or not text is present Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

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"}}
ALT + F9 to turn off Field codes
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting merge field based on whether or not text is present 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft