Export Member's Emails

[xtraktor]

hello all

would like to use mail chimp to send newsletter to my members

 how can i get all their email addresses from my invasion board board forum without having to go to my sql database and get it from the table there?

i know there is an app called "

Export Member's Emails" but can i get something free?if possible of course

[Lock Down]

The easiest way would be to do it through the admin panel. In 

Support > SQL Management  >  SQL Toolbox

At bottom place this code for just the email addresses

SELECT emailINTO OUTFILE '/tmp/email.log'LINES TERMINATED BY 'n'FROM members;

Or this to get the name and email information

SELECT name,emailINTO OUTFILE '/tmp/email.log'FIELDS TERMINATED BY ',' LINES TERMINATED BY 'n'FROM members;

[xtraktor]

thanks!ill try this

even though I'm expecting next big version of ip board to natively support mail chimp!

[Lock Down]

You are welcome.

[Verified]

The question(s) in this support topic have been answered and the owner has been able to solve the problem. Because of this, the support topic has been closed and moved.If you have other questions, please open a new topic.