|
|
Thread Tools | Display Modes |
#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 |
#2
|
||||
|
||||
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] |
|
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 |