Customers with Email Address Query

This query returns a list of customers who have an email address stored in the system.

Query Parameters

Parameter	Description
Customer Type Is Equal To	Select a customer type from the drop down list.
Member Flag Is Equal To	Select a member flag from the drop down list.

Query (Default) Fields

Field	Description
Query Header	Displays the query name, number of records returned, and the total number of pages for the query.
Customer Type	Lists the customer type: Individual or Organization.
Member Flag	Lists the member flag: 1=member, 0=non-member.
Sort Name	Lists the customer sort name.
ID	Lists the customer ID.
PriAdr Address Line 1, 2 City, State/Territory, Postal Code	Lists the customer mailing address.
PriEmail E-Mail Address	Lists the customer email address.
PriEmail Invalid E-mail Address	Lists whether or not the email address is valid.
PriEmail Invalid E-mail Address Reason	Lists a reason an email address is invalid.
PriPhone Phone Number/Extension	Lists the customer phone number and extension.
PriFax Fax Number/Extension	Lists the customer fax number and extension.
PriContact Full Name	Lists the primary contact full name.
OrgChpAff Chapter Affiliate Name	Lists the organization chapter affiliate name.
IndChpAff Chapter Affiliate Name	Lists the individual chapter affiliate name.