Create an Excel spreadsheet from iSeries spool file

750 pts.
Tags:
AS/400
iSeries
Microsoft Excel
Using the DSPUSRPRF command, I want to create an outfile, then I will want to take the spool file and create a PDF, then email it to users. Can someone offer the steps I would need to take to accomplish this? Thanks for any help you can offer.
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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.
  • CharlieBrowne

    Do you want to produce a single report and send it to users or a separate report for each user with their own information?

    Do you already have tools on your system to email .PDF documents?

    Just curious, Why are you doing this? Most of the information attached to the USRPRF would not make sense to a non-IT person.

    62,385 pointsBadges:
    report
  • ToddN2000
    Strange request. You also mention Excel in the heading but not in the question itself. Can you explain the reason for the unusual request? It may help us to understand better. There may be another alternative.
    131,380 pointsBadges:
    report
  • philpl1jb

    I would do the DSPUSRPRF to an *OUTFILE

    and then use CPYTOIMPF to a comma delimited file

    or download with client access

    or display in Navigator and copy to spreadsheet.

    54,090 pointsBadges:
    report

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.

Following

Share this item with your network: