Monday, July 28, 2025

How to Handle Blank Member Email Addresses

The Problem
You have a field for member email address in your database, cleverly named Email.

You have some members whose email addresses are blank and you have done what you can to get them but they either don't use email or refuse to cooperate.

You want to make Email a required field.

But if it's required, you won't be able to edit the members whose Email field is blank because you cannot save the record. Because it's a required field.

The Solution
Give the members with a blank Email field a dummy email address.

I suggest firstnamelastname@example.com. For example, Artie Alvarez gets artiealvarez@example.com.

Why example.com?
Because it is a black hole internet domain that exists for, yes, examples. One of its features is that an email message sent to example.com just disappears into an electronic black hole.

Finding the Troublemakers
Do this:

Click the "Filter" button.

Finding the Former Troublemakers
Do this:

Click the "Filter" button.

Finish the Job
Make the Email field required:

Now you won't get any more members with blank Email.