Report: Contacts filtered by missing Email Addresses
e.g. Which contacts do not have an email address in CRM so that we can start updating/enriching our data
Details
I have a report listing all Contacts.
In the Select area I want to select where Contact>EmailAddress is null
Because the email address is not stored in the contacts table the report appears to only look at contacts that have an email address record and therefore I cannot list those contacts that do not have an email address.
Is there a way around this issue?
We are using 4.1 on several CRM systems including SugarCRM CE and SuiteCRM.