Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2011-09-21
4
Medium Priority
?
358 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 2000 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

916 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