Used mail merger to create labels, don't need blanks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dino - 30 Jan 2004 18:08 GMT

I hope someone can help me with this. I used mail merge to
create labels, and then deleted the duplicates on the
label pages. But now I have all these blank labels that I
need to get rid of. Does anyone know a quick way to remove
all these blank labels and condense the label pages to
include only labels with an actual address in them?

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 31 Jan 2004 01:59 GMT

Dino,

The obvious thing is to get rid of the duplicates from the data source. The
best way to do that will depend up what the data source is.

Signature

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 hope someone can help me with this. I used mail merge to
> create labels, and then deleted the duplicates on the
> label pages. But now I have all these blank labels that I
> need to get rid of. Does anyone know a quick way to remove
> all these blank labels and condense the label pages to
> include only labels with an actual address in them?

Reply to this Message

Graham Mayor - 31 Jan 2004 06:32 GMT

While I agree with Doug that you really should sort out your data file, you
could convert the table to text, sort to put all the blanks lines together,
delete them then use the resulting file as a new data document - see
http://www.gmayor.com/convert_labels_into_mail_merge.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I hope someone can help me with this. I used mail merge to
> create labels, and then deleted the duplicates on the
> label pages. But now I have all these blank labels that I
> need to get rid of. Does anyone know a quick way to remove
> all these blank labels and condense the label pages to
> include only labels with an actual address in them?

Reply to this Message

Phil Beischer - 31 Jan 2004 19:55 GMT

I use Excel as a data source for mail labels. If you
delete the rows containing the unwanted label data in the
data source and then remerge you should eliminate the
blanks.

>-----Original Message-----
>I hope someone can help me with this. I used mail merge to
[quoted text clipped - 4 lines]
>include only labels with an actual address in them?
>.

Reply to this Message

Rate this thread: