I would like to set up a Mailing List.

Basically my requirements are as follows:
I would be sending a html/text mail with/without attachments to a large volume of users.
The emails are in a SQL Server table or MySQL table.
And i need to personalize the mail.

I thought of using a PHP script for sending mails but i dont think that is a good idea. So I need some software to send mails which gets email address from database and sends mails.

I would be happy if you could post any of the good software that suits my requirements or any other solution to my problem

Thanks in advance

    Which one is better.
    A PHP Script or a Software to maintain a Mailing list

      depends where database located, but i normally use php as my mail list is on webserver.

        ive got a fairly large mailing list i coded using php to send the mails and it works fine

          Hey,

          What's the volume...
          Would appreciate if you could send me the code.

          Thnx in advance

            cant send the code its owned by my work, however it deals with around 1500+ mails per week, i learnt how to make it from a good PHP book called PHP and Mysql Web Development cant remember the author now ill check when im home

              I dont do the mailing list thing, but iI do have a script that loops through a database table and fires off an e-mail for each record.

              <? 
$STRcontent = "e-mail body content";

//connect 
$db = mysql_connect("localhost","username","password"); 
mysql_select_db (database name); 
		$result = mysql_query ("select * from Invitees where partyID = '$STRpartyID'"); 
$body .= " <html><head><title>Party Invitation</title></head> \n";
$body .= " <body bgcolor=\"#FFFFFF\" text=\"#000000\"><font face='arial' size='2'> \n";
$body .= $STRcontent;
$body .= " </body>";
$body .= " </html>";
$headers .= "Content-Type: text/html; charset=iso-8859-1\n";
	if ($STRinviter == "") {
	$STRinviter = "Groovything Party Planner";
	}
	if ($STRfrom == "") {
	$STRfrom = "Party_Planner@groovything.com";
	}
$headers .= "From: ".$STRinviter." <".$STRfrom.">\r\n";

	while ($row = mysql_fetch_array($result)) 
	{
    	$STRid = $row["id"];
		$STRinvitee = $row["invitee"];
		$STRinviteeEmail = $row["inviteeEmail"];

	$STRlink = " <br>click the following link for the details:<br><a target='_blank' href='http://www.groovything.com/default.php?page=viewParty'>Party Details</a> \n";
	mail($STRinviteeEmail, "Party Update", $body.$STRlink, $headers);
		}

	if(!$result) 
		{ 
		   echo "<p align=center><b>Update not sent</b> ", mysql_error(); 
		   exit; 
		} 
	if($result) 
		{ 
		mysql_close($db);?>
		<? 
		print "<html><head><title>Party Update</title><link REL='STYLESHEET' HREF='css/sfx.css' TYPE='text/css'></head><body onLoad='setTimeout(window.close, 1000)'>";
		print "<p align=center>Your Update has been sent to everyone</p>"; 
		print "</body></html>";
		}
?>

              I recommend keeping the mailing list (sounds like you already plan on that) a database table and then you can update it or send out an e-mailer whenever you want.

              dont know if this helps, but maybe you can use some of the logic

                Write a Reply...