Deleting bad emails automatically

[Jay]

Here's the problem. I have a database table with, say,
4000 records. I do a mailing to the whole list and get
undeliverable email messages for about 700. For most of
these I will probably remove the entire record, as without
emails, they will not be useful. There may be some,
however, for which I would just delete the email while
leaving the rest of the record.

Question. To go through all 700 messages and extract the
bad email addresses is too time consuming. However, even
if I were to get a list of these addresses, removing them
by hand one by one is also too time consuming.

I think it may be possible to use some emailing list
software to generate a list of the bad addresses but once I
get that, I'm looking for a way to compare my master table
with a table containing the bad emails and remove either
the whole record or the email field automatically. Is
there any way to do this in Access?

Thanks

 

[Immanuel Sibero]

Hi

Once you have a list of bad email addresses, you can import that list into a
table. A query matching your master table records with the records in the
bad email table can the be built (ie. the match is done on the EmailAddr
field). You can then
do whatever you wish with the matched master table records - delete the
record, or blank out the EmailAddr field.

You're not spamming these people, are ya?

HTH
Immanuel Sibero