Create table in email body using X++ code.

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.

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 = "";

            while select * from PurchTable where 
                PurchTable.OrderAccount =='100029-VEN'
            {
                emailBodyWithHtml  = "";
            }
            emailBodyWithHtml  = "
Payment
Currency Code
DeliveryPostalAddress
Delivery Date
" PurchTable.Payment "
" PurchTable.CurrencyCode "
" any2Str(PurchTable.DeliveryPostalAddress) "
" any2Str(PurchTable.DeliveryDate) "
";

            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");
        }
    }

}

Result: