Mail labels

[Phil Beischer]

I am printing mailing labels using mail merge in Word 2002
from a data source in Excel 2002. Blank labels at the end
of the list are being printed out with zeros. Can this be
eliminated?

The data source is obtained using Advanced Filter copied
to another location and the copy to range has been
purposely made larger than required to accomadate future
growth of the list. This appears to be the source of the
blank labels that Word is printing the zeros on.

I note that you can delete individual labels in step 6 of
the Mail Merge Wizard but I have over 100 to delete and it
does not appear that you can choose more than one at a
time.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Phil,

If you execute the merge to a new document, you could delete the zeros from
the labels in a maximum of two steps, - All of the unwanted rows and then
the empty (0) cells on the last row with data.

Another thing to check is in Excel if you suppress the display of zero
values. Or you may be able to use an IF function in Excel to force the
cells that are zero to be empty ("")

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP