Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2018, 08:54 AM
johnmorabito johnmorabito is offline creating badges using mail merge and do not want to supress lines with empty fields Windows 10 creating badges using mail merge and do not want to supress lines with empty fields Office 2016
Novice
creating badges using mail merge and do not want to supress lines with empty fields
 
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 creating badges using mail merge and do not want to supress lines with empty fields Windows 7 64bit creating badges using mail merge and do not want to supress lines with empty fields Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
creating badges using mail merge and do not want to supress lines with empty fields supress mail merge error document vincenzo345 Mail Merge 2 10-10-2017 12:03 PM
creating badges using mail merge and do not want to supress lines with empty fields 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 03:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft