Send email using HTML

static void SendEmailUsingHTML(Args _args)

{

    System.Text.StringBuilder   htmlTable;

    SysEmailParameters          parameters = SysEmailParameters::find();

    SMTPRelayServerName         relayServer;

    SMTPPortNumber              portNumber;

    Str1260                     subject, body;

    SysMailer                   mailer;

    System.Exception            e;

    boolean                     recExsits = false;


    EmployeeTable               employeeTable;


    htmlTable   = new System.Text.StringBuilder();


    htmlTable.Append("<style> table, th, td { border: 1px solid black; padding: 5px; table { border-spacing: 15px; } </style>");

    htmlTable.Append("<table>");


    // Table header


    htmlTable.Append("<TR ALIGN='LEFT'>");

    htmlTable.Append("<TD style='WORD-WRAP: break-word; TEXT-ALIGN: left; WIDTH: 120px'>");

    htmlTable.Append("Employee ID");

    htmlTable.Append("</TD>");


    htmlTable.Append("<TD style='WORD-WRAP: break-word; TEXT-ALIGN: left; WIDTH: 140px'>");

    htmlTable.Append("Employee Name");

    htmlTable.Append("</TD>");


    htmlTable.Append("<TD style='WORD-WRAP: break-word; TEXT-ALIGN: left; WIDTH: 140px'>");

    htmlTable.Append("Location");

    htmlTable.Append("</TD>");


    htmlTable.Append("<TD style='WORD-WRAP: break-word; TEXT-ALIGN: left; WIDTH: 200px'>");

    htmlTable.Append("Email Address");

    htmlTable.Append("</TD>");


    htmlTable.Append("</TR>");


    htmlTable.Append("<TableBorder = 1>");


    while select EmpId, EmployeeName, Location, Email from employeeTable

    {

        if (!recExsits)

        {

            recExsits=true;

        }

        htmlTable.Append("<TR ALIGN='LEFT'>");

        htmlTable.Append("<TD style='WORD-WRAP: break-word; TEXT-ALIGN: left; WIDTH: 120px'>");

        htmlTable.Append(employeeTable.EmpId);

        htmlTable.Append("</TD>");


        htmlTable.Append("<TD style='WORD-WRAP: break-word; TEXT-ALIGN: left; WIDTH: 140px'>");

        htmlTable.Append(employeeTable.EmployeeName);

        htmlTable.Append("</TD>");


        htmlTable.Append("<TD style='WORD-WRAP: break-word; TEXT-ALIGN: left; WIDTH: 140px'>");

        htmlTable.Append(employeeTable.Location);

        htmlTable.Append("</TD>");


        htmlTable.Append("<TD style='WORD-WRAP: break-word; TEXT-ALIGN: left; WIDTH: 200px'>");

        htmlTable.Append(employeeTable.Email);

        htmlTable.Append("</TD>");


        htmlTable.Append("</TR>");

    }


    htmlTable.Append("</TABLE>");


    if (!recExsits)

    {

        htmlTable.Clear();

        htmlTable.Append('No data');

    }


    if (parameters.SMTPRelayServerName)

        relayServer = parameters.SMTPRelayServerName;

    else

    relayServer = parameters.SMTPServerIPAddress;

    portNumber = parameters.SMTPPortNumber;

    subject = 'Employees Information';


    try

    {

        mailer = new SysMailer();


        mailer.SMTPRelayServer(relayServer,portNumber, '','', parameters.NTLM);


        mailer.fromAddress('support@outlook.com');

        mailer.tos().appendAddress('employee@outlook.com');

        // mailer.ccs().appendAddress('employee2@outlook.com');


        mailer.subject(subject);

        mailer.htmlBody(htmlTable.ToString());


        mailer.sendMail();

    }

    catch (Exception::CLRError)

    {

        e = ClrInterop::getLastException();


        while (e)

        {

            info(e.get_Message());

            e = e.get_InnerException();

        }

        CodeAccessPermission::revertAssert();

        info ('Email sending is failed');

    }


    info('Email sent');

}

Comments

Post a Comment

Popular posts from this blog

Assembly reference containing type is not referenced, Object 'CLRObject' could not be created

Image
Problem Statement I have RDP and an AX shortcut icon, I have a parameter form with a "Test Connection" button. Upon clicking this button, a DLL is invoked to authenticate the connection status. This DLL is placed in both the client and server directories: specifically, it is located in the Client Directory at C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin and in the Server Directory at C:\Program Files\Microsoft Dynamics AX\60\Server\<MachineName>\bin . Additionally, a reference to this DLL has been added to the Application Object Tree (AOT) to facilitate its functionality When running the process from RDP, the "Test Connection" passes successfully. However, when using the AX shortcut icon, an error is encountered. Solution Add C# project into AOT, by right click on project and ADD <ProjectName> to AOT. Open project and set the project property. Deploy to client YES and Deploy to server YES and Deploy the project. After deployment of projec...
Read more

Open Packing slip posting form when updating Generate picking list

Image
  Functional Process: Creating Picking list registration. After creating a picking list registration, to update the picking list registration click on Update then Handling status becomes Completed . For posting this picking list user clicks on the  Post packing slip. Requirement: On the Update button Post packing slip form should be open.         Post packing slip form is opened on the Update button. Technical Background:     Create CoC of Update button as below: [ExtensionOf(formcontrolstr(WMSPickingRegistration, PickAllButton))] final class ERWMSPickingListRegistration_PickAllButton_Extension {     /// <summary>     /// This method is used to Populate Post packing slip form     /// </summary> void clicked()     {         WMSPickingRoute wmsPickingRoute;         SalesTable      salesTable;         MenuFunction...
Read more

Extract data of PO from the System in Ax 2012

 static void Job(Args _args) {     PurchTable      purchTable;     PurchLine       purchLine;     Dialog          dialog  = new Dialog();     DialogField     dialogFieldFileSave;     Commaio         file;     container       line;     FilePath        TempPath;     dialogFieldFileSave     = dialog.addField(extendedTypeStr(FilenameSave),"File path","Caption here");     dialog.caption("Extract PO data");     dialog.filenameLookupFilter(['*.csv']);     if(!dialog.run())     {         return;     }     if (dialogFieldFileSave.value() == '')     {         error("Please set up the location for export file.");         return; ...
Read more