Clients are always asking how they can find primary contacts that do not have an e-mail address. You can accomplish this by running the SQL query below.
* Go to Lookup/SQL Queries and paste the following into the SQL Query box:
SELECT accountno, company from CONTACT1 where accountno not in (SELECT accountno from CONTSUPP where rectype = 'P' and contact = 'E-mail Address')
* Click on save and name the query
* Click on the Query button and it will return primary contacts that do not have an e-mail
* You can then right click in the area where the records were returned and choose Output to
and output the information to an Excel spreadsheet or a Word document
This will also work in GoldMine Premium Edition.