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...
Category: Market Better
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'
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...
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...
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...
Build A Free HTML Email Template in 60 Seconds Without Knowing Any HTML
If your idea of creating and sending an email campaign starts with using Word and then coping and pasting your content into an email client you're doing it all wrong. I understand you're not a web designer, coder, email marketing guru or techie, and you probably cringe when you see...
Time To Rethink Your Email Marketing Strategy
Admit it—your email marketing strategy has fallen to the wayside. Now is the time to shake the dust off your outdated email marketing strategy and reinvigorate your campaigns. There are thousands of e-mail marketing tools out there, but they all fail in one fundamental way - they're not linked to...
Before You Search In GoldMine
You may have heard the expression “it’s not what you know, but knowing where to find it.” This is certainly true when it comes to your GoldMine database, where your ability to find a piece of information or a record(s) containing that information will depend on knowing how to go...