To include only a primary email address and constituents without an email address: 
  1. Go to Analysis > Information Library.  Click Add an ad-hoc query.
  2. Select the source view you need to complete your query.
  3. From the left hand column expand Constituents
    1. For a membership query, From the left hand column expand members > then expand Constituents
  4. From the left hand column select  Email Addresses
  5. From the middle column drag Primary email address to Include records where. Set the criteria to be: Email Addresses\Primary email address is equal to Yes
  6. To also include constituents without email addresses, from the middle column, drag Email addresses to Include records where. Set the criteria to be: Email Addresses\Email Address is blank.
  7. In Include records make sure an OR statement appears between these two fields
User-added image
  1. Group the two fields together using the parenthesis.
    1. In Include Records Where, select  Email Addresses\Primary Email address and click Add Left Parenthesis button. 
    2. In Include Records Where, select Email Addresses\Email Address and click Add Right Parenthesis button.
  1. From the middle, drag email address to Results fields to display



To include only a primary phone number and constituents without a phone number: 
  1. Go to Analysis > Information Library.  Click Add an ad-hoc query.
  2. Select the source view you need for your query.
  3. From the left hand column expand Constituents
    1. For a membership query, From the left hand column expand members > then expand Constituents
  4. From the left hand column select  Email Addresses
  5. From the middle column drag Primary phone number to Include records where. Set the criteria to be: Phones\Primary phone number is equal to Yes
  6. To also include constituents without phone numbers, from the middle column, drag Number to Include records where. Set the criteria to be: Phone number\Number is blank.
  7. In Include records where, make sure an OR statement appears between these two fields
User-added image
  1. Group the two fields together using the parenthesis.
    1. In Include Records Where, select  Email Addresses\Primary Email address and click Add Left Parenthesis button. 
    2. In Include Records Where, select Email Addresses\Email Address and click Add Right Parenthesis button
  1. From the middle column Select Phones fields, drag Number to Results Fields to Display.