Purge Excel List

[computeruse]

I have a mailing list in excel. I have another excel file with my current client list. I need to send out a mailing to the mailing list but included in the mailing list, there might be some current clients and I do not want to send to people who are current clients. Is there a way to purge the mailing list?

[MarvinP]

Hi computeruse and welcome to the forum,

In Excel 2007 there is a way to delete duplicates. If you can get both sets of data in the same worksheet you might be able to delete all records with the same mailing address.
Here are some sites that explain the process
http://www.mrexcel.com/tip138.shtml
There are also some add-in programs that may do what you want.
http://www.office-excel.com/excel-ad...FQYnbAodVC_goQ