Suppress blank lines in mailmerge of excel reports into word document

beefcake2000 · #1 11-10-2017, 07:30 AM

I am trying to mail merge reviewers reports (entered in Excel) into a Word document. When a reviewer hasn’t reviewed a particular proposal (and the field has a “-“), I would like to skip to the next reviewer without leaving a blank line.

My Excel document looks like this (non-changeable, unfortunately as it rolls out of a database in this format): see attached image below

My setup in the mail merge looks like this:
Dossier: { MERGEFIELD Dossier }
Applicant: { MERGEFIELD Applicant }
Title: { MERGEFIELD Title }
Discipline: { MERGEFIELD Discipline}

Criteria I
{ MERGEFIELD Member1 }: { MERGEFIELD M1Comment1 }
{ MERGEFIELD Member2 }: { MERGEFIELD M2Comment1 }
{ MERGEFIELD Member3 }: { MERGEFIELD M3Comment1 }

Criteria II
{ MERGEFIELD Member1 }: { MERGEFIELD M1Comment2 }
{ MERGEFIELD Member2 }: { MERGEFIELD M2Comment2 }
{ MERGEFIELD Member3 }: { MERGEFIELD M3Comment2 }

The Member1-4 always have a value.

It comes out looking line this with skipped lines:

Dossier: 1
Applicant: Joe
Title: a
Discipline: b

Criteria I
x: good
y: -
z: bad

Criteria II
x: good
y: -
z: bad

Dossier: 2
Applicant: Ben
Title: c
Discipline: d

Criteria I
x: -
y: -
z: good

Criteria II
x: -
y: -
z: good

I want it to look like this, ignoring any blank fields and not skipping lines:

Dossier: 1
Applicant: Joe
Title: a
Discipline: b

Criteria I
x: good
z: bad

Criteria II
x: good
z: bad

Dossier: 2
Applicant: Ben
Title: c
Discipline: d

Criteria I
z: good

Criteria II
z: good

Any ideas how to do this?

Thank you in advance,
Paul

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
how to copy addresses in word document to excel/mailmerge list	msnarayanan	Mail Merge	4	10-17-2015 03:17 PM
Suppress Header/Footer on Blank Pages in Book	SQLUSA	Word	5	08-19-2012 03:51 PM
How to Insert a Clear, Blank page without Lines and Numbers in a Pleading Document	Dirigo	Word	5	09-30-2011 08:08 AM
How to turn all blank lines into non-blank for legal forms	sieler	Word	3	04-12-2009 01:38 PM