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

[Dino]

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?

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

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.

--
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

 

[Graham Mayor]

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

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Phil Beischer]

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.