Hope this gives you an idea,<?
/GETS CUSTOMER DATA FROM DB TO GENERATE A NEWSLETTER TO CUSTOMERS/
$sql->Query("Select E_MAIL from CUSTOMERS_DB");
for ($i = 0; $i < $sql->rows; $i++) {
$sql->Fetch($i);
$E_MAIL= $sql->data[0];
$msg = "
$newsletter
";
$recipient = "$E_MAIL";
$subject = "Newsletter from Your COMPANY";
$mailheaders = "From: \n";
$mailheaders .= "Reply-To: contact@pepe\n\n";
mail($recipient, $subject, $msg, $mailheaders);
}
echo("<font size=2 color=red face=verdana>Newsletter has been sent to all our customers</font>");
?>