[gish]

Hi

I have a people subscribing to a newsletter option on of my client's websites. Their addresses are stored in a MySQL table, i have successfully composed a mailshot using forms and BCC: mailed a "bulk" mailshot of about 10 test email addresses and it seems to be okay.

However, the real email list is already at 800+ addresses and growing quite rapidly.

Can BCC: handle so many addresses or is there a limit ?

Or should i be looking at an alternative ?

Thanks


gish

[FieroEtnl]

I believe there is not real limit to how many addresses you can put into the BCC list for a mail; the problem is the more address you put into BCC, the longer it takes for the server to send the e-mail out. With 800+ people I can imagine it would get pretty slow. You might be better off using a CGI script to do what you're trying, but as far as I know what you're doing should work.

Michael

[girish_gupta]

Here is the code I use for the mailing list on my site:

The first page contains a form:
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
<form action="http://www.musicgoeson.com/admin/mailinglist/send.php" method="GET">
<b>Subject:</b><br><input type=text name="subject" size="88" value=""><br>
<b>Message:</b><br><textarea name="message" rows="15" cols="76"></textarea><br><br>
<input type="submit" value="Submit" align="absmiddle">
</form>
[/code]

send.php contains...

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
$email = 'webmaster@musicgoeson.com';

$query = "SELECT * FROM mailinglist";
$result = mysql_query($query);

while ($rega = mysql_fetch_array($result)) {
mail($rega["email"],
$subject,
"$message",
"From: $emailnReply-To:$emailnX-mailer:PHP/". phpversion());
}
mysql_free_result($result);
[/code]

This pulls the e-mail addresses from a mySQL table (mailinglist) which has two columns: id and email.

------------------
Girish Gupta
MusicGoesOn.com