How to suppress space when data field is empty

dewestone · #1 01-09-2017, 12:31 PM

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.

macropod · #2 01-09-2017, 02:47 PM

See Mailmerge Empty Space Suppression in the Mailmerge Tips & Tricks thread at the top of this forum.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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