List of Records without Email Address

[Kudai]

Hi All I'm looking for a report that list all the records within my data base that do not, have an email address

 

[M8KWR]

If its any help then this is the sql query code to show you the list of records, from here you are able to output it to excel etc..

This just shows you the account number and the company fields. If you need to add the contact field then put a "," after the "c1.company," and then on the next line put c1.contact and do not put a "," at the end of the line.

I hope this helps you. Any issue let me know

SELECT distinct
C1.Accountno,
C1.company
From 
Contact1 C1
WHERE 
C1.AccountNo NOT IN
(Select AccountNo from Contsupp where Contact = 'E-mail Address')

 

[Kudai]

Thank you very very much M8KWR it worked like a charm.