New to Query? Check out Getting Started with Query (PDF) to understand basic concepts and create your first query—all in a matter of minutes!
 

The steps below use "Email" and "E-mail" as examples, but your organization may use a different phone type. If you are looking for constituents with an email address on the Preferred Address, select Preferred Address instead of All Addresses.

This solution explains how to search for constituent and relationship records with and without email addresses. Click the links below to jump to the steps for each option:

Anchor down arrow How to find constituents with a specific email address

Anchor down arrow How to find constituents without a specific email address

Anchor down arrow How to find relationship records with a specific email address

Anchor down arrow How to find relationship records with a specific email address

Anchor down arrow How to find constituents with any email addresses

Anchor down arrow How to find constituents without any email addresses

Anchor down arrow How to find relationship records with any email addresses

Anchor down arrow How to find relationship records without any email addresses
 

How to find constituents with a specific email address

In 7.93 and before:
  1. Create a constituent query
  2. Filter on Addresses, All Address, Phones, Phone Type equals Email
In 7.94 and above:

      1.  Create a constituent query
      2.  Filter on Phones, Phone Type equals Email

Go to top of page

How to find constituents without a specific email address

In 7.93 and before:
  1. Create a constituent query
  2. Filter on Addresses, All Address, Phones, Phone Type does not equal Email
In 7.94 and above:

      1.  Create a constituent query
      2. Filter on Phones, Phone Type does not equal Email
Go to top of page

How to find relationship records with a specific email address

In 7.93 and before:
  1. Create a Relationship query
  2. For Individual Relationship records, filter on Individuals, Address, Phones, Phone Type equals Email
    For Organization Relationship records, filter on Organizations, Address, Phones, Phone Type equals Email
In 7.94 and above:

      1.  Create a Relationship query
      2.  For Individual Relationship records, filter on Individuals, Phones, Phone Type equals Email
            For Organization Relationship records, filter on Organizations, Phones, Phone Type equals Email



Go to top of page

How to find relationship records without a specific email address

In 7.93 and below:
  1. Create a Relationship query
  2. For Individual Relationship records, filter on Individuals, Address, Phones, Phone Type does not equal Email
    For Organization Relationship records, filter on Organizations, Address, Phones, Phone Type does not equal Email
In 7.94 and above:

      1.  Create a Relationship query
      2.  For Individual Relationship records, filter on Individuals, Phones, Phone Type does not equal Email
            For Organization Relationship records, filter on Organizations, Phones, Phone Type does not equal Email


Go to top of page

How to find constituents with any email addresses

In 7.93 and before:
  1. Create a constituent query
  2. Filter on Addresses, All Address, Phones, Phone Type one of Email, E-Mail
In 7.94 and above:

      1.  Create a constituent query
      2.  Filter on  Phones, Phone Type one of Email, E-Mail

Go to top of page

How to find constituents without any email addresses

In 7.93 and before:
  1. Create a constituent query
  2. Filter on Addresses, All Address, Phones, Phone Type not one of Email, E-Mail
In 7.94 and above:

      1.  Create a constituent query
      2.  Filter on  Phones, Phone Type one of Email, E-Mail



Go to top of page

How to find relationship records with any email addresses

In 7.93 and before:
  1. Create a Relationship query
  2. For Individual Relationship records, filter on Individuals, Address, Phones, Phone Type one of Email, E-Mail
    For Organization Relationship records, filter on Organizations, Address, Phones, Phone Type one of Email, E-Mail
In 7.94 and after:

     1.  Create a Relationship query
     2.  For Individual Relationship records, filter on Individuals, Phones, Phone Type one of Email, E-Mail
            For Organization Relationship records, filter on Organizations, Phones, Phone Type one of Email, E-Mail


Go to top of page

How to find relationship records without any email addresses

In 7.93 and before:

 
  1. Create a Relationship query
  2. For Individual Relationship records, filter on Individuals, Address, Phones, Phone Type not one of Email, E-Mail
    For Organization Relationship records, filter on Organizations, Address, Phones, Phone Type not one of Email, E-Mail

In 7.94 and after:

     1.  Create a Relationship query
     2.    For Individual Relationship records, filter on Individuals, Phones, Phone Type not one of Email, E-Mail
              For Organization Relationship records, filter on Organizations, Phones, Phone Type not one of Email, E-Mail

Go to top of page