Microsoft Dynamics NAV (Archived)

How To send report with filters in mail attachment

(0) Share

Report

Posted on by Prabakaran.R

305

Hi Friends,

How to send a mail in nav with report attachment with report filters in nav 2016.

Thank You

*This post is locked for comments

All responses (6)

Answers (0)

Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: How To send report with filters in mail attachment

To add the attachement to the email you need to use the AddAttachment Function. For example check the below code for the

Where Invoice is the Report

Invoice.USEREQUESTPAGE(FALSE);

IF Invoice.SAVEASPDF(FileName) THEN BEGIN

SMTPMail.CreateMessage(

CompanyInformation.Name,

CompanyInformation."E-Mail",

Cust."E-Mail",

STRSUBSTNO('%1 %2.pdf',TABLECAPTION,"No."),

Text003,

TRUE);

SMTPMail.AddAttachment(FileName);

SMTPMail.Send;

END;
Suggested answer

Zaid Tariq 2,266 on at

Like (0)

Report

RE: How To send report with filters in mail attachment

Hi,
The function SMTPMail.AddAttachment is the method you can use to attach the file. If you are facing any error please specify. Thanks
manish.yadav 1,835 on at

Like (0)

Report

RE: How To send report with filters in mail attachment

Hello Dear,

I have customised my below code, I am using this for send the pdf with attachments. Hope it will help you.

PdfDocPath :='ABC.pdf';

Path := 'C:\Temp\'+PdfDocPath; // Directory + Path

CLEAR(ABC); // ABC is a Report 50088

ABC.USEREQUESTPAGE(FALSE); //// for filteration

IF NOT ABC.SAVEASPDF(Path) THEN

ERROR('PDF Creating Failed!\\ERROR:\\' + GETLASTERRORTEXT);

SMTpMail.CreateMessage('Company Limited','NAV@ITC.com','','Subject Line','',TRUE);

SMTpMail.AppendBody('Dear Sir / Madam,');

SMTpMail.AppendBody(' ');

SMTpMail.AppendBody('Please find the Ledger Details in PDF Format:');

SMTpMail.AppendBody(' ');

SMTpMail.AppendBody('Regards');

SMTpMail.AppendBody(' ');

SMTpMail.AppendBody('Company Accounts Departments ');

SMTpMail.AddAttachment(Path,PdfDocPath);

SMTpMail.Send;

ERASE(Path);
Prabakaran.R 305 on at

Like (0)

Report

RE: How To send report with filters in mail attachment

Hi Zaid

I need to attach the report in SMTP mail please give any suggesstion.

Thank You
Prabakaran.R 305 on at

Like (0)

Report

RE: How To send report with filters in mail attachment

Hi Zaid

thank you reply

i have used this code in separate code unit and called in page action

Customer.RESET;

//Customer.SETRANGE(PDF Generated', FALSE);

IF Customer.FINDSET THEN BEGIN

REPEAT

Filename:= Customer."No.";

REPORT.SAVEASPDF(59996, Filename, Customer); //PDF CREATED BY SAVEAS FUNCTION

UNTIL Customer.NEXT = 0;

END;

Subject := 'SUBJECT SAMPLE TEXT' ;

Body := 'BODY SAMPLETEXT';

SMTP.CreateMessage(SMTPmailsetup."Email Sendor Name",SMTPmailsetup."Email Sendor Emil",

Customer."E-Mail",'Customer Email','',TRUE);

Body := Body + 'OTHER';

SMTP.AppendBody(Body);

SMTP.Send;

MESSAGE('Mail Sended');

its loading only i did nt get any solution.

Thank You
Suggested answer

Zaid Tariq 2,266 on at

Like (0)

Report

RE: How To send report with filters in mail attachment

Hi,
Please have a look at the following links and then let me know if you would still have any question. Thanks

How to apply filters to a report:
https://dynamicsuser.net/nav/f/developers/10566/passing-filter-to-a-report
https://community.dynamics.com/nav/f/34/t/147548

https://nav-magno.be/2015/06/printing-pdf-reports-in-classic-without-external-components/

How to send attachment using SMTP:
https://community.dynamics.com/nav/b/arounddynamicsnavworld/archive/2017/02/08/how-to-print-reports-to-pdf-and-send-email
https://community.dynamics.com/nav/b/technicaltipsandtricksfordynamicsnav/archive/2015/07/31/creating-file-attachment-to-mail-for-report