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
 

 

Email with attachment

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> FAQ & Off Topics
View previous topic :: :: View next topic  
Author Message
swatheeswaran

New User


Joined: 04 Nov 2008
Posts: 7
Location: Chennai

PostPosted: Sat Jun 01, 2013 9:36 am    Post subject: Email with attachment
Reply with quote

We have 4 data sets (data delimited by tab) to be sent through email as excel attachment. Is it possible to put the data in 4 worksheets in a single excel attachment instead of multiple attachments. Please advise...
Back to top
View user's profile Send private message

Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Sat Jun 01, 2013 12:32 pm    Post subject:
Reply with quote

Why not copy the 4 dataset to one and attach?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Sat Jun 01, 2013 2:01 pm    Post subject: Reply to: Email with attachment
Reply with quote

Quote:
Is it possible to put the data in 4 worksheets in a single excel attachment instead of multiple attachments.


NO

topic has been discussed too may times, search the forum for the explanation
Back to top
View user's profile Send private message
swatheeswaran

New User


Joined: 04 Nov 2008
Posts: 7
Location: Chennai

PostPosted: Sat Jun 01, 2013 6:03 pm    Post subject:
Reply with quote

Pandora-Box wrote:
Why not copy the 4 dataset to one and attach?

Thanks for the reply.
Our requirement is to present in different tabs in a spreasheet.Each dataset would be having ~2000 records. For e.g
Dataset 1 has US customers list
Dataset 2 has UK customers list
Dataset 3 has Japan customers list
Dataset 4 has Indian customers list

Instead of attaching four spreadsheets in a email, am checking whether we can put the data in Sheet1,Sheet2,Sheet3 and Sheet 4 in a single spreadsheet.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Sat Jun 01, 2013 6:11 pm    Post subject: Reply to: Email with attachment
Reply with quote

Quote:
Instead of attaching four spreadsheets in a email, am checking whether we can put the data in Sheet1,Sheet2,Sheet3 and Sheet 4 in a single spreadsheet.

NO ( again )

did You search the forum for the why ???

You cannot do that with CSV data ,
You will have to build a WORKSPACE/SPREADSHEET according to EXCEL specifications.

if Your organization has the stringent requirements to do that, there are products able to do it.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Sat Jun 01, 2013 6:14 pm    Post subject:
Reply with quote

Quote:
whether we can put the data in Sheet1,Sheet2,Sheet3 and Sheet 4 in a single spreadsheet
In order to do this, you have a couple of choices:
1) purchase a program to generate Excel files on the mainframe, or use an existing program (such as SAS) to do it. If your site needs to buy such a program, expect to spend between 10 and 100 thousand US dollars for the program.

2) find a copy of the Microsoft file specification on the Internet, and use that to write your own mainframe program to generate Excel spreadsheets files on the mainframe. The specificiations run well over 1000 pages so such a project could be completed by a team of 3 or 4 programmers in about a year, most likely.

Or you could do what most people do and download the worksheets as separate delimited (comma or tab) files and combine them in Excel.
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 -> FAQ & Off Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
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 How to send email with Rich Text usin... santhosh5983 JCL & VSAM 4 Fri Apr 08, 2016 2:30 am
No new posts Issue in sending zip file as mail att... ajithajt JCL & VSAM 8 Thu Apr 07, 2016 9:11 am
No new posts Email trigger through JCL Madhusudhan Prahlad JCL & VSAM 10 Mon Aug 31, 2015 3:43 pm
No new posts Empty excel attachment in mail receiv... gs185008 COBOL Programming 8 Mon Jul 13, 2015 7:45 pm


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