Solved

Is it possible to have an IF field in Word with two possible conditions for MERGEFIELD?

Posted on 2011-09-21
2
313 Views
Last Modified: 2012-05-12
I'm trying to do the following:

1.) IF MERGEFIELD TITLE = "Mr and Mrs." THEN Insert MERGEFIELD TITLE
2.) IF MERGEFIELD TITLE = "Mr." OR "Mrs." THEN Insert MERGEFIELD TITLE plus a space followed by MERGEFIELD FIRST_NAME

Is this possible, and if so what is the expression I would use for this?
0
Comment
Question by:Eindoofus
  • 2
2 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
Comment Utility
You can repeat the test in separate IF fields for each acceptable value
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
Comment Utility
{ IF {MERGEFIELD TITLE} = "Mr and Mrs." "{MERGEFIELD TITLE}" }{ IF {MERGEFIELD TITLE} = "Mr" "{MERGEFIELD TITLE}" } { IF {MERGEFIELD TITLE} = "Mrs." "{MERGEFIELD TITLE}" }  
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Preface: When I started this series, I used the term CommandBars because that is the Office Object class that it discusses. Unfortunately, when Microsoft introduced Office 2007, they replaced the standard Commandbar menus with "The Ribbon" and rem…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

743 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

12 Experts available now in Live!

Get 1:1 Help Now