Solved

Creating selective merge fields when importing source information in Word 2013

Posted on 2015-02-06
1
65 Views
Last Modified: 2015-02-10
I will be adding this series («Companyname»«Firstname»«Lastname») to a variety of documents. During a merge in some instances the info will be a Companyname, in others, Firstname Lastname. When Companyname is used I want Firstname Lastname to be blank, not spaces, and when firstname lastname is used I want companyname to be blank (not a space) and a space to be included between firstname lastname.
0
Comment
Question by:vjstech
1 Comment
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40596728
Hi,

Why not try with IF

{ IF  { MERGEFIELD CompanyName  } = "" "{ MERGEFIELD FirstName  } { MERGEFIELD LastName  }" { MERGEFIELD CompanyName  }  }

for reference
http://word.mvps.org/faqs/mailmerge/mmergeiffields.htm

Regards
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
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…

813 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

10 Experts available now in Live!

Get 1:1 Help Now