Solved

How to insert a MERGEFIELD after a condition is met in an "IF" field expression?

Posted on 2011-09-21
4
345 Views
Last Modified: 2012-05-12
I'm trying to insert a MERGEFIELD of FIRST_NAME if the MERGEFIELD TITLE doesn't equal "Mr and Mrs."

I threw together the following statement under the "If" field but it doesn't seem to work:

IF {MERGEFIELD TITLE} = 'Mr and Mrs.' {MERGEFIELD TITLE} {MERGEFIELD FIRST_NAME}

It just ends up putting TITLE} into the Word document. What is the correct expression to do this?
0
Comment
Question by:Eindoofus
  • 2
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 36577310
Use double quotes to contain the fields

{ IF {MERGEFIELD TITLE} = "Mr and Mrs." "{MERGEFIELD TITLE} {MERGEFIELD FIRST_NAME}" }
0
 

Author Comment

by:Eindoofus
ID: 36577340
Do I only hit CTRL+F9 once or four times to do that? Are the inner braces placed by doing CTRL+F9 as well, or are they manually typed?
0
 

Author Comment

by:Eindoofus
ID: 36577406
For every set of curly braces you need to use CTRL+F9
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 36577423
Ctrl+F9 will put curly brackets around the current selection.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now