Mail merge labels

[Shelley]

when creating labels with the mail merge tool, I always encounter the same problem whereby once the mail merge is complete, there are extra (empty) lines at the bottom of the address making the label "uncenter'able". I have to manually go into each label and delete the lines so the label can be centered properly. I have looked through the MS Word bible and could find nothing. Does anyone have any ideas how to avoid this time consuming problem?

 

[Graham Mayor]

when creating labels with the mail merge tool, I always encounter the
same problem whereby once the mail merge is complete, there are extra
(empty) lines at the bottom of the address making the label
"uncenter'able". I have to manually go into each label and delete
the lines so the label can be centered properly. I have looked
through the MS Word bible and could find nothing. Does anyone have
any ideas how to avoid this time consuming problem?

This is caused by the manner in which you enter the data fields. The only
way to be absolutely sure that you only get fields that have data in them is
to use conditional fields for the fields that are causing problems ie so
that they only fill when there is date to be filled.

eg
{IF {Mergefield City} <> "" "{Mergefield City}
"}{IF{Mergefield Zip} <> "" "{Mergefield Zip}
"}etc

Note that the conditional fields are all on the same line and follow without
space. The line feed is inserted in the field construction so only occurs
when the condition is met.

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

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>