Dear all,
Hope evry1 is doing great...
We have a requirement, where in the AS400 spool file (report) needs to be converted to a formatted excel sheet and mailed to the respective people.
Details:
1. We have designed the layout of the report using an externally described printer file ==> We have developed a RPG program for this
2. The AS400 spool (report) is generated. ==> Output of RPG program
3. We need to convert it to a formatted excel sheet ==>
4. We need to mail this as an attachment to the required people ==> keep the document in IFS and use SNDDST to mail the attachment.
I have attached a sample of how the excel sheet should come up...
Regards,
Manty
Hope evry1 is doing great...
We have a requirement, where in the AS400 spool file (report) needs to be converted to a formatted excel sheet and mailed to the respective people.
Details:
1. We have designed the layout of the report using an externally described printer file ==> We have developed a RPG program for this
2. The AS400 spool (report) is generated. ==> Output of RPG program
3. We need to convert it to a formatted excel sheet ==>
4. We need to mail this as an attachment to the required people ==> keep the document in IFS and use SNDDST to mail the attachment.
I have attached a sample of how the excel sheet should come up...
Regards,
Manty
Comment