Microsoft Dynamics NAV (Archived)

How to send a automatic email in nav 2016

(0) Share

Report

Posted on by Community Member

Hi friends,

I want to send a email automatically in NAV 2016,

This is my code

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);

SMTP.CreateMessage('Jonas Wood','ashwini.e@sharpsyssoft.com','','Outstanding Amount','',TRUE) ;

SMTP.AddCC('ashwini.e@sharpsyssoft.com');

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

SMTP.AppendBody(' ');

SMTP.AppendBody('Please find the Customer Outstading Amount in PDF Format:');

SMTP.AppendBody(' ');

SMTP.AppendBody('Regards');

SMTP.AppendBody(' ');

SMTP.AppendBody('Company Accounts Departments ');

SMTP.AddAttachment(Path,PdfDocPath);

SMTP.Send;

//ERASE(Path);

i can send a mail but not automatic but i want send a mail automatically in NAV 2016 please give any suggestion.

Thank you

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

keoma 32,729 on at

Like (0)

Report

to run a job (also your code) automatic you can use the job queue, for that follow community.dynamics.com/.../set-up-job-queues-in-dynamics-nav

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Jonathan

Thank you very much for your reply i have created the job queue for my report i need to send this report all users Mail. please tell me where i need to add my email id

Thank You

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

I would suggest add required email id in the program itself and then schedule to send it using job queue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Amol
thank you for you reply i have added the email in my report cal code even though i did nt get any email.

Thank you

Was this reply helpful? Yes No
Sarav 443 on at

Like (0)

Report

Hi Ashwini,

I'm not sure about your requirement. Please go through the following link which was helpful to me on generating the Customer Statement.

saurav-nav.blogspot.sg/.../microsoft-dynamics-nav-2017-email-from.html

Thanks & Regards,

Saravanan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Saravanan,

thank you for your reply i need to send a mail automatically using job queue.please help on this one.

Thank you

Was this reply helpful? Yes No
Sarav 443 on at

Like (0)

Report

Based on your screenshots I believe it is about generating customer outstanding as a report on a specific date of month (correct me if I'm wrong).

As mentioned earlier by Mr Jonathan, Job queue is the right way to automate it.

I can provide few areas where we need to check for this scenario.

1. After setting up the Job Queue, check the Job Queue Log Entries from Job Queue Entries. Check whether the status is SUCCESS or Failure.

2. Since it is a report from the Customer, ensure there is a Outstanding Amount for that Customer on that period which you are trying the report.

3. Instead of SMTP Mail Codeunit (400), you can try createmessage function from Mail codeunit (397) as it is available in NAV 2016.

Thanks & Regards,

Saravanan

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Ashwini,

Please check your SMTP setup and Test Email Setup to make sure your SMTP Server is working before adding the code.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi suresh

Thank you for your reply i want to send a report for particular user mail id i have added mail id in report CAL code page.

please see the below screen shot i want to know where i need to add the email id,

Thank you

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Ashwini,

Before adding the code, Open SMTP Mail Setup and check your server settings and click the action Test Email Setup to make sure it is working.

The above seems fine to me, check your event viewer for any errors.

Was this reply helpful? Yes No