Sunday, January 20, 2008

GoldMine Standard - E-mail addresses

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.

1 comment:

Benny said...

The actual indices, fingers other than the actual hublot replica mere seconds hands, along with the bezel that sports activities the ceramic place for your additional little bit of dark have been in tag heuer replica uk, whilst 2 splashes associated with red-colored, employed for the actual Speedmaster piece of software and also the cartier replica from the main chouronograph hands had been additional. From the individual watchpoint, getting observed all rolex replica sale Aspect From the Celestial satellite wrist watches "live, inch this particular item, combining the actual rolex replica uk colour from the precious metal and also the previously mentioned places associated with red-colored appeared to be a little from rolex replica sale amongst all of those other Darkish, Gray, as well as Whitened Aspect From the Celestial satellite wrist watches. The actual tag heuer replica sale is actually, although, which precious metal causes it to be which tiny bit much more dressy as well as stylish. Right now, the actual cartier replica sale. As the Dark Dark is actually certain enjoyable, the actual Message Dark is actually fascinating because of its lume-craze, and also the Sedna Dark is really a little bit much more stylish compared to relaxation, the actual Classic Dark might be probably the most coherent as well as intriguing brand new style from the great deal.