Newsletter Version 002 - March 2009

Enhance Communication With Outlook
Email Integration

With GoldMine Integration Services for Microsoft Outlook (GISMO) you gain a complete view of email correspondence for contacts shared between GoldMine and Outlook. GISMO is a powerful e-mail collaboration tool that connects GoldMine and Outlook to create a complete e-mail history for contacts. This integration empowers users to make better business decisions when communication with customers and contacts, as well as share important information across any client facing division.

Key Benefits:

Increase communication and productivity across the enterprise

Tap into your GoldMine contact records for emailing in Outlook

Instantly view a complete email history for contacts

Features:

Powerful Email Collaboration - Access all your GoldMine contact information when you use Microsoft Outlook.

Seamless Integration - Easily open GoldMine Integration Services for Microsoft Outlook in your Outlook interface.

Automatic Linking - Connect every email message sent and received in Outlook with the appropriate GoldMine contact record for a complete history of communication with contacts.

Address Book Integration - Access GoldMine contacts via the Outlook Address Book.

If you use Outlook as a mail client, GISMO is something that you should definitely look at as a solution to linking mail to GoldMine contact records. Give us a call today and we can provide you more information!
 

---

Intelliclick: Email Marketing with GoldMine

Take Your E-Mail Marketing To A New Level!

Finally You Can See Marketing Results INSIDE of GoldMine!!!!

IntelliClick increases the power of your e-mail marketing campaigns by providing a simple way to track the interests of your message recipients. Newsletters, special announcements, upcoming events and special promotions can all benefit from responsive one click tracking. Your return from IntelliClick is optimized because you pay only for results tracked!

The IntelliClick hyperlink building wizard generates "intelligent" links for your messages. Clicks can be as simple a tracking where and when a web page was accessed or you can go further by alerting personnel at your company when specific web pages are accessed.

One click options make it easy for your e-mail recipients to sign-up for upcoming events or request information. Eliminating the data entry burden of filling forms increase your marketing campaign response rates.

Creating an e-mail campaign takes just a few steps using contact information directly from Microsoft Outlook or GoldMine:

Create your e-mail message and insert "intelligent" hyperlinks using the IntelliClick hyperlink building wizard

As messages are read by your recipients, IntelliClick hyperlinks track their interests and take action based upon the type of "intelligent" link you have inserted in the message.

Alerts are automatically generated and sent to those you designate; Follow-up communication to your customers and/or personnel can also be automatically sent as part of this process.

Tracked information is integrated into your CRM application for further follow-up and future data mining.

Detailed reports provide you with complete contact details and metrics to allow you to measure which campaigns are effective.

Want to see it how it works in real-life? This e-mail newsletter was sent out of our GoldMine database. When you opened this e-mail your record in our database was updating as well. We would be happy to show you what that looks like. Want to see more? Click on this link. It will take you to our website and that too will be recorded in your GoldMine record. Call our sales staff today and discuss how this can be configured to work for you and your company!

---

Going Mobile with GoldMine (Part 2 of 4)

In our last newsletter, we presented a broad overview of the 3 options available:

Companion Link - Sync your contacts, calendar, notes, to-dos, alarms, and more to your phone via a USB connection or Wirelessly over the Internet.

wMobile - Provides FULL contact management features, on ANY web-enabled handheld device, using a LIVE wireless connection.

GoldMine® Mobile - Provides FULL contact management features, on a BlackBerry® device, with online and offline capabilities and INSTANT access to your data residing SECURELY on your phone.

In the issue we will explain Companion Link in more detail. In short, Companion Link is the best solution for clients with basic needs and/or strapped budgets. It works with almost ANY mobile device, BlackBerry, iPhone, Windows Mobile, and Palm OS devices.

For about $100 (or less) per device, with very little effort in most cases, you can synchronize information to and from your handheld for quick and easy access when you're out and about. And for $10.00 per month, do it all wirelessly which minimizes effort and let's you see any additions or changes added to your main GoldMine system.

What other data can be sync'd?

Notes and histories
     - syncs to Notes field of each contact record on the handheld

User-defined fields

Alarms and reminders

Attachment names

Additional/secondary contacts (Pro only)

Opportunities (Pro only)
     - syncs to Tasks field on the handheld

What more can it do?

Select one-way or two-way sync

Select groups or categories to sync

Select date range to sync

Advanced activity mapping (Pro only)

Complete activities on handheld

Exclude personal data from sync

Set timer for auto synchronization (Pro only)

Sync multiple databases using category manager (Pro only)

Sync multiple phones using profiles (Pro only)

Stay Tuned: Our next edition will feature wMobile in more detail.

---

Locating Invalid E-Mail Addresses:

CLICK HERE to view the code in text format so that you can easily apply the code in GoldMine.

SELECT
   accountno,address2
,cs.contsupref+address1 AS 'E-Mail Address'
FROM
   contsupp cs
WHERE
(cs.CONTACT = 'E-mail Address')
AND (SELECT
   CASE
    WHEN cs.contsupref IS NULL
    OR CHARINDEX('@.',cs.contsupref+address1) > 0
    OR CHARINDEX('.@',cs.contsupref+address1) > 0
    OR CHARINDEX('..',cs.contsupref+address1) > 0
    OR CHARINDEX('"', cs.contsupref+address1) <> 0
    OR CHARINDEX('(', cs.contsupref+address1) <> 0
    OR CHARINDEX(')', cs.contsupref+address1) <> 0
    OR CHARINDEX(',', cs.contsupref+address1) <> 0
    OR CHARINDEX('<', cs.contsupref+address1) <> 0
    OR CHARINDEX('>', cs.contsupref+address1) <> 0
    OR CHARINDEX(';', cs.contsupref+address1) <> 0
    OR CHARINDEX(':', cs.contsupref+address1) <> 0
    OR CHARINDEX('[', cs.contsupref+address1) <> 0
    OR CHARINDEX(']', cs.contsupref+address1) <> 0
    OR RIGHT(RTRIM(cs.contsupref+address1),1) = '.'
    OR CHARINDEX(' ',LTRIM(RTRIM(cs.contsupref+address1))) > 0
    OR LEN(cs.contsupref+address1)-1 <= CHARINDEX('.', cs.contsupref+address1)
    OR cs.contsupref+address1 LIKE '%@%@%'
    OR cs.contsupref+address1 NOT LIKE '%@%.%' THEN 0
  ELSE 1
END) = 0