Mailing Labels Alterations?

[Guest]

I have an Excel spread sheet data source I'm using to create an address
block. How do I change which elements get used in an address block? I want
to have addresses set up so that, for example, Field 1 appears first ONLY if
filled with data; otherwise, Field 2 appears first. But I'm confused over
how to establish fields and sequences in the label master document.

 

[Anne Troy]

Don't use the address block. Use the individual merge fields instead. This
should help you:
http://www.officearticles.com/word/insert_merge_fields_in_microsoft_word.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Guest]

When creating the label document, the Mail Merge Toolbar has a command button
that says Word Fields, you can insert an If field to evaluate field 1 and if
blank, place Field 2

 

[Graham Mayor]

As others have indicated you need to abandon the addressblock field and use
the individual fields in a conditional field that places the fields and
associated spacing as required eg

{IF {Mergefield Field1} <> "" "{Mergefield Field1} "}{Mergefield Field2}
Note the positions of the spaces.

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm may help also.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>