open an excel from the report in the mail

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
KS
Member
Posts: 2
Joined: Tue Jul 10, 2007 10:05 pm

open an excel from the report in the mail

Post by KS » Tue Jul 10, 2007 10:07 pm

Hi all,

I have written a program and a jcl to generate a report in the mail.
Now i wll be getting the report in the mail once the job completes.
I have an additional requirement too, that is ,

In the mail there should be a link shown that on clicking should open the contents in the mail in an excel sheet .

Can you please help?

Thanks,
KS

User avatar
Devendra_singh
Member
Posts: 6
Joined: Tue Jul 03, 2007 10:23 am

Post by Devendra_singh » Wed Jul 11, 2007 2:22 pm

:D :shock:

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Wed Jul 11, 2007 2:43 pm

KS,

In what environment (tso, mainframe mail, pc mail application?) will you be 'clicking' on the hyperlink that will open the Excel sheet, which will be where? (where will the excel db be stored?)
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

MrSpock
Active Member
Posts: 273
Joined: Wed Jun 27, 2007 5:37 pm

Post by MrSpock » Thu Jul 12, 2007 9:32 am

Now, this seems to be the right way to go about doing this task. Create the data, and send it to a repository on a secure server. Create an email to the recipient, providing the URL for them to access the data. Then, they can login to the secure server, download their file, and go about their business.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others