What would you like to know more about?

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