Sometimes you need to isolate users who lack an e-mail address, especially if these are clients or hot prospects. Having a working e-mail address can be crucial for successful marketing or support.

If you are a SQL user of GoldMine, getting a list of those lacking an e-mail address is very easy:

1)    Create a basic “Prospect Analysis” or “Main Contact” report in MasterMine as you usually do under GoldMine’s “View” or Go To” menu.

2)    Click on “PrimaryEmailAddress” to include that pseudo-field.

3)    Then, in your report, pull the PrimaryEmailAddress field into the page area.

4)    Select the null item (the first one in the dropdown list).

5)    Drilling down will create a list of accounts with no email address.

If you are a dBase user of GoldMine, it’s a little more tricky:

1)  Run the “E-mail with Contact2″ report, which is in the GoldMine Administrator toolkit. (Click “Templates,” “GoldMine Administrator,” then in the dropdown menu, select “E-mail with Contact2″).

2) This will give you a report of every user, whether they have an e-mail address or not.

3) In the dropdown for the field in your column area, “Priority,” uncheck “Primary” and “Secondary,” which will leave only “None,” meaning that the contact has no related e-mail address.

4) That will leave a list of accounts with no e-mail address.