Adimpact.com

From the monthly archives:

October 2009

It’s getting to be that time of year again, and with it the challenge of figuring out who should be getting what during the holiday season.

There are several different ways of doing this in GoldMine, but let me show you my favorite… This method uses the “Merge” field – and is usable for both primary and secondary contacts.

gm-merge-field

merge-for-secondary

To configure the merge field for Holiday use we just have to change the lookup values for the primary contact, the same merge codes will automatically be used for secondary contacts.

Within the Merge field, either use the Right-Arrow or use the F2 key on the keyboard.

merge-f2-lookup

Single Left-Click on the New button to add different merge codes.  You may want to use a single one or multiple depending on how you handle cards and gifts.  The two I have here are:

HC for Holiday Card and
HG for Holiday Gift.

We use the format:

HC;//Holiday Card (Code, semi-colon, two slashes, and then description).

Only the code will be placed in the field.  With this format you can fit up to 5 codes in the merge code field.  Select one code, as you normally would when using the lookup list, then select a second in the same manner.  GoldMine will automatically place a comma and space between the two instead of replacing one code with another.

multiple-merge-code-example

You can use any number of letters or numbers for the code but all codes should have the same number of characters.  I prefer two which allows up to 5 codes in the merge field but also makes it easy to remember what each is for.  You may want to use HC for Holiday Cards, but H1, H2, and H3 for different levels of gifts…

Get started on this and in our next  entry we’ll discuss getting that list out of GoldMine using SQL queries and the export wizard.

{ 0 comments }

The latest GoldBox enhancements are now available from the Downloads page of the web site.  Here’s a quick summary:

[click to continue…]

{ 0 comments }