Hi All,
Today we are going to see how to create table in email body without using email templates. Please refer below example.
Note - Please make sure your email parameter setup is done and you able to send test email.
Expected result:
X++ Code
internal final class TestJobTableInEmailBody
{
public static void main(Args _args)
{
SysMailerMessageBuilder messageBuilder = new SysMailerMessageBuilder();
SysInfoLogStr emailBodyWithHtml;
EmailBase fromEmail = 'no-reply-vendorportal@testgroup.com';
EmailBase toEmail = 'vijay.yelmame14@gmail.com';
EmailBase ccEmail;
PurchTable PurchTable;
boolean emailSend;
try
{
emailBodyWithHtml = "<table border = '1'><tr><td><b>Payment<b></td><td><b>Currency Code<b></td><td><b>DeliveryPostalAddress<b></td><td><b>Delivery Date<b></td></tr>";
while select * from PurchTable where
PurchTable.OrderAccount =='TEst-VEN'
{
emailBodyWithHtml += "<tr><td>"+PurchTable.Payment+"</td><td>"+PurchTable.CurrencyCode+"</td><td>"+any2Str(PurchTable.DeliveryPostalAddress)+"</td><td>"+any2Str(PurchTable.DeliveryDate)+"</td></tr>";
}
emailBodyWithHtml += "</Table>";
messageBuilder.setBody(strFmt(strRem(emailBodyWithHtml, '\r')),true);
messageBuilder.setSubject("Test Email");
messageBuilder.addTo(toEmail);
//messageBuilder.addCc(ccEmail);
messageBuilder.setFrom(fromEmail);
emailSend = SysMailerFactory::sendNonInteractive(messageBuilder.getMessage());
}
catch
{
warning("@Res:NotificationEmailNotSent");
}
}
}
No comments:
Post a Comment