creating badges using mail merge and do not want to supress lines with empty fields

		Microsoft Office Forums > Microsoft Word > Mail Merge
creating badges using mail merge and do not want to supress lines with empty fields

FAQ

Thread Tools

Display Modes

04-25-2018, 08:54 AM

johnmorabito johnmorabito is offline

Windows 10 creating badges using mail merge and do not want to supress lines with empty fields

Office 2016

Novice

Join Date: Apr 2018

Posts: 1

creating badges using mail merge and do not want to supress lines with empty fields

I am using MS Word and Excel to create badges (labels).

I would like to include every line even if the field in a line is empty.
i.e.

FirstName LastName
Title
Company

When I merge the data, records without a title end up appearing like this:
FirstName LastName
Company

I want it to appear like this:
FirstName LastName

Company

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
supress mail merge error document	vincenzo345	Mail Merge	2	10-10-2017 12:03 PM
Displaying FORMTEXT fields when merge fields are empty or null	sfkHooper	Mail Merge	6	01-19-2016 04:24 PM
Creating Barcode Badges using Microsoft Word Mail Merge 2013	Sarah15	Mail Merge	4	04-16-2015 06:03 AM
Mail Merge Empty Data Field	Licos101	Mail Merge	2	04-10-2014 06:19 AM
Merge fields and creating a pop up	kateh681	Mail Merge	0	07-28-2011 10:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:49 AM.