I have a long list of email addresses that we use for a newsletter mailing. Every month I go through by hand and delete the bad emails. Isn't there an easy way I could do this in excel with some sort of lookup function or something like that?
I have a long list of email addresses that we use for a newsletter mailing. Every month I go through by hand and delete the bad emails. Isn't there an easy way I could do this in excel with some sort of lookup function or something like that?
In what way are the email addresses "bad"? If it is because they are not in the correct format then you can copy this formula down the list (assumes list is in column A):
=IF(COUNTIF(A1,"=?*@?*.?*"),1,0)
and sort by this new column. Those with 1's are valid names.
Last edited by Ikaabod; 09-25-2008 at 05:56 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks