Your Knowledge Base is moving on 3/25/24! Our new Help Center provides all the articles you know and love (plus so much more) in a one-stop shop. Ask your SPoC for details!

Email Address No User

 
Difficulty: Basic
Description: Contacts who have an Email Address but no User Account
Page: Contacts
Features: Default Field List
Criteria

The criteria can be created easily using the Advanced Search by selecting the three fields and values. Alternatively, you can paste the following criteria into the Filter.

User_Account_Table.[User_ID] IS NULL
 AND Contacts.[Email_Address] IS NOT NULL
 AND Contacts.[Company] = 0
Field List

This example has cleared the Field List so the defaults are used.

The View in Advanced Search

The View in Setup Area

Screenshot of the View Grid