Remove one list of emails from another?
Posted on 2003-02-28
We have a master email list (LIST A) of 250K+ emails. We also have a smaller list (LIST B) of 18K emails from people who have opted-out of our mailing list. If an email from LIST B is found in LIST A, we need to delete it from LIST A.
What is the best method for this? I tried incorporating this into a MySQL database and running DELETE queries for all 18K records, but that ended up taking nearly 2 days of processing time. Any suggestions? Is Microsoft Access able to automate something like this? If so, how? (I'm not familiar with the software)