Goldmine 5.5 Email Distribution List Export

Tools | Import/Export Wizard | Export Contact Records

then, choose your options, i.e. Export to a New File, DBF file, then choose the company, contact, email address as the fields you want to export.

Email addresses are stored in the contsupp table (i.e. contsupp.dbf)

Thanks Steven however what I was trying to export was the email addresses used in specific Goldmine Distribution lists, rather than a set of contacts to make a distribution list in another program.

In short I have reps who are using these lists to email out to their prospects and clients however this early of a version of GM does not handle CAN-Spam compliance very well.  

I am trying to get these lists out so I can use a compliant  third party opt-in email blast company.

Thanks again!

Thank you do you have any suggestions for a decent file viewer/exporter?

See if you can find the br7 utility from redstonesoftbase.com. Also, it's possible you could make some progress with Access. Be sure to work from an off-line copy of the files, so as not to risk damage to your production data.

Ok I have tried both DBFViewer 2000 and the BR7 Utility and I found the groups within the database however the memo field you reference is encrypted for the groups.  See below:

CA6013039084$.`>SHLyn
CA6013039162#;/)VHJoA


Do you know of a way to reverse engineer this?

Thanks!

Not exactly. It's not really encryption. I've never done what you're trying to do, but I can tell you that the codes you're seeing correspond to the accountno field of the contact record; just get rid of that leading C, and you'll see that the balance of the string is the accountno. Link this to the contact1 table.

herodaddy829, have you had any luck with this?