Mail labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil Beischer - 10 Jan 2004 18:36 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 10 Jan 2004 22:49 GMT

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

>I am printing mailing labels using mail merge in Word 2002
> from a data source in Excel 2002. Blank labels at the end
[quoted text clipped - 11 lines]
> does not appear that you can choose more than one at a
> time.

Reply to this Message

Rate this thread: