Blank lines in Label MailMerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CCC - 06 Jul 2005 20:59 GMT

When using the Address Block function in label MailMerge Wizard, the labels
have blank lines where there is no info on that line in that data source
record. In past versions that I was more familiar with, I've been able to
compress (skip) blank lines in address labels so that they didn't appear on
the final document. How do I do this?

Reply to this Message

Anne Troy - 06 Jul 2005 21:11 GMT

Don't use the address block. Instead, use the individual merge fields.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> When using the Address Block function in label MailMerge Wizard, the labels
> have blank lines where there is no info on that line in that data source
> record. In past versions that I was more familiar with, I've been able to
> compress (skip) blank lines in address labels so that they didn't appear on
> the final document. How do I do this?

Reply to this Message

Graham Mayor - 07 Jul 2005 05:14 GMT

As Anne suggests, do not use the address block. To skip the blank lines you
may have to insert conditional fields
eg
{Mergefield Address1}{If {Mergefield Address 2} <> "" "
{Mergefield Address2}"}{If {Mergefield Address 3} <> "" "
{Mergefield Address3}"} etc
See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> When using the Address Block function in label MailMerge Wizard, the
> labels have blank lines where there is no info on that line in that
> data source record. In past versions that I was more familiar with,
> I've been able to compress (skip) blank lines in address labels so
> that they didn't appear on the final document. How do I do this?

Reply to this Message