Mail merge: remove empty rows when a field is not showed

		Microsoft Office Forums > Microsoft Word > Mail Merge
Mail merge: remove empty rows when a field is not showed

FAQ

Thread Tools

Display Modes

09-22-2018, 04:22 PM

macropod

Windows 7 64bit Mail merge: remove empty rows when a field is not showed

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,371

If you need to skip entire labels, you should apply a mailmerge filter with the required criteria, which you do via Mailings|Edit Recipient List>Filter.

As for the field coding I described, see the attached.

Attached Files

MailMerge Main Document.docx (17.3 KB, 66 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

if rule, mail merge

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
creating badges using mail merge and do not want to supress lines with empty fields	johnmorabito	Mail Merge	1	04-25-2018 02:33 PM
Delete All empty Rows - Print - Undo all Rows deleted	Bathroth	Word VBA	1	10-01-2014 01:40 PM
Mail merge how to link mail merge field value to a column heading	dsummers	Mail Merge	1	05-08-2014 02:59 PM
Mail Merge Empty Data Field	Licos101	Mail Merge	2	04-10-2014 06:19 AM
How to ignore a mail merge field if the field is blank	redzan	Mail Merge	1	05-16-2013 08:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:45 AM.