The following SQL Query will display a list of contacts with the same contact name. You can then browse through the list to see if they are any potential duplicates. Select accountno, contact, company, phone1, city, state From contact1 Where contact in (Select contact from contact1 group by contact having...
Author: Jay Dymond
SQL Query – Additional GoldMine Contacts E-mail Address and Email Merge Code
The following SQL Query shows all Additional GoldMine Contacts with their Email Address and Email Merge Code: SELECT Company, ac.contact AS 'Additional Contact', COALESCE(em.contsupref, '')+COALESCE(em.address1, '') AS 'Email Address', em.mergecodes FROM contact1 JOIN contsupp ac on contact1.accountno=ac.accountno JOIN contsupp em on ac.recid=em.linkacct WHERE ac.rectype='c' AND em.contact='E-Mail Address' AND (em.linkacct NOT...
SQL Query – GoldMine Primary Contacts with Primary Email, and Email Merge Code
The following SQL Query will display all of the GoldMine Primary Contacts with their associated Primary Email Address, as well as the Email Merge Code. select contact1.contact, isnull(contsupp.contsupref,'') + isnull(contsupp.address1,'') as Email, contsupp.mergecodes from contact1 left outer join contsupp on contact1.accountno=contsupp.accountno where contsupp.rectype='P' and contsupp.contact='E-Mail Address' and contsupp.zip like...
Is Your PC Running Slow? Maybe it’s time to DEFRAG!!
Defragging is one of those things – like doing the dishes or picking up the clothes off the floor – that you know you should get around to doing, but for some reason it’s so very difficult to find the time to do. There’s no doubt that it’s important. Yet,...
SQL Query – Possible Missed Follow-ups
The following SQL Query shows who you’ve had a call or appointment with in the last 60 days. The list generated can then be used to determine who you've followed up with and who you haven't. You can update/modify the query below to show more or less days and don't...
How to Setup/Configuring GoldMine Email Center for IMAP
GoldMine Premium Edition users are able to use the IMAP Protocol and POP3 Protocol. For most people setting up POP3 is pretty straight forward, however, setting up IMAP is a little different. The following is how to configure IMAP. To do this you will require an IMAP enabled email server...
POP3 vs IMAP vs Exchange/MAPI
POP3, (Post Office Protocol) POP, or Post Office Protocol, is a way of retrieving email information that dates back to a very different internet than we are use to today. Computers only had limited, low bandwidth access to remote computers, so engineers created POP in an effort to create a...
GoldMine Premium Edition 2013.1 now in Beta
The latest version of GoldMine Premium Edition is now going through its final 'beta' testing phase before being released to the public. Whats New in GoldMine Premium Edition 2013.1: Integration with Constant Contact Office 2013 x86 Support (Outlook, Word and Excel links) 50+ Customer and Partner reported issues fixed, including...
Learn How To Create & Code Your Own HTML Emails
Want to learn how to create your own HTML email campaigns? This course is great for anyone who wants to create great looking emails. No prior experience necessary. Attendees should have a strong desire to create email campaigns that just work. We will cover all the basics with examples presented...
GoldMine 9.2.1 Hotfix 6 Released
Note: GoldMine Premium Edition 9.2.1 Hotfix 6 includes fixes from all prior 9.2.1 releases, including hotfix 1 through 5. Transfer set creation fails if there is a missing document several Event log entries when moving an recurring activity on the calendar with having multiple Users activated - The multi-part identifier...