Query Constituents without Active Phone number or Email Address

Hi Jonathan!


Sorry to answer your question with a question but it depends on how you have your phone numbers/emails coded and what version of RE you are on


I'm on 7.93 and I believe it isn't until 7.94 or above where phone numbers/emails are active or inactive


So for me when I'm querying on donors who have email addresses I use criteria like this:


email is blank


I have a lot of different phone number types so if I was looking for a donor without any phone numbers at all on their record the criteria would probably be


home is blank

AND cell is blank

AND business is blank


etc.


If you are on a more advanced version maybe someone else can give you better information

Joanne

You'll need to create a constituent query.


I would suggest for each phone type that you're using to reflect a phone number, you'd have a parenthesis query along these lines:


( Home Number = blank

OR Phone Do Not Contact? = Yes

OR Inactive = Yes )

AND ( Business Number = blank

OR Phone Do Not Contact? = Yes

OR Inactive = Yes )

--------------------------------- Repeat, including emails, cells, phone 2, etc ----------------


This should give you a number of constituents that cannot be contacted via phone or email. The query itself won't create duplicates - they only occur when you output something that is repeatable or Constituents can have multiples of, such as Constituent Codes or Phone Numbers. Use this query, as suggested by Joanne, as the base for an Export or a Query List and you shouldn't have duplicates.

-Andrew