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

Yarikh · #1 09-19-2018, 07:41 AM

Hello everybody.
I have a problem with the creation of a list with mail merge.

I have to translate an archival inventory from excel to word.
The colums of my table can be divided into two kinds: the ones that are always needed, and the optional ones. Also I need to put a label before certain fields.

For exemple:
ID, title, year, collocation are present in every record.
Content, notes are present only when needed.
_______
I created the template with mail merge using the IF function, so that when the optional fields are not empty it is showed "Label: blah blah blah", and when said fields are empty nothing is showed (not even the label).

My problem is that when a field is empty, it remains an empty row I would like to remove. Here an example:

ID: 1

Title: Human resources
Content: personal dossiers of the employees.
Note: Reserved informations.
Year: 2000

ID: 2
Title: Paid bills
[HERE I FIND AN EMPTY ROW]
[HERE I FIND AN EMPTY ROW]
Year: 2001

I would like my second record to appear:

ID: 2
Title: Paid bills
Year: 2001

_______
I attach some file so you can better understand the problem.

Thanks a lot!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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