I need to extract name and email address from GM

[AIPP]

Hi There, Firstly i'm noooo expert with Goldmine, we have been using this in our office for 5+ years, and have over 30,000 contacts listed on it.

Now - i need to extract clients names and email addresses for a mailing campaign and put them into excell or something like that, to then import into our marketing email software.

How on earth do i do this? should i get an extraction tool from the net or is there a simple way of doing this ... please help ... and i must repeat i'm no guru, asp, c+ css is all beyond me, i sell property and i'm excellent at that!!

 

[richardy]

Hi,

Have you looked at Tools>Export?

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.

 

[AIPP]

Hi Richardy - Thanks for the reply - have looked at the tools, export - but i am little lost, I've tried export to a new file> this only shows me 2 options Primary and Additional - from here i'm LOST!! AHHHHHHHHH! do i have to create a filter for this? if so, how do i do this?
Conrad

 

[AIPP]

Actually i should contact the company who installed it! me a der brain!! - we have a yearly support contract - with Kamrin Computers - I'll try these guys and post the responce.

 

[DataDivaJill]

sql query would do the trick. and then output to excel.

select contact1.company,Contact1.contact,contsupp.address2, contsupp.contsupref, contsupp.address1
from contsupp, contact1
where
contact1.accountno=contsupp.accountno and
contsupp.rectype='P' and contsupp.contact='E-mail Address'
order by contact1.company,contsupp.address2

 

[stahlvorhang]

DataDiva - Your SQL query doesn't return the primary email addresses only. It returns all email addresses. How are the primary email addresses are flagged as such in the tables (GM 6.5)

 

[stahlvorhang]

I found the solution to my question regarding how primary addresses are flagged at this post:

http://www.tek-tips.com/viewthread.cfm?qid=480860&page=31

 

[goner]

Note that you will only get the first 10,000 records with such a query -- unless you tweak your ini file to allow the query object to return you more than 10,000 (the default) records...

Doug Castell
Castell Computers

http://www.castellcomputers.com