Thank You!
It worked like a charm!
Have a great day, Karen

"Daryl S" wrote:

Karen -

With the records filtered to unique ones, copy the data and paste it into a
new worksheet. Then drive your mail merge off the new worksheet.
--
Daryl S


"Karen" wrote:

Using Excel 2003
I have a spreadsheet that has several hundred rows and 5 columns. I want to
do a mail merge and create labels with the records. The problem Im having is
that there are many rows of data that are duplicates. FYI - If there is a
duplicate entry, all of the columns will be the same data, not just one
column.

First I went to Data Filter Advanced Filter Filter the List, in-place
Unique Records Only. It then hid the rows with the duplicate data. When I
do a mail merge to create some labels, it includes my duplicate records
(hidden rows) and I dont want that.

Is there a better way to do this? What I really need to do is delete the
duplicates and not just hide them. That way they will not be included in the

Does anyone have any suggestions?
Thanks, Karen