Bulk e-mail

I suggest you install Organic Groups and use that to do the mail out

Using php compiled as a cgi, write the following to a file called emails.php (changing the details where appropriate for your database):

#!/usr/bin/php -f
<?php
$user="MyDatabaseUser";
$password="MyDatabasePassword";
$database="MyDatabase";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$result=mysql_query('select mail from users where uid>1;');
for($i=0;$i<mysql_num_rows($result);$i++) {
  printf("%s\n", mysql_result($result,$i));
}
mysql_close();
?>

When run from the command line of your web server (NOT AS A WEB PAGE!), this will print out all the email addresses of your user table, one per line. Redirect output to a file, and then what you do with them is up to you. ;)

Discussion thread: http://drupal.org/node/114293

Original thread: http://drupal.org/node/106944

Module code: http://pali.sirimangalo.org/files/mass_contact/