Posts

Showing posts from October, 2019

Sending Email with attached Excel file in D365 and Ax 2012 using SysMailerMessageBuilder Framework X++

Moving on from Ax dynamics 2012 to D365, there are multiple frameworks that has been added on by Microsoft to use its basic functionality.In the case of email sending functionality in Dynamics Ax we probably prefer SMTP in 2012 that is to add on the code and bypassing its required parameter.While in D365 we could use SysMailerMessageBuilder framework to perform our work that is sending email to multiple recipient too. The piece of code firstly has been attached  is using SysMailerMessageBuilder framework Requirements: *Our objective it to Generate an excel File and attach it to an email and sending it to multiple recipients *The file data will be from financial dimension view and it will be distributed into three worksheets that is D1,D2 and D4_5 according to conditions *Data of Data Entity of D4 & D5 will be inserted into same worksheet that is D4_5 using System.IO; using OfficeOpenXml; using OfficeOpenXml.Style; using OfficeOpenXml.Table; using Office...