First, we will query on all accounts with an email address:
  1. Click Queries in the menu bar
  2. Click Manage Queries
  3. Select a category that you want to store this query in
  4. Click New Query under Tasks
  5. Name the query "Accounts with an email address"
  6. Set the Starting Query to Base/All Constituents
  7. Set the Data Return Type to Accounts
  8. Under Criteria Options mark Match each criteria
  9. Under Browse Fields select Account from the drop down menu and click on Email Address
  10. Check Field Has Any Value
  11. Click Save and View Queries

Next, we will create a compound query to subtract out all of the accounts with an email address (the query created above) from all constituent accounts in your database:
  1. Click New Compound Query under the tasks menu
  2. Name the query "Accounts without an email address"
  3. Set the Data Return Type to Accounts
  4. Select the Subtract icon under Combine the Queries
  5. For Query 1 select Category: Base and Query: All Constituents
  6. For Query 2 select "Accounts with an email address" (the query we created above)
  7. Click Save And Preview

The compound query we created will contain all accounts without an email address.

This required two queries because if we try to create one query using the Email Address field, and check off 'Field has no value', we may return some accounts that have multiple Personas if one of those Personas is missing an email address. For example, if a constituent has both a Business and Personal persona, but only the Personal persona has an email address, that constituent would be returned if we create one query with 'Field has no value' checked off within the Email Address field, because their Business Persona does not have an email address present. For that reason, it is better to create one query that finds accounts with an email address on any persona, and then subtract those accounts from all accounts in your database so you are only left with those that do not have an email address entered on any persona.