Goldmine: Finding Contacts

A client wants to know: We communicate with prospects and customers primarily by email. Is there a way to find contacts without an email address?

Yes, you can use a SQL query to show you all your contacts without an email address.

To do this, select GoldMine’s main menu, choose Lookup > SQL Queries then copy and paste the code below into the top section then click Query. If you are using GoldMine Premium Edition then use Tools > Filters & Groups and the SQL Query tab.

-------------------------------------------------------------------

select company, contact, city, state, zip, key1, key2, key3, key4, key5 from contact1 where accountno not in (select accountno from contsupp where contact = 'E-mail Address' and rectype = 'P') order by company, contact

-------------------------------------------------------------------

You will see your results and if they appear useful use the 'Save' button to reuse this later on. Within the results, you can Right-Click > Output To > Excel to save the results, print them, and further analyze.