Patrons With/Without Primary Email Address

You can build mail lists for people that have primary email, phone, fax or web addresses. Or conversely, you can build mail lists of patrons that do not have any email, phone, fax, or web addresses.

In the sample picture below, the criteria shows 'Primary Email Address'. You can just as easily search for the other 'primary' fields when adding them to the criteria. So you can use primary email address, primary fax, etc in any query.

The trick is that if somebody:

• has an email address, then the primary email address unique # will be non-zero. If that is the case, use criteria like the picture below, but change it to

  Marketing Primary Email Unique # 0

• does NOT have any email address, then the primary email address unique # will be ZERO. The picture shows the criteria to find people without emails.

This criteria can be combined with just about any other criteria.