Send report automatically using job queue

casanova

hi all
I want to send report using job queue
for example Statement (report 116) and Reminder (report 117)
so i want to generate report (maybe as pdf file) for customer A, and then send to Customer A's email
how to do this using job queue?
thanks

yukon

Hi casanova,

Many people dicuss and solved this requirement. I hope you can find in forum.

Regards,
Yukon

casanova

yukon wrote:

Hi casanova,

Many people dicuss and solved this requirement. I hope you can find in forum.

Regards,
Yukon

hi yukon,
i know but i haven't found any discussion about automatic print as pdf (and then separate for each customer)
and then send to their email directly

BardurKnudsen

Assuming you are running NAV2013, I would
1) Create one or more codeunits to execute the reports in the Job Queue.
2) In the codeunit, set filters etc. and use Report.SAVEASPDF.
3) In the codeunit, use codeunit 400 SMTP Mail (requires some setup of server and login info) to create a mail and attach the pdf file from step 2.

Excepti0nal

BardurKnudsen wrote:

Assuming you are running NAV2013, I would
1) Create one or more codeunits to execute the reports in the Job Queue.
2) In the codeunit, set filters etc. and use Report.SAVEASPDF.
3) In the codeunit, use codeunit 400 SMTP Mail (requires some setup of server and login info) to create a mail and attach the pdf file from step 2.

BardurKnudsen is correct, we did a similar modifcation to email an invoice when posted.

yukon

Dear casanova,

I search for you

How to save Navision Reports as PDF http://mibuso.com/forum/viewtopic.php?f=5&t=18331&hilit=bullzip
Sending NAV Reports by mail as PDF : http://mibuso.com/forum/viewtopic.php?f=23&t=55325&hilit=bullzip
Send email with PDF attachment in NAV 2009 : http://blogs.msdn.com/b/nav/archive/2009/10/08/send-email-with-pdf-attachment-in-nav-2009.aspx
PDF Creation from NAS JOBQUEUE : http://mibuso.com/forum/viewtopic.php?f=32&t=49398&hilit=jobqueue+pdf

It's not exactly same what you want, i hope you can refer from above link. "BardurKnudsen" already gave best idea to you. :thumbsup:

Best Regards,
Yukon

Rob_Hansen

If the client would prefer not to reinvent the wheel here, we have an add-on for NAV2009R2 and NAV 2013 that provides this functionality. It also has an option to include copies of all open invoices along with each statement (so it produces a single PDF for each customer with the statement and copies of all open/unpaid documents). You can PM me if you'd like more info. (I don't want this to come across as me spamming out a pitch for our product!)