#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 [Fmr MS MVP - Word] |
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 |
How to turn all blank lines into non-blank for legal forms | sieler | Word | 3 | 04-12-2009 01:38 PM |