First, we’ll create a query to find everyone who has an email address:
  1. Click Queries
  2. Click Manage Queries
  3. Select the category where you would like to store this query
  4. Select New Query under the Tasks menu
  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 Matching select Match Each Criteria
  9. Select Account from the Browse Fields drop down menu and click on Email Address
  10. Mark the checkbox for Field Has Any Value
  11. Click Save and View Queries
Then, we’ll create a query to find the people who have a full mailing address:
  1. Select New Query under the Tasks menu
  2. Name the query Accounts with a Full Mailing Address
  3. Set the Starting Query to Base/All Constituents
  4. Set the Data Return Type to Accounts
  5. Under Criteria Matching select Match Each Criteria
  6. Select Account from the Browse Fields drop down menu and click on Address Lines
  7. Mark the checkbox for Field Has Any Value
  8. Select Account from the Browse Fields drop down menu and click on City
  9. Mark the checkbox for Field Has Any Value
  10. Select Account from the Browse Fields drop down menu and click on State
  11. Mark the checkbox for Field Has Any Value
  12. Select Account from the Browse Fields drop down menu and click on Postal Code
  13. Mark the checkbox for Field Has Any Value
  14. Click Save and View Queries
Last, we’ll create a compound query to find the people who have an email address, but do not have a mailing address:
  1. Select New Compound Query under the tasks menu
  2. Name the query
  3. Set the Data Return Type to Accounts
  4. Under Combine the Queries select Subtract
  5. For Query 1 choose Accounts with an Email Address
  6. For Query 2 choose Accounts with a Full Mailing Address
  7. Click Save and View Queries