In version 7.94 and higher:
  1. Create a Constituent query
  2. On the Criteria tab, select:

    Constituent, Phones, Phone Type one of [types designated for email addresses]
    AND Constituent, Phones, Specific Phones, [Phone Type designated for email addresses], [Phone Type] not blank

     
  3. On the Output tab, select Query fields, Constituent Name. (This field ensures there are duplicate rows so each constituent is counted for the number of email addresses on his record. This ensures that we count every single email address in the database, even if one Constituent has multiple addresses)
  4. On the Results tab, the number in the bottom corner is the number of email addresses for constituent records
  5. If you would also like to include email addresses for relationship records:
    1. Create a Relationship query
    2. On the Criteria tab, select:

      Individuals, This Individual Is A Constituent equals No
      AND Individuals, Phones, Phone Type one of [types designated for email addresses]
      AND Individuals, Phones, Specific Phones, [Phone Type designated for email addresses], [Phone Type] number not blank

       
    3. On the Output tab, select Query fields, Individuals Name. (This will also make sure there are duplicate rows so that each individual relationship record is counted for the number of email addresses on his record.)
    4. On the Results tab, the number in the bottom corner is the number of email addresses for individual relationship records
    5. Repeat this process for organization relationship records and add the three totals together
In version 7.93 and earlier versions:
 
  1. Create a Constituent query
  2. On the Criteria tab, select:

    Constituent, Addresses, All Addresses, Phones, Phone Type one of [types designated for email addresses]
    AND (Constituent, Addresses, All Addresses, Phones, Specific Phones, [Phone Type designated for email addresses], [Phone Type] number not blank
    OR Constituent, Addresses, All Addresses, Phones, Specific Phones, [Phone Type designated for email addresses 2], [Phone Type 2] number not blank
    OR [Continue to add the same filter for each phone type designated for email addresses])
     
  3. On the Output tab, select Query fields, Constituent Name. (This field ensures there are duplicate rows so each constituent is counted for the number of email addresses on his record. This ensures that we count every single email address in the database, even if one Constituent has multiple addresses)
  4. On the Results tab, the number in the bottom corner is the number of email addresses for constituent records
  5. If you would also like to include email addresses for relationship records:
    1. Create a Relationship query 
    2. On the Criteria tab, select:

      Individuals, This Individual Is A Constituent equals No
      AND Individuals, Address, Phones, Phone Type one of [types designated for email addresses]
      AND (Individuals, Address, Phones, Specific Phones, [Phone Type designated for email addresses], [Phone Type] number not blank
      OR Individuals, Address, Phones, Specific Phones, [Phone Type designated for email addresses 2], [Phone Type 2] number not blank
      OR [Continue to add the same filter for each phone type designated for email addresses])
       
    3. On the Output tab, select Query fields, Individuals Name. (This will also make sure there are duplicate rows so that each individual relationship record is counted for the number of email addresses on his record.) 
    4. On the Results tab, the number in the bottom corner is the number of email addresses for individual relationship records
    5. Repeat this process for organization relationship records and add the three totals together