send automatic reports trough email

Spyroot

Hi guys,

Big request, does any one have an idea how to implement the scheduler reports and send them via email.

Currently I'm using navision 3.7A, and what I'm planning to do is set the report scheduler and send these reports via email.

Any clue where to start?
there is any third party software that I can implement?

Thank you for all your support

KYDutchie

Hi,

To print and email/fax reports there is a 3rd party.
We have it implemented on 3.6. It is called Altus. You can check their website out: http://www.altusbusinesssolutions.com/

I hope this helps,

Willy

Reinhard

Hi, we did something similar.

Either you will have to export the reports to text or excel. Or to PDF. If you want pdf this post should be very helpful:
http://www.mibuso.com/forum/viewtopic.php?t=18331

Then you will have to attach the report to an email. One problem you will encounter is that the pdf printer takes a little while to generate, so I usually do something like a function

waitForFile(fileName,miliSecondsToWait)
{
  start = TIME;
  WHILE NOT FILE.EXISTS(fileName)
  {
    IF (TIME - miliSecondsToWait) > start THEN EXIT(FALSE); // not found
    SLEEP(150);
  }
  EXIT(TRUE); // file found
}

just a couple of things I encountered...

davmac1

We have an email/pdf solution too.
You should be able to do a search on third party products for Navision and come up with a few choices.
I have not noticed any speed problems with our implementation of the pdf writer. Maybe the speed is dependent on which pdf product you use.
I really like the new 400 codeunit introduced in version 5 for smtp mail.
If you do an executable upgrade, you could import some of the new codeunits.

jlandeen

As already suggested you may want to check out the Altus Mail Fax add on. It supports 3.X and can be easily extended to work with job scheduler.

See Code Sample: http://www.altusbusinesssolutions.com/altus_mailfax_developer.asp