$MailSubject="##### Mail alert from ... System #####";
$sql_msgmail="SELECT * FROM `tbpr` where pr_no=$pr_no ";
$res_msgmail=mysql_db_query($dbname,$sql_msgmail);
if($res_msgmail){
while($data_msgmail=mysql_fetch_array($res_msgmail)){
$search_code2=$data_msgmail['search_code2'];
$requestor_id=$data_msgmail['requestor_id'];
$date_send=substr($data_msgmail['date_send'],0,10);
$justification=$data_msgmail['justification'];
}
}
$sql_msgmail2="SELECT * FROM `usr_login` where emp_code=$requestor_id ";
$res_msgmail2=mysql_db_query($dbname,$sql_msgmail2);
if($res_msgmail2){
while($data_msgmail2=mysql_fetch_array($res_msgmail2)){
$name=$data_msgmail2['name'];
$surname=$data_msgmail2['surname'];
}
}
$strVar = "$search_code2";
$strVar2 = "$name.$surname";
$strVar3 = "$justification";
$strVar4 = "$date_send";
$MailMessage= "
<h3>There is PR number: $search_code2 requested to you for approving.</h3><br>
<table width='400' border='1'>
<tr>
<td><div align='center'><strong>PR Number </strong></div></td>
<td><div align='center'><strong>Requestor </strong></div></td>
<td><div align='center'><strong>Specail Justification</strong></div></td>
<td><div align='center'><strong> Date_Send </strong></div></td>
</tr>
<tr>
<td><div align='center'>".$strVar."</div></td>
<td><div align='center'>".$strVar2."</div></td>
<td><div align='center'>".$strVar3."</div></td>
<td><div align='center'>".$strVar4."</div></td>
</tr>
</table>
<h3></h3><br>
";
$MailFrom_Name="System";
$MailFrom_Email_Addr="system@compo.com";
$Headers = "MIME-Version: 1.0\r\n" ;
$Headers .= "Content-type: text/html; charset=windows-874\r\n" ;
$Headers .= "From: ".$MailFrom_Name." <".$MailFrom_Email_Addr.">\r\n" ;
$Headers .= "X-Priority: 3\r\n" ;
$Headers .= "X-Mailer: PHP mailer\r\n" ;
if(mail($MailTo, $MailSubject, $MailMessage, $Headers)){
echo "Send Mail Success." ;
print "$MailTo ";
}else{
echo "Send Mail Fails." ;
print "$MailTo ";
}
}
ลองนี่ดูครับ
ส่วนผู้รับก็ส่งตามเงื่อนไขของคุณนะครับ ผมไม่ได้แก้ออก เอาที่ใช้อยู่มาให้เอาไปลองดัดแปลงดู