Getting a list of email addresses from forum members

I'm trying to collect the email addresses from my forum to start a email blast group but I have over 20,000 members so I'm trying to figure out is there anyway or any mod I can get that will generate a list of all the email addresses without me manually going threw each one?

simply query your database to select all your members email, and write down the result... this may be a 5 seconds query...

[Symbian Galaxy]

can you tell me the query?

SELECT email from " . TABLE_PREFIX . "user

ya know, if you can't figure this out, ask a coder to code the tool for you.

---NOT ME!

[Symbian Galaxy]

i dont have ne table prefix wat will be the query in that case

[Yours]

table prefex is almost always db_

[0tolerance]

uhm... dude, just go into phpmyadmin and run the query... your host should provide it.