"Once you pop, you can't stop."

Does the subject line above sound familiar? Reply to this email with the product it originally promoted and the year, to be entered in a drawing to win a deluxe ceramic MasterMine mug. The winner's name and company will be published in the next end-user email. Good luck! These attractive mugs that remind software users to record their work in GoldMine and to use MasterMine are now available for purchase! Just check out this link for ordering instructions.

Remember, you can't win if you don't enter! The winner of "Melts in your mouth, not in your hand," is Kaye Pitcher, Admissions Operations Manager for Taylor University at Fort Wayne, IN. She explained, "M&M's. This saying was rolled out in 1954," wistfully adding, "If only I could eat chocolate!" Lisa A. Harris, Database Administrator for Marlin Leasing Corp. in Mount Laurel, NJ, explained further, "This was the same year that Mars started making Peanut M&M's, too."

__________________________________________________________________________________________

Membership in MasterMine Masters is available for a monthly "booster shot" of our product. This is a group of MasterMine users and administrators invited to attend a monthly webinar discussion with the software's developer, Rob Machalek. The recorded sessions are also available afterwards on a special website. Just reply to this email for more information about signing up!

__________________________________________________________________________________________

Tips and Tricks with MasterMine

Need to add fields to an existing MasterMine report?

The easiest way to do this is to simply re-run the report, placing check marks on the desired fields. Many people don't think to do this because they don’t realize how quick and easy it is to create a report using MasterMine, or because someone else generated the report originally and they just "share" it, and may not be familiar with the fields included.

However, sometimes you've done so much work with a report that you're not confident you can recreate it quickly. For these situations, there's MSQuery--MS Excel's back-end query management tool. Full instructions for using MSQuery for this purpose are in Chapter 10 of MasterMine's user manual. MSQuery allows you to drag in additional fields from existing tables, link additional tables, and even modify the Transact-SQL expression by hand.

For those more familiar with Transact-SQL, here's an additional trick that could save you hours and get you quickly to a solution: Get the approved MasterMine SQL syntax for any field from the MasterMine "Create" dialog, which you can then copy and paste into the SQL expression in MSQuery.

1. Start with the MasterMine report you want to change already open in Excel.

2. Go to MSQuery (Click the "Info" button on the MasterMine toolbar, click "Query Text", "Modify Query", "Back", "Get Data")

3. In MSQuery, click the "SQL" button on the toolbar to expose the SQL Expression.

Here, you could modify the SQL query by hand, OR you can use this handy trick:

1. Back in GoldMine, run the MasterMine "Create" dialog.

2. Select a report or template that has the same tables you are using in the existing report.

3. Click the "uncheck" button so that no fields are selected (except required ones).

4. Check on the names of fields you want to add to the existing report.

5. Click on the "SQL Query" menu item to expose the SQL statement as it would be if you ran the report now.

6. Copy the lines you need (field expressions) from the select statement.

7. Now go back to MSQuery and paste the SQL lines into your existing SQL statement, taking care to preserve proper syntax like terminating every field expression with a comma except the last one before the FROM clause, etc.

_________________________________________________________________________________________________

MasterMine V6 is now available
Don't forget, for those who are current on your annual maintenance, MasterMine V6 is now available for download at no cost. Not sure if you are current?
Call Gail at 877-877-7212 x210
It does require new licensing and you will want to have those in hand before installing the new version.
Learn more...

Download all new MasterMIne V6 now

Contact gail@mastermine.net for your licenses.

_______________________________________________________________________

Did you know that you have a MasterMine User Manual available on your computer?

Here are two different ways to access it:

1. Help menu from the "Create MasterMine Report" screen.

2. Start, Programs, MasterMine Software Inc, User Manual (available in Version 6 of MasterMine)

___________________________________________________________________________________________________

MasterMine Value Services

Support

Need a quick boost to get unstuck, or more extensive help with reporting?

MasterMine has flexible support packages to keep the information flowing at reasonable cost!

Training

Quickly get skilled and make the most of your valuable time with MasterMine.

Although MasterMine is easy, basic training gives you a FAST start making top-quality reports in record time.

Custom Reporting

Live, online report writing assistance is the fastest way to get the answers you need NOW!

Our experts have many years of experience helping people like you get the most useful and profitable information from GoldMine CRM Data.

Data Management: Garbage in, garbage out

In skilled hands, MasterMine is a powerful and efficient data management tool.

Together, online, we can help you zero in on bad or missing data, correct it or normalize it so you can deliver truly meaningful reports

_________________________________________________________________________

Please forward this email to anyone else in your company who uses MasterMine, or send us a request to add them to our mailings.

To continue receiving valuable information from MasterMine Software, be sure to add us to your spam filter.

Below are a few common ways to do this.

AOL
1. Open the email
2. Click "add address" icon
3. Verify the sender's contact information
4. Click "save".

Gmail
1. Open the email
2. Click arrow on the right next to "Reply"
3. Click "Add (sender) to Contact List"

Hotmail
1. Open the email
2. Click "save address" in the toolbar
3. Verify the sender's contact information
4. Click "ok"

Outlook 2003
1. Open the email
2. Left-click on the sender icon or right-click on the sender's name
3. Click "add to contacts"
4. Click "save and close"

Yahoo
1. Open the email
2. Click "add to address book" to the right, next to the sender's name
3. Verify the sender's contact details
4. Click "add to address book"

NOTE: To whitelist us at the email server level please contact your ISP or your email providing

company and ask them to add the mastermine.net domain.

If you no longer wish to receive these emails click here.