Hi, i want to send the mail to all UserLevel = 2 but only mail arrives to a single employee, thank you very much for your help.
// Email Sending event
function Email_Sending(&$Email, &$Args) {
$Email->Recipient = ew_ExecuteScalar("SELECT Email FROM EMPLOYEES WHERE UserLevel = '2'");
$Email->Subject = "Solicitud de Financiamiento AP";
$Email->Format = "HTML";
$Email->Charset = "UTF-8";
$Email->Content = "<html><style>body {font-family: Arial, Helvetica, sans-serif; font-size: 16px;color: #000;}</p><h3>Financiamiento AP / Agregado por</h3><p></style><body>'". CurrentUserName();
//busca el nombre del cliente en la base de datos nysn
$uln = ew_ExecuteScalar("SELECT nysn_cliente FROM nysn WHERE nysn_id = '" . $Args["rsnew"]["ap_2_cliente"] ."'");
$Email->Content .= "<BR><BR><BR><table border='1' bgcolor='#ffe6cc'>
<tbody>
<tr>
<td><b>Cliente :</b></td>
<td>:</td>
<td>" . $uln . "</td>
</tr>
<tr>
<td><b>Concepto :</b></td>
<td>:</td>
<td>" . $Args["rsnew"]["ap_2_concepto_1"] . "</td>
</tr>
<tr>
<td><b>Monto Financiado :</b></td>
<td>:</td>
<td>" . $Args["rsnew"]["ap_2_monto"] . "</td>
</tr>
<tr>
<td><b>Fecha Compromiso de Pago :</b></td>
<td>:</td>
<td>" . $Args["rsnew"]["ap_2_fecha_compromiso"] . "</td>
</tr>
</tbody>
</table>";
return TRUE;
}