Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need help to know how to send mail with .xls attachment

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
vijaysankar

New User


Joined: 27 Feb 2008
Posts: 9
Location: chennai

PostPosted: Wed May 12, 2010 2:19 pm    Post subject: Need help to know how to send mail with .xls attachment
Reply with quote

Can any one inform me , where I can find the detail for how to send mail through JCL with excel attachment
Back to top
View user's profile Send private message

Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Wed May 12, 2010 2:28 pm    Post subject:
Reply with quote

Before that I wonder How you created valid XLS which you are trying to attach?
Back to top
View user's profile Send private message
vijaysankar

New User


Joined: 27 Feb 2008
Posts: 9
Location: chennai

PostPosted: Wed May 12, 2010 2:37 pm    Post subject:
Reply with quote

right now I am able to send the PS file in .TXT format. I saw some discussion in this forums, they are able to send mail with .xls as attachment.
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Wed May 12, 2010 2:43 pm    Post subject:
Reply with quote

vijaysankar wrote:
right now I am able to send the PS file in .TXT format. I saw some discussion in this forums, they are able to send mail with .xls as attachment.

so it's not the business requirement.
anyways, post the thread which you are referring to and what you want to understand...
Back to top
View user's profile Send private message
vijaysankar

New User


Joined: 27 Feb 2008
Posts: 9
Location: chennai

PostPosted: Wed May 12, 2010 2:52 pm    Post subject:
Reply with quote

icon_sad.gif ..i missout the link...that why i posted here to know how to code JCL for my requirement. My PS file contains report of my testing. every time when I ran my JCL I will receive an mail with .TXT as attachment, then I use to change the text file into EXCEL sheet format. Instead of changing every time, it will be better if i receive the mail in excel sheet format.

My code is

//SYSTSIN DD *
EXECUTIL SEARCHDD(YES)
ISPSTART CMD(EOCPNOTE)
/*
//MSGFILE DD *
-SUB RULE DETAIL'S
-START MESSAGE -
/*
// DD DISP=SHR,DSN=TENV.RPACK.TOOLS.ZZ.JCL(MAILV)
// DD *
-ATT- DSN TENV.LLU50.TOOL.OUTPUT.REPORT
/*
// DD *
-MSG-
-MSG-
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7989
Location: Bellevue, IA

PostPosted: Wed May 12, 2010 5:05 pm    Post subject:
Reply with quote

Excel is a Microsoft standard and there are documents on the Internet that will give you all the specifications you need to create a .xls file on the mainframe to send to a PC. However, the last time I looked I estimated probably 1000 to 2000 hours of effort to design, implement, and test such a solution because the Excel format specifications are hundreds of pages.

Another option is to convince your organization to spends the tens (or hundreds) of thousands of dollars required to purchase a product that does such conversions.

The cheapest, easiest option is to give up on the idea of generating Excel files on the mainframe, create .csv (comma delimited) files and transfer them. Excel quite happily reads .csv files and they are pretty easy to create -- much easier than .xls files.
Back to top
View user's profile Send private message
donateeye
Warnings : 2

New User


Joined: 01 Jun 2007
Posts: 62
Location: chennai

PostPosted: Fri May 14, 2010 2:24 pm    Post subject:
Reply with quote

As Robert said, you can use the tect file, .csv format. Infact you dont have to create one... whatever you have in excel, just do a Save As to have it in txt or csv format and then xmit it.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri May 14, 2010 8:17 pm    Post subject:
Reply with quote

Hello,

Quote:
whatever you have in excel, just do a Save As to have it in txt or csv format and then xmit it.
Before posting "just anything" you need to read the request and provide an answer that has something to do with the question/requirement.

Why do you suggest saving from Excel when the task is to create a mainframe file to be read into Excel. . . icon_sad.gif

And improperly quoting someone else gives false info. . . Robert said nothing like what you posted.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Mail via SMTP with an image? Mike 1304 JCL & VSAM 4 Thu Jan 26, 2017 2:01 pm
No new posts Reading data from PS file and send it... rajatbagga All Other Mainframe Topics 18 Fri Sep 23, 2016 12:51 pm
No new posts Send parameter for macro STIMERM from... Daniel Teolotitla PL/I & Assembler 13 Tue Jul 05, 2016 9:23 pm
No new posts How to send email with Rich Text usin... santhosh5983 JCL & VSAM 4 Fri Apr 08, 2016 2:30 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us