Bad Emails - Advanced Find (adding lots of entries)

[srm]

I have O2003. We are cleaning out bad email addresses from our Outlook
file. There are about approx 500 bad emails and I see two ways of
doing this. Seach for the email and update the contacts 500 times.
Use Advanced Fine entering all the bad emails and saving the Advanced
find file. I can then add additional bad emails and run the searches
again in the future. Once I complete each search I can then move all
the contacts to a folder and do a group update on the email address
deleting each bad email address.

The question I have is there any automated way to get the names into
the Advanced search criteria. The field and condition always starts
blank. Even if there is no automated way of copying lots of names at
once, is there a way to keep the Field and condiiton the same every
time I add a name to the list. Each time the field and condition are
removed.

If there are any other suggestions to clean out bad emails other than
what I mentioned above, please let me know. I have all the bad emails
in Excel.

Thanks

Shawn

 

[Diane Poremsky [MVP]]

Huh? I'm guessing you are talking about contacts:

If many of the addresses have a common theme - like changing all @abc.com to
@nbc.com, export to excel and use find and replace to make the changes then
import. You could probably use Excel to compare the sheet you have with an
exported sheet and make the changes from there, then import.

 

[srm]

Diane:

Thanks, unfortunately that is not the case. I have about 20,000
contacts. We just completed a number of emails on different subjects
and a number of the emails came back as not being delivered. Of the
500 emails that were returned, we stripped out the email addresses of
the returned emails and placed htem in an Excel file I now want to go
back into my Outlook file and delete the emails from all the contacts
that were bad.

If I export out, I'm now exporting about 15,000 email address not
knowing which email addresses are bad. They are not unique as
mentioned above.

The only options I can see concerning how to remove the items was to
saearch for each email address and update the contact or use Advanced
Find with looking for "E-mail" <contains> "XZY". It just takes a long
time to add this many criteria to the Advance Find criteria.