Solved

Creating selective merge fields when importing source information in Word 2013

Posted on 2015-02-06
1
64 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

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

I recently resolved a client's Office 2013 installation problem and wanted to offer an observation that may help you with troubleshooting similar issues. The client ordered three Dell Optiplex system units with the Windows 7 downgrade option inst…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
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 use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

867 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

26 Experts available now in Live!

Get 1:1 Help Now