Getting a list of email addresses from forum members

[tuslic]

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?

[Dismounted]

You could probably build something like this:
$emails = $vbulletin->db->query_read("
SELECT `email`
FROM `" . TABLE_PREFIX . "user`
");

while ($user = $vbulletin->db->fetch_array($emails))
{
echo $user['email'];
}