Individuals by Excluded Individual Type Query

This query returns a list of individuals excluding the given individual type. This is useful for sending an e-mail (messaging job) to everyone in the database except exhibitors.

Note: To exclude exhibitors, Exhibitors must be set up as an Individual Type in CRM.

Query Parameters

Parameter	Description
Individual Type Is Not Equal To	Select an individual type from the drop down list.
Member Flag Is Equal To	Select a member flag from the drop down list: Member, Non-Member, All.

Query (Default) Fields

Field	Description
Query Header	Displays the query name, number of records returned, and the total number of pages for the query.
Individual Type	Lists the individual type.
Individual Sort Name	Lists the individual sort name.
Individual ID	Lists the individual ID.
PriAddr Address Line 1, 2, 3, City, State/Territory, Postal Code	Lists the individual primary partial address.
PriPhone Phone Number	Lists the individual primary phone number.
PriFax Fax Number	Lists the individual primary fax number.
PriEMail E-Mail Address	Lists the individual primary email address.