Sending email from D365fo

(0) Share

Report

Posted on by TonyAx

570

Hi All

Newfilename = @”c://Test//data.csv”

I use below code for sending email from D365fo.

Am received the email but with out data ,only file name only am receiving please check the below image

var messageBuilder = new SysMailerMessageBuilder();

messageBuilder.setFrom("");

messageBuilder.addTo("")

.setSubject("Test")

.setBody("Test");

messageBuilder.addAttachment(stream,newfilename);

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

0601.error.PNG

All responses (6)

Answers (1)

Sort by

Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

What is the purpose of the file name? Are you attempting to attach file from your computer? That will not work, since D365 is a cloud service that has no way of accessing people's workstations and reading files from them. If you think about it, it would be the end of security in Internet, if any program in the public Internet could read files from your computer.

The only way how D365 can get files from your computer is that if the file is uploaded by user or program that has access to your computer.
TonyAx 570 on at

Like (0)

Report
Copy link

Link copied!

Thanks for reply Nikolaos my problem is, I can send the email with attachment.

But while receiving am not get any data from the attachment. Only empty file am receiving .
nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Did you read my previous message where I explained why you can't handle local files with D365?

Also, could you please answer the questions that I asked in my previous message. That way you will get much better help.
TonyAx 570 on at

Like (0)

Report
Copy link

Link copied!

Client need some data from customize table in email attachment.

And email will send every week end atomically .
Verified answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

So, just create the attachment in code, populate it from the table, and attach it to the email. As mentioned above, you can't access your local file system (C:\temp) from D365FO.

Or, create data entity for your table, and use Flow or Logic Apps to read this data entity weekly and send the result as email.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Tony,

Another and possibly easier way is creating an electronic report in the organization admin module.

That is because you can save the record by default on SharePoint and then use Flow/PowerAutomate to distribute it to various people.

Also, electronic reports can be schedules as any other report and thereby be created in regular intervals as required.

That works all out of the box and does not need a customization.

Best regards,

Ludwig