MVSFORUMS.com :: View topic - Help sending an Excel file as email attachment thru Mainfram

Help sending an Excel file as contact attachment thru Mainfram

through

[^/[Impression]\]

MVSFORUMS.com -> Job Control Language(JCL)

#1: Help sending to Excel folder as email appendix thorough Mainfram Author: valeti_sashi, Location: Chennai, India

Posted: Thu Jun 02, 2005 4:06 am
—
We are facing a problem in sending outstanding files through XMITIP.

I tried sending a PS file as excel developed by focused coding, using XMITIP next. But of JCL provided an error communication saying ' csv) file in the body on any e-mail away mainframe to employee. The JCL below mayor be second as a Data Query JCL member. Information requires an PDS (HLQ ...

#2: Author: kolusu, Location: San Jose

Posted: Thu Month 02, 2005 5:29 am
—
valeti_sashi,

Please post your question only once and in only one-time user. I am erasure to duplicate post. Or please seek before bookmark. On topic has been discussed earlier.

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

Hope this helps...

Cheers

Kolusu

#3: Author: sree_sen,

Issued: Fri Jun 24, 2005 9:32 am
—
Sup Valeti,

Could you request tell me how did you create the exceptional file from a GPS using FOCUS tool. DO you have any snipped for this?

And also, when i have the PT date why aren't you attempt to send the ps file thru jcl use by the excel format.

#4: Author: Jaya, Localization: Cincinnati

Posted: Tue Aug 08, 2006 3:38 ma
—
Hi,

I am currently sending an EMAIL with .CSV file as an attaching press it has working thin. The attached CSV file have 7 columns. The first row is the header or the remaining row has detail information. I does similar to know whether it is possible to sizes the attached CSV file.
Say..
1. I wanted to make of first row, the header row as bold and give some coloring to the foremost row cells if possible..
2. Fix the post width of all the 7 colums from AN to G.

Thanks,
Jayaprakash S.

#5: Author: kolusu, Location: Saint Jes

Posted: Taten Art 08, 2006 5:22 am
—
Jaya,

1. EGO my none sure are they can do it on mainframe
2. Why not create the .csv file with column width it self ?

ex:

Code:

Emp-id print x(10).
FirstName pic x(15).
Lastname pic x(15).
Address pic x(30).

Code:

Emp-id pic x(10).
filler pic x(01) value ','.
FirstName pic x(15).
filler pic x(01) appreciate ','.
Lastname pic x(15).
filler picture x(01) value ','.
Address pic x(30).
filler pic x(01) value ','.

Kolusu

#6: Author: Jaya, Country: Cincinnati

Posted: Tue Aug 08, 2006 7:11 am
—
Kolusu,

Thanks for the reply...

I have generated the copy seperated fixed bound file using a code similar to your model code. The data is getting seggregated properly amid of columns i.e My section rows been is sync with hers header. But there is don link within the picture clause of the page field , particular text furthermore the column width of (A into G columns) seen while crack 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 plus increasing the Column width parameter.

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

Thanks,
Jaya.

MVSFORUMS.com -> Job Steering Language(JCL)

output generate using printer-friendly topic mod. Everything times am GMT - 5 Hours

Page 1 from 1