Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-09-2017, 12:31 PM
dewestone dewestone is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2014
Posts: 4
dewestone is on a distinguished road
Post How to suppress space when data field is empty


I am creating a merge letter using data from an Excel worksheet. The data fields extracted from Excel are: First_name, middle_initial and last_name. Some of the rows in the middle_name column are empty. How do I suppress the space when the data field is empty? I am using Word 2010.

Any assistance would be appreciated.
Reply With Quote
  #2  
Old 01-09-2017, 02:47 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,531
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

See Mailmerge Empty Space Suppression in the Mailmerge Tips & Tricks thread at the top of this forum.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge field needs extra space when it populates jaj42305 Mail Merge 3 04-21-2016 03:33 PM
Suppress paragraph mark in mail merge field acerview Mail Merge 3 12-22-2015 07:44 PM
Mail Merge Empty Data Field Licos101 Mail Merge 2 04-10-2014 06:19 AM
Delete lots of empty space between paragraphs. FieldTechnician Word 4 10-25-2013 01:14 PM
Fitting Empty Space with Text Box r.m.bemquerer Word 0 11-14-2012 09:54 AM


All times are GMT -7. The time now is 06:55 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft