Streamlining NOD Lists & Organization

[Lian L.]

Hello, folks.

I'm trying to get information about compiling NOD lists. I have the latest NOD list, but the problem is that each week I'll be getting another list. How do I compile this information intelligently going forward?

Also, when I get mailers that come back because of bad addresses, how can I effectively organize the info so that I don't send mailers to them.  

And what about people that request to be taken off of the mailing list? I'd like to honor their request.

Because these lists come to me in an Excel spreadsheet, I could just blend the new list to the old, but then the bad addresses show up again as well as the people who request to be taken off.

This is a big problem.  How can I streamline my process going forward?  Is there a way to do it in Excel?  Is there another tool I should investigate?

Thank you all in advance for any help you may help.