Omit invalid email addresses?
I'm adding an email blast feature to an existing database. User clicks a button, a script omits empty email address fields and creates an email to the resulting found set.
The problem is that many of the email addresses are incorrectly entered. Some have an extra space after an address. This causes the script to fail. I also found a few address fields with only a space or two.
Is there a way to omit records with non-valid email addresses?
I would also like to find all non-valid email addresses so they can be fixed.