Report Layout in Email Body

(0) Share

Report

Posted on by subrata.bauri

1,112

Dear Sir,

Currently I'm sending NAV PDF Matrix Report in the SMTP Mail attachment using JOB Queue. Now the client wants that the email body should be appeared exactly as Report Layout.

How can I do this ?
Kindly guide me in NAV 2016.

Thanks,

*This post is locked for comments

All responses (12)

Answers (0)

yoheswaran 225 on at

Like (0)

Report

RE: Report Layout in Email Body

can u tell me how to save report to html and convert it to text , then send that text in email body
subrata.bauri 1,112 on at

Like (0)

Report
RE: Report Layout in Email Body

Hi,

The custom code working perfectly when I execute it manually but it does not work thru Job Queue. Debugger stops at the below mentioned code (at last Line).....

WordApplication :=WordApplication.ApplicationClass; WordDocument :=WordHelper.CallOpen(WordApplication,FileName,FALSE,TRUE); FileName2 := TEMPORARYPATH + DELCHR(FORMAT(CURRENTDATETIME),'=','\/:*?"<>| '); WordHelper.CallSaveAsFormat(WordDocument,FileName2,WordSaveFormat.wdFormatHTML);

It throws the error message such as.....

Microsoft Dynamics NAV A call to Microsoft.Dynamics.Nav.Integration.Office.Word.WordHelper.CallSaveAsFormat failed with this message: Value cannot be null. Parameter name: document OK

I can't find the actual reason.
subrata.bauri 1,112 on at

Like (0)

Report

RE: Report Layout in Email Body

Ultimate, I've achieved the goal. Thank you everyone.
subrata.bauri 1,112 on at

Like (0)

Report

RE: Report Layout in Email Body

I have saved the report output as WORD Document & Convert the same into html file. Is it possible to send this html file as Email body in NAV 2016 ?
Suggested answer

Saurav.Dhyani 17,965 Super User 2024 Season 2 on at

Like (0)

Report

RE: Report Layout in Email Body

Feature is also avilable with NAV 2016 but not completly baked, but you can do same in NAV 2016 also.
subrata.bauri 1,112 on at

Like (0)

Report

RE: Report Layout in Email Body

I have read the blog, I think it's default feature of NAV 2017.
Suggested answer

subrata.bauri 1,112 on at

Like (0)

Report

RE: Report Layout in Email Body

Thanks for your reply.

I got your point. So, I have to move for the Coding Option (Second Option).
Suggested answer

Saurav.Dhyani 17,965 Super User 2024 Season 2 on at

Like (0)

Report

RE: Report Layout in Email Body

Hope this helps.

https://www.archerpoint.com/blog/Posts/emailing-reports-custom-email-body-dynamics-nav-2017
Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

RE: Report Layout in Email Body

You can attach the report or save the report as pdf or Word Document. The request is quite strange, it’s absolutely correct that the report is attached. You can try to embed the word layout, but it’s not a default feature.
subrata.bauri 1,112 on at

Like (0)

Report

RE: Report Layout in Email Body

I think there might be a possibility to save the report output as WORD Document and then Send the word document as Email Body in NAV 2016....