D365 FO - Send Email with attachments by X++

Go to System administration >> Setup >> Email >> System email templates

Create New template

[ExtensionOf(classStr(PurchConfirmationJournalPost))]

final class PurchConfirmationJournalPost_TraxSCM_Extension

{

public str CCEmail, Esender;

public void Sendmail()

{

try

{

str vendname = purchTable::find(this.vendPurchOrderJour.purchid).vendorName();

str Purchid = this.vendPurchOrderJour.purchid;

str sUserId;

sUserId = curUserId();

//Getting Email id from User Options --> Account --> Email Provider --> Email id

str userEmail = SysUserInfo::find(sUserId, false).Email;

var builder = new SysMailerMessageBuilder();

builder.setBody(this.Email_Body());

builder.setFrom(userEmail,Esender);

builder.addcc(ccEmail);

builder.addTo("[email protected]");

builder.setSubject("subject string");

//************

System.IO.Stream stream = this.generateReportStream(); // todo insert record reference

if(stream)

builder.addAttachment(stream,vendname +" - "+Purchid+".pdf");

var message = builder.getMessage();

SysMailerFactory::getNonInteractiveMailer().sendNonInteractive(message);

}

catch (Exception::Error)

{

throw error("@SYS33567");

}

public str Email_Body()

{

str vendname = purchTable::find(this.vendPurchOrderJour.purchid).vendorName();

str Purchid = this.vendPurchOrderJour.purchid;

str sub,tmp,Sender,frm,cc;

[sub,tmp,Sender,frm,cc] = this.getEmailTemplate('POConfirm','en-us');

Esender = sender;

tmp = strReplace(tmp,'%vend%','%1');

tmp = strReplace(tmp,'%purchid%','%2');

str ret = strFmt(tmp,vendname,Purchid);

return ret;

}

public System.IO.MemoryStream generateReportStream()

{

DocuRef addedRecord;

VendPurchOrderJour VendPurchOrderJour = this.vendPurchOrderJour;

Filename fileName = "Report.pdf";

PurchPurchaseOrderController controller = new PurchPurchaseOrderController();

PurchPurchaseOrderContract contract = new PurchPurchaseOrderContract();

SRSPrintDestinationSettings settings;

Array arrayFiles;

System.Byte[] reportBytes = new System.Byte[0]();

SRSProxy srsProxy;

SRSReportRunService srsReportRunService = new SrsReportRunService();

Microsoft.Dynamics.AX.Framework.Reporting.Shared.ReportingService.ParameterValue[] parameterValueArray;

Map reportParametersMap;

SRSReportExecutionInfo executionInfo = new SRSReportExecutionInfo();

System.IO.MemoryStream stream;

Args args = new Args(); ;

args.record(VendPurchOrderJour);

contract.parmRecordId(VendPurchOrderJour.RecId);

controller.parmArgs(args);

controller.parmReportName(ssrsReportStr(PurchPurchaseOrder, Report));

controller.parmShowDialog(false);

controller.parmReportContract().parmRdpContract(contract);

settings = controller.parmReportContract().parmPrintSettings();

settings.printMediumType(SRSPrintMediumType::File);

settings.fileName(fileName);

settings.fileFormat(SRSReportFileFormat::PDF);

controller.parmReportContract().parmReportServerConfig(SRSConfiguration::getDefaultServerConfiguration());

controller.parmReportContract().parmReportExecutionInfo(executionInfo);

srsReportRunService.getReportDataContract(controller.parmreportcontract().parmReportName());

srsReportRunService.preRunReport(controller.parmreportcontract());

reportParametersMap = srsReportRunService.createParamMapFromContract(controller.parmReportContract());

parameterValueArray = SrsReportRunUtil::getParameterValueArray(reportParametersMap);

srsProxy = SRSProxy::constructWithConfiguration(controller.parmReportContract().parmReportServerConfig());

reportBytes = srsproxy.renderReportToByteArray(controller.parmreportcontract().parmreportpath(),

parameterValueArray,

settings.fileFormat(),

settings.deviceinfo());

if (reportBytes)

{

stream = new System.IO.MemoryStream(reportBytes);

}

return stream;

}

Published on: November 30, 2023

Learn more

Need help with this product?

We can help you with D365 FO - Send Email with attachments by X++

If you want help implementing, troubleshooting, or improving this product, contact us and we’ll point you in the right direction.

Sherif Fayed

D365 Sending Email with Customer Account Statement SSRS report as attachment using X++

D365 Sending Email with Customer Account Statement SSRS report as attachment using X++ custTable _custTable; &...

2 years ago

clicking link on info message X++ to Open form

Message::AddAction() method can be used to embed an action within a message sent to the message bar. This method supports adding a singl...

2 years ago

D365 FO Data entity Export using X++

This post provides information on exporting data entity through X++ in D365 FO. The post includes a code snippet written in X++ that can be us...

2 years ago

D365 FO Encryption And Decryption Using A Symmetric Key(AES) using X++

If you're looking to encrypt and decrypt data using a symmetric key in D365 FO, this tutorial is the right place to be. The post details the s...

2 years ago

Get multiple selected rows using D365 X++

This blog post offers a valuable insight into D365 X++, offering a detailed guide on how to get multiple selected rows. Multi-select for Butto...

2 years ago

D365 Solution for Cloud Dev machine show error ' The remote certificate is invalid according to the validation procedure. '

You are getting 'The remote certificate is invalid according to the validation procedure.'Error show with all reports and tired Ro...

2 years ago

D365 F&O setup email notifications on workflows

How to setup email notifications on workflows in D365 F&OToday we’re going to see how to manage workflow notifications in D365 Suppl...

3 years ago

Blog image

Sherif Fayed

Learn more

D365 FO - Send Email with attachments by X++

We can help you with D365 FO - Send Email with attachments by X++

Related posts

D365 Sending Email with Customer Account Statement SSRS report as attachment using X++

clicking link on info message X++ to Open form

D365 FO Data entity Export using X++

D365 FO Encryption And Decryption Using A Symmetric Key(AES) using X++

Get multiple selected rows using D365 X++

D365 Solution for Cloud Dev machine show error ' The remote certificate is invalid according to the validation procedure. '

D365 F&O setup email notifications on workflows

Get the latest Dynamics 365 and Power Platform content in your inbox