Set a password for an EXCEL while sending email through JCL.

[Black Sheep]

hi,

I need to send an e-mail attachment in the excel format. I shall be using JCL to send the email. The main requirement is that the excel should be
password protected. Is that possible through a JCL? In case it's possible can you please let me know the process.

Appreciate any help.

[Robert Sample]

If you have access to SAS, you can send Excel spreadsheets from a mainframe to a PC. Or if your site has another mainframe software product to generate Excel spreadsheets, you can use that (they can cost quite a bit to acquire if the site doesn't already have one, though).

The general solution, however, is to send the data as a comma-delimited (.CSV) file from the mainframe to the PC. Excel will read comma-delimited data just fine -- but there are restrictions since a .CSV is a text file (such as a single worksheet per file, no fonts, no special characters unless they are in the standard EBCDIC code page being used, no passwords).