Address Labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Angie - 18 Nov 2004 19:14 GMT

I am printing labels with Mail Merge. Some of my names
have 2 address lines & some only have 1. How can you
condense the labels with only 1 line so it doesn't print
the blank line?

Reply to this Message

Graham Mayor - 19 Nov 2004 07:54 GMT

Use a conditional field to insert the second address line and the line feed
before it only when it has content. If we assume that your two address line
field names are Address1 and Address2 then

{Mergefield Address1}{IF {Mergefield Address2} <> "" "
{Mergefield Address2}"}
etc

Signature

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

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

> I am printing labels with Mail Merge. Some of my names
> have 2 address lines & some only have 1. How can you
> condense the labels with only 1 line so it doesn't print
> the blank line?

Reply to this Message