Need to attach a CSV file to Email (AS400)

[Silvano]

Is there a way to attach a .csv file generated by an UBE to an e-mail? I am on a AS/400 platform. I am using the BSFN B0500190 (Send E-Mail - HRM)to send the e-mail, which works fine if I attach a file from a local folder. But how to get the csv file to be attached?

 

[kavehm]

ok, yes and no. there is a way, but you'll have to use Database Output (in the RDA, under the Section file menu) to create your csv file instead of using the UBE print properties to have it output as a csv file. Once that is done, you'll have a consitent path/location where the file will be created and you can use that path location in the send email BSFN. Some things to consider: 1. more than one user running the report, that can affect your csv file
2. Database Output functionality may not work for your example due to complexities of the report design.....
In any case, I hope that helps out a bit, good luck!