MVSFORUMS.com

valeti_sashi

We are facing a problem in sending excel files through XMITIP.

I tried sending a PS file as excel created by focus code, using XMITIP step. But the JCL gave an error message saying '

kolusu · Posted: Thu Jun 02, 2005 5:29 am Post subject:

valeti_sashi,

Please post your question only once and in only one forum. I am deleting your duplicate post. Also please search before posting. This topic has been discussed earlier.

http://www.mvsforums.com/helpboards/viewtopic.php?t=439&highlight=attachment

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

sree_sen · Beginner Joined: 24 Jun 2005 Posts: 10 Topics: 3

Hi Valeti,

Could you please tell me how did you create the excel file from a PS using FOCUS tool. DO you have any snippet for this?

And also, when you have the PS file why aren't you trying to send the ps file thru jcl instead of the excel format.
_________________
-Sree

Jaya · Posted: Tue Aug 08, 2006 3:38 am Post subject:

Hi,

I am currently sending an EMAIL with .CSV file as an attachment and it is working fine. The attached CSV file have 7 columns. The first row is the header and the remaining row has detail information. I did like to know whether it is possible to format the attached CSV file.
Say..
1. I wanted to make the first row, the header row as bold and give some colouring to the first row cells if possible..
2. Fix the column width of all the 7 columns from A to G.

Thanks,
Jayaprakash S.
_________________
"Great spirits have always encountered violent opposition from mediocre minds."
-Albert Einstein

kolusu · Posted: Tue Aug 08, 2006 5:22 am Post subject:

Jaya,

1. I am not sure if you can do it on mainframe
2. Why not create the .csv file with column width it self ?

ex:

Jaya · Posted: Tue Aug 08, 2006 7:11 am Post subject:

Kolusu,

Thanks for the reply...

I have generated the comma seperated fixed block file using a code similar to your model code. The data is getting seggregated properly among the columns i.e My detail lines are in sync with their header. But there is no link between the picture clause of the header field , detail field and the column width of (A to G columns) seen while opening the CSV file in the mail attachment. All columns in CSV file have some default column width. To read that CSV file, i have to manually allign the columns by right clicking a selected column and increasing the Column width parameter.

Just thinking of controlling that view by means a mainframe code.

Thanks,
Jaya.
_________________
"Great spirits have always encountered violent opposition from mediocre minds."
-Albert Einstein