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.
Set a password for an EXCEL while sending email through JCL.
Moderator: mickeydusaor
-
- New Member
- Posts: 2
- Joined: Sun Jan 18, 2015 11:38 pm
- Robert Sample
- Global Moderator
- Posts: 1895
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: Set a password for an EXCEL while sending email through JCL.
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).
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).
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute