How do you suppress blank lines when merging address labels?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jan Admin Suprv - 28 Aug 2007 22:30 GMT

The old version of mail merge allowed me to suppress black lines on address
labels. I can't find anywhere in the new version that allows that capability.
Anyone know how to do it or if it can be done?

Reply to this Message

Jan Admin Suprv - 28 Aug 2007 22:48 GMT

The message should say "blank" lines!

> The old version of mail merge allowed me to suppress black lines on address
> labels. I can't find anywhere in the new version that allows that capability.
> Anyone know how to do it or if it can be done?

Reply to this Message

Peter Jamieson - 29 Aug 2007 07:57 GMT

Which version of Word?

"Suppress blank lines" is the default anyway in Word 2002 and later. If
necessary you can toggle it on and off in VBA using

ActiveDocument.MailMerge.SuppressBlankLines = True
and
ActiveDocument.MailMerge.SuppressBlankLines = False

or you can re-enable the old Mail Merge Helper using
Tools->Customize->COmmands, select category All COmmands, locate
MailMergeHelper and drag it to a toolbar or menu. Then open the Merge...
option and make the setting.

However, the feature only suppresses blank lines that are formed from at
least one blank MERGEFIELD field, and blank lines are not suppressed if the
line is "inside" another field such as IF. If you are using an ADDRESSBLOCK
field you may also need to scrap that and use individual fields instead.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> The old version of mail merge allowed me to suppress black lines on
> address
> labels. I can't find anywhere in the new version that allows that
> capability.
> Anyone know how to do it or if it can be done?

Reply to this Message

Rate this thread: