| September, 2001 |
Volume 3, Issue 3 |
||||||
|
We hope you find information that will help you get the most out of your GoldMine. We're
always interested in your comments; click here to send us an
E-mail. This Issue's Topics
Hot GoldMine
Promo
If you own virtually any competitive product (Outlook, ACT, Siebel, SalesLogix …) you can exchange it, license for license, for a mere pittance right now. This special promotion, just announced from FrontRange is not for those who sit and agonize over decisions. The offer is only good through the end of September. If you have a copy of Outlook (and if you ever bought Microsoft Office, you have at least one copy) you can buy a copy of GoldMine 5.5 for just $79. You can buy FrontOffice Sales and Marketing for only $349. Service and Support licenses are going for just $695. If you have 20 copies of Outlook or ACT, you can do this 20 times! This is the best deal we've ever seen. If
you're on the fence, just do it. Call us. We have the paperwork to make
this happen for you.
FrontRange's Annual Dealer Conference was held
last month in Vail, Colorado. For the first time, International Dealers were
competing for the much coveted "Top10" status. And, in fact, four of them
qualified, making it much more challenging for a US based dealer to achieve
Top10 status. Nevertheless, Computer Control ascended to the #3 spot
world-wide for this year. It's our best showing ever and we're proud of our
team's commitment. Copy and paste any Query you're interested in (if you're not sure how to paste, name and save SQL queries into your GoldMine, call us right away and we'll talk you through the process).
RECORD COUNT
Select count(*) from
contact1
RECORDS WITH NO HISTORY
IN THE PAST 30 DAYS
Select accountno,
contact, company from contact1 where accountno not in (select accountno
from conthist where (ondate+30)>=getdate())
count user-defineD fields
Select
count(*) from contudef where FIELD_NAME like "U%"
Sales Person is empty
Select
key1,company,contact from contact1 where key1= "" order by company
RECORDS WITH NO E-MAIL (This
one was in our last Newsletter)
Select
contact1.accountno, contact1.contact from contact1 where
contact1.accountno not in (select contact1.accountno from contact1,
contsupp where contact1.accountno=contsupp.accountno and contsupp.contact="E-mail
Address") Composing HTML E-mails in GoldMine There's been a big buzz about this since the release of 5.0, so we'll try to clear the air a bit. While this seems like a cool thing to do (you know those e-mails you get that look like Web Pages?), it has more than a couple of gotcha's. First, are you sure your intended recipients can read this? If their e-mail hosting service can't handle this type of e-mail, it may look like garbage with the actual html code displayed in the body of the message. Also, you must decide if it's OK that the recipient may read the message after he or she has logged off the Internet. If recipients are offline, and have set their browser preferences to NOT cache Images, all those pretty graphics will display as empty boxes with little red x's in the corner. Of course, all their other HTML e-mails will do the same, so a decision needs to be made. Also, embedded graphics can very adversely affect the size (and download time) of these messages. We have developed a methodology to create e-mail's with graphics that are, by design, very small and don't get in the way of speedy, efficient e-mailing. It requires some thought and careful setup, so give us a call and we'll get you throught the pitfalls.
We're sworn to secrecy but the
word is you'll see welcome enhancements in GoldMine 5.7, due out in
November. Some areas to look for new functionality are Organizational
Charts, Synchronization and Scheduling. We'll keep you posted. When clients ask about GoldMine reference materials, we point them to one of three titles, each with its own emphasis and level of detail. The thing we're most proud of is that all three books were written by CCC folks.
GoldMin
101/102 (for End-users) GoldMine
Admin Click here to view a GoldMine Training Schedule. Click here for detailed Course Descriptions. Reminder - Hardware Services
Did you know Computer Control Corporation is not only a “Top Ten” GoldMine Platinum Dealer, but also a qualified hardware and networking service provider? Keep us in mind when purchasing or servicing computers for your company. |
|||||||
|
Newsletter
Archives
|
|||||||
|
|||||||
|
|||||||