Delete Outdated Email Addresses

I own a database SQL 7.0, and in that database there are a large number of outdated email addresses.

Is there a program that can identify the outdated addresses and remove them?

I am not a DBA so please take that into consideration.

Thanks

Dirty_Dawg wrote: I have even considered sending a email that asked them to verify their information as being correct, and when they do that by clicking a verifying link only the good records are in the database.

I think that many of us would not respond to an email like that. To much like recent Paypal and MS scams.

The only real way to do this, lacking any last-login info,  is to send them an email and catch the bounce-backs. If you have last-login info, just wipe the ones over a year old.

Consider getting a similar sounding domain name and a $5 per month unix account somewhere that offers news letters. Send them an email from that account reminding them of all the great features on your site that they should come to look at. Catch the bounce backs.

At the end of the month, cancel the unix account. Your out-of-pocket is $15-$20 US.

You don't want to deal with that may by hand?

If you use the Unix option, put the "TO" email address on some tagged line in the body (e.g. "We have your email address listed as:"). In Unix, you can grep the tagged lines out into a file. You could probably grep the "TO" lines out of the headers, but there might be a few more characters to get rid off, and some mail servers screw with the headers a little.

If you've already gotten the bouncebacks, you should be able to put together a quick asp script to pull the info out into a file that can be run into another script to delete the records with those addresses.