Microsoft Office Forums Suppress blank lines in mailmerge of excel reports into word document

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2017, 07:30 AM
beefcake2000 beefcake2000 is offline Suppress blank lines in mailmerge of excel reports into word document Windows 7 64bit Suppress blank lines in mailmerge of excel reports into word document Office 2010 64bit
Novice
Suppress blank lines in mailmerge of excel reports into word document
 
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, 11 views)
Reply With Quote
  #2  
Old 11-10-2017, 12:54 PM
macropod's Avatar
macropod macropod is offline Suppress blank lines in mailmerge of excel reports into word document Windows 7 64bit Suppress blank lines in mailmerge of excel reports into word document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,482
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

See Mailmerge Empty Line Suppression in the Mailmerge Tips and Tricks Sticky thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
Since your data apparently contains '-' in the 'empty' records, you'll need to use the IF test approach and change the "" to "-".
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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
Suppress blank lines in mailmerge of excel reports into word document How to turn all blank lines into non-blank for legal forms sieler Word 3 04-12-2009 01:38 PM


All times are GMT -7. The time now is 02:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft