The following SQL Query will display all the email addresses in your GoldMine database that will not be deliverable if you attempt to send to the contacts associated with the email address. Running this query will allow you to update/correct the addresses and cleanse your database for better email marketing....
Month: February 2010
How to Copy/Move Contacts From One GoldMine Database to Another
Many GoldMine users prefer to have seperate databases for their Prospects and Customers, and when a Prospect finally becomes a Customer they simply Copy/Move the contact from the "Prospects" Database to the "Customers" Database. Here is how to do it: 1. Ensure you have current backups of both databases. 2. In...
How to Suppress a GoldMine Word Merge Field if the GoldMine Value is 0 or Empty
1. In your Word template, put the cursor at the position you want the field. 2. Press CTRL + F9. 3. This puts a blank field code in the documents. Your cursor is now between the braces. 4. Type the word IF then a space then the " symbol. 5....
How to Easily Find Duplicate GoldMine Contact Records Based on Company
GoldMine has really good duplicate checks on the entry of new records (checking on one or combination of fields) and also the merge-purge feature. Here's a quick SQL Query you can run in GoldMine (go to your Filters and Groups, and click on the SQL Query Tab) to check on...
How Many Emails Can I Preview / See In My Inbox?
Did you know that GoldMine's e-mail inbox, and each e-mail center folder can only display 1000 e-mails at any one time. So it is really important to file or delete your e-mails if you are receiving large numbers into your inbox. If you don't when you go to retrieve new...
How To Make GoldMine’s E-mail Template Name Something Other Than The Subject Line
When designing E-mail Templates, normally the default subject line of the template will be the name of the template in the Document Management Center, as you saved it. This does not have to be the case. Design your template, and make the subject line the default as you wish it...
How to Close / Exit Out Of GoldMine Properly
Get into the habit of closing GoldMine correctly. There is a right way and a wrong way to close GoldMine. To exit GoldMine, go to File and click on Exit. Resist temptation to use the X in the upper right of your screen. When you close by File >> Exit,...
GoldMine SQL Query- Primary Contacts and Primary Email Address with Email & Mail Merge Code
The following is a SQL Query that will display the Primary Contact with their Mailing Address, Email Address and the associated Email Merge Code and Mail Merge Code. Select c1.Accountno, c1.Company, c1.City, c1.Address1, c1.State, c1.Zip, cs.ADDRESS2 as Primary_Contact, cs.CONTSUPREF as Email_Address, cs.Mergecodes as Email_Merge, c1.Mergecodes as Mail_Merge, cs.zip From contsupp...
Automatically Update The ‘Dear’ Field With First Name When Contact Field Is Filled In
The script below when added to the lookup.ini file will automatically populate the Dear field when a name containing at least two words are entered into the Contact field. Lookup.ini Script [AutoUpdate] Contact=Dear [Dear] Lookup1=Contact Otherwise=&trim(substr(contact1->contact, 1, at(" ", contact1->contact))) Overwrite=1 Instructions for use. Open the lookup.ini file (Notepad is...
My SQL Query Window Only Shows 10000 Records
When running sql queries in the GoldMine SQL query window by default it will only show the first 10000 records of the results. This can be expanded by adding the following line into the [goldmine] section of the gm.ini file. Sqlquerylimit=xxxxxx Where xxxxxx is the number of records you wish...