Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
  #2  
Old 04-25-2018, 02:33 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,199
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 beholdmacropod is a splendid one to behold
Default

If you add the Mail Merge Helper button to Word's QAT, you can do the merge setup as per normal but, instead of clicking on Finish & Merge, click on the Mail Merge Helper button and choose:
Merge>When merging records:Print blank lines when data fields are empty>Merge.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 07:10 PM.


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