Were you aware that BVCMS has a Search Builder Condition that looks specifically for invalid email addresses ? These would be email addresses that are not in the correct format - missing the @ symbol, or the dot or having too many letters in the extension.

I spent a little time yesterday going through those records I found using this search on our church database. I was able to fix at least 95% of those addresses. Most were missing the .com after gmail, yahoo, etc. I feel better knowing that these people will now begin receiving our emails!

Of course, there were a few email addresses that I just deleted as there was not enough information there for me to figure out how to correct them.

Click HERE if you are interested in doing a little clean up on your database.

PS When creating new records during an online registration or in the regular application (new members, guests, etc), you will be forced to use a a valid format. However, records that are edited, those that are part of a conversion, etc. may have these emails with invalid formats.