MVSFORUMS.com

[Selvakumar]

Hi,

Suggest an idea of how to send a seq file in xls/csv format through mail. I have used XMITIP.

Details abt the input file:
the input file contains datas with semicolon seperated.
eg:
aaaa ; bbbb; ccc,ddd ; eeee

When i tried sending this in xls/csv format, the pc file contains all the details in a single cell rather than having it in four different cells.

The code is shown below:

//STEP030 EXEC PGM=IKJEFT1B
//SYSEXEC DD DSN=XMITIP.L1.EXEC,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
%XMITIP (mail id) -
SUBJECT 'Report ' -
MSGT 'New Report ' -
FILE ('input seg file name') -
FORMAT HTML/BLU/.XLS//////Y
/*

Thanks,
Zelwaa.
_________________
Thanks,
Zelwaa

-what matters most is how u c urself!!!

[kolusu]

Selva kumar,

Send the file as a text file and when you receive it open it with Excel application. It then will open a dailogue for formatting the data with a delimited option.

Hope this helps...

Cheers

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

[Selvakumar]

No Kolusu, i cant do that as the receiving end is the other department.

I managed to send the file in CSV format with a little change in the input file format.

Instead of giving the input records like this:
aaaa ; bbbb; ccc,ddd ; eeee

i changed to
aaaa ; bbbb; ="ccc,ddd" ; eeee

and the format in the JCL as
FORMAT CSV

It is working fine.

Thanks for that kolusu.
_________________
Thanks,
Zelwaa

-what matters most is how u c urself!!!