View Single Post
 
Old 11-10-2017, 07:30 AM
beefcake2000 beefcake2000 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Nov 2017
Posts: 10
beefcake2000 is on a distinguished road
Default 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
Attached Images
File Type: png Naamloos.png (6.7 KB, 20 views)
Reply With Quote