How to Find your GoldMine contacts without an email address

… In today’s economic environment having every bit of information you can have about a contact is incredibly important.

For quick, easy, and cheap communication perhaps none is as important as an email address.

So here’s a SQL query that will show you all your contacts without an email address!

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

To use this, from GoldMine’s main menu choose Lookup | SQL Queries then Copy & Paste the above in the top section then click Query.  If you are using GoldMine Premium Edition then Tools | Filters & Groups and then the SQL Query tab.

 

You’ll see your results.  If you find this useful use the 'Save' button to reuse this later on. Within the results, you can do a Right-Click | Output To | Excel to save the results, print them, and further analyze!

 

To learn more about how SQL Queries & eMarketing with GoldMine check out…

Tagged as: Goldmine SQL Emarketing CompanionLink CompanionLink Discount E-markeitng E-mail Address