Sending Mail through X++

Here i building a html table string of all customers belonging to a customer group and sending it through smtp server. The mail client interprets the html of the message and display the customers in a table of records.

You can build the html table by merging with the records of your table and send the mail.

   CustTable custTable;

   System.Text.StringBuilder htmlTable;

   SysMailer mailer;

   ;

  htmlTable = new System.Text.StringBuilder();

  htmlTable.Append(@”<caption> Blue Company Customers”);

  htmlTable.Append(@”  </caption> </br>”);

  htmlTable.Append(“<TABLE BORDER=1>”);

  while select custTable where custtable.CustGroup == ‘AP’

  {

     htmlTable.Append(“<TR ALIGN=’CENTER’>”);

     htmlTable.Append(“<TD>”);

     htmlTable.Append(custTable.AccountNum);

     htmlTable.Append(“</TD>”);

     htmlTable.Append(“<TD>”);

     htmlTable.Append(custTable.NameAlias);

     htmlTable.Append(“</TD>”);

     htmlTable.Append(“</TR>”);

  }

  htmlTable.Append(“</TABLE>”);

   mailer = new SysMailer();

   //building mail details

   mailer.htmlBody(htmlTable.ToString());

   mailer.subject(“Automated Mail – Customers”);

   mailer.fromAddress(“Axapta@bluecompany.com”);

   mailer.tos().appendAddress(“sayeed@bluecompany.com”);

   // Setting SMTP details

   mailer.SMTPRelayServer(“192.168.4.67″,87,”AXMail”,”1234″,false);

   // Sending Mail

   mailer.sendMail();