PDF to email from AS/400

50 pts.
AS/400 PDF
BigKat: I tried with OpsNav. Asked for a printer to convert something. Could only create one. Click finish. No mail to myself but report is in the queue I created.

Answer Wiki

Thanks. We'll let you know when a new response is added.

We have a software that resides on the AS400 that allows you to set up automated jobs that convert spoolfiles into numerous different formats (PDF included) and email the report to specified users. This eliminates a lot of the manual work involved in creating PDF files and emailing daily. The software company is DRV Technologies and the software itself is called SpoolFlex (and ReportFlex for more features).

Discuss This Question: 3  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Whatis23
    If you can see your report in Ops Nav, just drag and drop to your desktop then attach to your email.
    5,665 pointsBadges:
  • DK97
    Thanks for responding. The drag & drop would be too much. We have approx. 100 users that need reports. I am new to setting some of this up so I just left clicked on the report name and selected 'create PDF file". I did not do anything else. See, a 'newbie'. We run a job that scans all of the reports from out financial dayend and census. The job has parameters the we setup to select by various data from the reports and breakes it out to a packet with the dept. name on a header page.
    50 pointsBadges:
  • WoodEngineer
    We do something very similar, using Gumbo Send Spool Mail tool. It is reasonably priced and works well. This is how we handle it in our shop . . . All spool files to be processed by SndSplMail are directed to one output queue. A data queue is attached to the output queue. When a spool files lands in the output queue with RDY status, a program wakes up and checks the spool file attributes. Based on these attributes, the program does a file lookup to see which users should get the report. It then issues SNDSPLMAIL commands, which converts the report to PDF and e-mails it to the user. Finally, it moves the spool file to another output queue where it lives for a few days. If the user says they did not get the report, we just move the report back to the monitored output queue and it is automatically sent again. Today we use the spool file name, form type, and 10-character user data field to control report distribution. A while back IBM added a couple of other fields that can also be used by your program to determine distribution. This process saves us tons of time and tons of paper.
    8,225 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: