Are you already using QuoteWerks to produce sales quotes for your business? QuoteWerks is the #1 quote writing software on the market. Did you know you can now use MS-Word templates for your quote layouts? You still input all of the info into your QuoteWerks quote and a PDF file...
Year: 2013
IntelliClick Announces “OnClick” Tracking within Your Web Pages
DIG DEEPER WITH GOLDMINE IntelliClick now provides you with even more information about your web site visitor behavior. In addition to tracking the pages they browse, now you can track what specific links they view within your web site pages. This "Digital Body Language" input is another way to engage...
Are Your GoldMine Email Marketing Campaigns Failing During The Sending Of The Emails?
Every so often I get a call on the Help Desk from someone who says that their GoldMine email campaign is failing in the middle of the send and they are not sure why. If this is happening to you, the following are most likely the reason(s) and some things...
What’s Fixed in GoldMine Premium Edition 9.2.1 HOTFIX 7 (9.2.1.175)
What's Fixed in GoldMine Premium Edition 9.2.1 HOTFIX 7 (9.2.1.175) Note: GoldMine Premium Edition 9.2.1 Hotfix 7 includes fixes from all prior 9.2.1 releases, including hotfix 1 through 6. Connection failed. access to the host was denied after applying Windows update KB2813170 on x64 Hosts Contact search center (CSC) window...
SQL Query – ALL GoldMine Email Addresses (Primary and Additional)
select contact1.company, contsupp.address2, 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'
Free Disk Space Analyzer
I recently had a customer call in about not being able to save email attachments. Upon investigating the issue it turns out they had run out of disk space on the hard drive that they were storing email attachments on. The hard drive itself was about 500 gigs and it...
SQL Query – Duplicate Contacts
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...
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,...