BCC

[scuba]

Hi, I've been looking at the manual and am Still having problems with my code. Currently the person in the $to get an email but nobody in the BCC get's an email. Can anyone help?

/ EMAIL TO ALL EVERYONE /

$result = mysql_query("SELECT DISTINCT(Email) FROM Distributor");
if (!$result) { echo("<P>Error performing query: ' . mysql_error() . '</P>"); exit();}

while ($row = mysql_fetch_array($result)) {

$Email = $row["Email"];

$display_block .=" $Email, ";
}

$sql = mysql_query("SELECT DISTINCT(Email) FROM Subscriber");
if (!$sql) { echo("<P>Error performing query: ' . mysql_error() . '</P>"); exit();}

while ($row = mysql_fetch_array($sql)) {

$subEmail = $row["Email"];

$display_block .="
$subEmail, ";
}
$headers = "From: $fromname <$fromaddress>\n";
$headers.= "Reply-To: $fromaddress\n";
$headers.= "BCC: $display_block";

$to = "[e-mail]";

mail($to, $Subject, $words, $headers);

echo ("You mailing has been sent to: $display_block .");
mysql_close();

Thanks,
Steve

[djg_uk]

Hi Steve,

I remember reading somewhere that BCC is case sensitive. Try Bcc.

Kind Regards,

David

[scuba]

I just tried Bcc: but it still doesn't work

thanks,
steve

[tijger]

Hi Steve,

You do a echo, what does it display? And maybe you also can do a echo of the headers...
Because it should be working correctly.

greetings

[scuba]

with this code I have now:

$headers = "From: $fromname <$fromaddress>\n";
$headers = "To: MPI Members <[e-mail]>\n";
$headers.= "Reply-To: $fromaddress\n";
$headers.= "Bcc: $display_block";

$to = "[e-mail]>";

mail($to, $Subject, $words, $headers);

echo ("You mailing has been sent to: $display_block<br>");
mysql_close();

echo("$headers");

I get:

You mailing has been sent to: [e-mail], [e-mail],
To: MPI Members Reply-To: [e-mail] Bcc: [e-mail], [e-mail],

My From: doesn't show up now, and nobody receives an email except the person in the $To.

[scuba]

I believe the problem is that a comma is added at the end of the Bcc:

How could I stop that from entering on just the last one?

Steve

[tijger]

Hi Steve,

That From does not show up is no suprise, you forgot to concatenate...in:
$headers = "To: MPI Members <[e-mail]>\n";

Why the rest is not working is a mystery to me.
I try to do the same in a shell script, but everything is working fine. I am afraid i can not help you.

(my shellscript without the emailaddresses)
#!/usr/local/bin/php -q
<?php
$ctype = "text/plain";
$from = "";
$name = "";

$to = "";
$msg = "something";
$headers = "From: $name <$from>\n";
$headers .= "Content-Type: $ctype\n";
$headers .= "To: $from\n";
$headers .= "Reply-To: $from\n";
$headers .= "BCC: ";

mail($to,"test",$msg,$headers);
?>

good luck!
greetings

[tijger]

Hi Steve,

no the comma is no prob, i looked at that already

greetings

[scuba]

Thanks for your time and help.

Steve

[djg_uk]

Hi Steve,

What platform are you using?

The manual states that if you're using Win32, the headers must be seperated by \r\n, and not just \n.

Cheers,

~D.

[scuba]

HI:
$headers = "From: $fromname <$fromaddress>\r\n";
$headers.= "To: MPI Members <$fromaddress>\r\n";
$headers.= "Reply-To: $fromaddress\r\n";
$headers.= "Bcc: $display_block";

$to = "[e-mail]>";

mail($to, $Subject, $words, $headers);

this is what i have now, and I am on a windows platform, but I still can't get this to work and have no idea what the problem is....is this a php4 only function?

Steve

[djg_uk]

Hi Steve,

I've found the reason why the BCC doesn't work. Apparently PHP runs Sendmail with the -t attribute, which searches To, CC and BCC and then DELETES BCC if another address is found.

Finally an answer!

Regards,

David

[scuba]

Thanks David,

I haven't triedd that yet but I have a feeling that it would work. I tried putting the BCC's in the To: field as well as the Bcc: field and it seems to be working for the win32 system. I'm gonna try your method too, maybe it'll work better that way.

Thanks, Again
Steve