Suppress blank lines in mailmerge of excel reports into word document
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
|