Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 8217
Location: Dubuque, Iowa, USA

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 Prblem with mail having MIME contents harsh.saxena579 JCL & VSAM 2 Tue Dec 12, 2017 3:48 pm
No new posts Unable to send mail with SMTP commands harsh.saxena579 JCL & VSAM 10 Tue Dec 12, 2017 1:58 pm
No new posts Moving a PS file as body of a mail! Vignesh Sid JCL & VSAM 4 Tue Nov 21, 2017 9:23 pm
No new posts Rexx to send an email without SMTP Se... upendrasri All Other Mainframe Topics 12 Sun Nov 19, 2017 7:59 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us