First, we will find all the accounts that should not receive mail:

  1. Click Queries > Manage Queries
  2. Select a category that you want to store this query in (Ex: Base)
  3. Click New Query under the Tasks menu
  4. Name the query Do Not Mail
  5. Set the Starting Query to Base: All Constituents - A
  6. Set the Data Return Type to Accounts
  7. Select Match At Least One Criteria under Criteria Matching
  8. Select UDFs - Constituent from the Browse Fields drop down menu
  9. Select Mailing Status from the list of links
  10. Check Deceased, Do Not Mail, Bad Address, etc.
  11. Click Save And - View Queries
Second, we will remove the Do Not Mail accounts from the standard All Constituents query:
  1. Click Queries > Manage Queries
  2. Select a category that you want to store this query in (Ex: Base)
  3. Click New Compound Query under the tasks menu
  4. Name the query Clean Mailing List
  5. Set the Data Return Type to Account
  6. Select Subtract under How Would You Like The Results Of Each Query To Interact?
  7. Set Query 1 to  Base: All Constituents - A
  8. Set Query 2 to  (Ex: Base): Do Not Mail - A
  9. Click Save And - Preview
This Clean Mailing List query can be used as the Starting Query for another query if you need to further define your mailing list.

If you are building a series of queries that are added, subtracted, or intersected together, it is better to leave the last step in the process as a compound query which removes the "Do Not Mail" query mentioned above. That way you can ensure that no unwanted accounts slip into the results.