IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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
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
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
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
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Wed May 12, 2010 5:05 pm
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
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

Moderator Emeritus


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

PostPosted: Fri May 14, 2010 8:17 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts mail attachment with excel format All Other Mainframe Topics 2
No new posts REXX to send an email in Mainframe wi... CLIST & REXX 3
No new posts REXX to send an email in Mainframe CLIST & REXX 4
No new posts help send file AFT CONTROLM EM IBM Tools 0
No new posts how to send 10 rows at a time to output CICS 2
Search our Forums:

Back to Top