View Single Post
 
Old 04-25-2018, 08:54 AM
johnmorabito johnmorabito is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2018
Posts: 1
johnmorabito is on a distinguished road
Default 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
Reply With Quote