Thursday, January 28, 2010

GoldMine: Finding Email Merge Codes

We need to get a count of Additional Contacts based on various criteria. Is there an easy way to do that?

You can identify different types of additional contacts using email merge codes. Then you can search additional contacts based on a merge code. This could be used to get a count, or even to generate a targeted list.

The query below can be pasted into GoldMine’s query window. Before you run the query you just enter the Merge Code you’re looking for in the query where it says 'ENTER MERGE CODE' (leave the single quotes).

Select Contact1.Company, Contact1.Contact, Contsupp.contsupref, Contsupp.address2 from Contact1, Contsupp where Contact1.Accountno = Contsupp.Accountno and like 'E-mail Address' AND contsupp.mergecodes like 'ENTER MERGE CODE'

After you run it and test it, press “Save” so you can use it again in the future. Then by just changing the Merge Code you can get results for any Email Merge Code you need.

No comments: