|I have been working with mailing lists for years, so I am familiar with all of the issues that you mentioned, including the wasted cost of mailing multiple pieces to the same address.|
My only point was that we have no idea if the OP database contains 10K addresses or 20. We don't know why there are duplicates addresses or anything else about his layout or database structure.
We also don't know his level of Excel expertise. What's easy for some (an Advanced Filter or a sort on multiple columns) might not even be something the OP is aware of.
I'm simply saying that in this case, we can't make the assessment that there is "no easy way" until we know what we are dealing with.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.