Return records with no data in a cell

Freeman3030

New member
Local time
Today, 13:54
Joined
Apr 4, 2015
Messages
1
Hi all,
Just hoping someone can help with what is probably a really simple question!
I've got a database of club members with names, addresses, contact info etc.
I need to send letters by post to those members that I don't have email addresses for. I have no idea how to create a query to return a list of people whom I don't have email addresses for.

I know how to mail merge the info with the letter I've written in word, I just don't know how to group people who's email address cell is empty.
Any help would be much appreciated!
Thanks
 
In a query, put

Is Null

In the criteria for the email address.
 

Users who are viewing this thread

Back
Top Bottom