Title
Omit invalid email addresses?
Post
Hi
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.
Thanks
If "invalid" means that there is a space present in the field, use this criteria to find all such records:
" "
And you can probably use Replace Field Contents with the Trim function in a calculation to remove leading and trailing spaces from this field.