Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

LinkBack Thread Tools Display Modes
Old 01-09-2017, 12:31 PM
dewestone dewestone is offline Windows 10 Office 2016
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
Old 01-09-2017, 02:47 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 15,209
macropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to all

Did you look in the Mailmerge Tips & Tricks thread at the top of this forum? It includes a topic titled Mailmerge Empty Space Suppression.
Paul Edstein
[MS MVP - Word]
Reply With Quote
Please reply to this thread with any new information or opinions.

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 05:35 AM.

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