X++ code to create excel file and send it through mail in D365FO

 This code will help to create excel file and send it through  mail.

Note :-  SMTP parameters settings needs to be done to send mail from D365FO.

refer https://www.linkedin.com/pulse/sending-emailsnotification-from-d365-fo-x-saim-siddiqui/ 

Code :- 

class BASSendEmailWithAttachmentJob

{

    /// <summary>

    /// Class entry point. The system will call this method when a designated menu

    /// is selected or when execution starts and this class is set as the startup class.

    /// </summary>

    /// <param name = "_args">The specified arguments.</param>

    public static void main(Args _args)

    {

        SalesTable              salesTable;

        SysMailerMessageBuilder mailBuilder = new SysMailerMessageBuilder();

        SysMailerSMTP           smtp        = new SysMailerSMTP();

        SysEmailParameters      _SysEmailParameters;

        RowNumber               row = 1;


        System.IO.MemoryStream memoryStream = new System.IO.MemoryStream();

        mailBuilder.setSubject("Sales Order Data");


        select SMTPUserName from _SysEmailParameters;


        mailBuilder.setFrom(_SysEmailParameters.SMTPUserName);


        mailBuilder.setBody("Please fnd the attachment");


        mailBuilder.addTo("ssmurgesh97@gmail.com");


        using (var package = new OfficeOpenXml.ExcelPackage(memoryStream))

        {

            var worksheets = package.get_Workbook().get_Worksheets();

            var worksheet = worksheets.Add("Sales order Data");

            var cells     = worksheet.get_Cells();


            var cell      = cells.get_Item(1,1);

            cell.set_Value("Sales Id");

            cell          = cells.get_Item(1,2);

            cell.set_Value("SalesStatus");

           

            while select * from salesTable

                where salesTable.CustAccount == '3005'

            {

                row++;

                cell = cells.get_item(row, 1);

                cell.set_Value(salesTable.SalesId);

                cell = cells.get_item(row, 2);

                cell.set_Value(salesTable.SalesStatus);

            }


            package.Save();


        }


        memoryStream.Seek(0, System.IO.SeekOrigin::Begin);


        //The below line used to attach excel file to email.

        mailBuilder.addAttachment(memoryStream, 'SalesOrderData.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

    

        try

        {

            smtp.sendNonInteractive(mailBuilder.getMessage());

        }

        catch(Exception::CLRError)

        {

            error(CLRInterop::getLastException().toString());

        }

    }


}

Comments

Post a Comment

Popular posts from this blog

how to post trade agreement journals automatically using x++ code

  In Microsoft Dynamics AX, you can post trade agreement journals automatically using X++ code. Here are the steps to do so: Create a new job in X++. Write a code to fetch data from the trade agreement table. Create a journal header and journal lines based on the fetched data. Call the post() method of the journal header to post the journal. Repeat steps 2 to 4 for each trade agreement. Here's a sample code in X++: static void postTradeAgreementJournals(Args _args) { TradeAgreementTable tradeAgreementTable; GeneralJournalHeader generalJournalHeader; GeneralJournalLine generalJournalLine; // Fetch data from the Trade Agreement table select tradeAgreementTable where tradeAgreementTable.JournalPosting == NoYes::No; // Loop through each trade agreement while (tradeAgreementTable) { // Create a journal header generalJournalHeader = new GeneralJournalHeader(); generalJournalHeader.initValue(); generalJournalHeader.tra...
Read more

How to Create a wizard in x++ d365

Image
 step1: Create a form and apply form pattern as wizard step2 : create a class and extend the class with SysWizard. code :            class BAS_WIzardScreen extends SysWizard {     #MACROLIB.AviFiles     FormName formname()     {         return formstr(BAS_WIzardForm);  // name of the wizard form     }     public void run()     {         info(strFmt("Thankyou"));     }     public void setupNavigation()     {     }     public boolean validate()     {         return true;     }     public static str description()     {         return "BASOFA WIZARD";  // title of the wizard     }     public static void main(Args _args)     {         BAS_WIzardScreen wizard = new BAS_WIz...
Read more

x++ code to submit and approve and reject the invent movement workflow in d365 F&O

 class Class1 {     public  void submitworkflow()     {         InventJournalTable journalTable;     WorkflowWorkItemTable   WorkflowWorkItemTable;    WorkflowVersionTable        workflowVersionTable;                journalTable = InventJournalTable::find('00446');               // submit to workflow         if (journalTable.WorkflowApprovalStatus == InventJournalWorkflowApprovalStatus::NotSubmitted)         {             Workflow::activateFromWorkflowType(workFlowTypeStr(InventJournalMovementTemplate), journalTable.RecId,                                     'Workflow submitted by button', false, Curuserid());         }    ...
Read more