| View previous topic :: View next topic |
| Author |
Message |
Austere
Beginner
Joined: 29 Jun 2005
Posts: 2
Topics: 1
|
 Posted: Wed Jun 29, 2005 7:03 pm Post subject: Sending a csv format sheet as an email attachment |
 |
|
[color=darkblue]Hi,
i'm glad to join this forum, i've been surfing in it for some time & it's quite interesting.
The problem i have is, i can't send a comma delimited dataset (sequential file) thru email as a csv format spread-sheet attachment.
i've searched the forum's database and found some stuff but couldn't fix my problem! i could send plain txt attachments but other formats no.
The point is we aren't supposed to use REXX anymore over here so i need an alternative.
Thanks in advance,
Austere.[/color] |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Thu Jun 30, 2005 5:10 am Post subject: |
|
|
Austere,
Can't you send the attachment as txt document and once you recieve it can't you open with excel? Since your file is comma delimted it will automatically format the cells.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Austere
Beginner
Joined: 29 Jun 2005
Posts: 2
Topics: 1
|
| Posted: Thu Jun 30, 2005 8:26 am Post subject: |
|
|
Hi,
yes, this would be the last resort.
i tried using the following code:
| Code: |
//JS020 EXEC PGM=WAAPDSUT
//SYSUT1 DD DSN=XXXX.XXXX(HEADER),
// DISP=(SHR,KEEP,KEEP)
// DD DSN=XXXX.XXXX.XXXX, => This is the dataset having the data (comma delimited)
// DISP=(SHR,KEEP,KEEP)
//SYSUT2 DD SYSOUT=A,DEST=(XXXXXXX,NETISMTP)
//SYSPRINT DD SYSOUT=*
where the HEADER part is:
HELO SYS.XXXX.COM
MAIL FROM: <XXXX.XXXX@XXXX.COM>
RCPT TO: <XXXX.XXXX@XXXX.COM>
DATA
FROM: <XXXX.XXXX@XXXX.COM>
TO: <XXXX.XXXX@XXXX.COM>
SUBJECT: XXXX DATA SPREAD-SHEET
MIME-VERSION: 1.0
CONTENT-TYPE: MULTIPART/MIXED; BOUNDARY="BOUNDLINE"
THIS IS A MULTI-PART MESSAGE IN MIME FORMAT.
--BOUNDLINE
CONTENT-TYPE: TEXT/PLAIN; CHARSET=US-ASCII
CONTENT-TRANSFER-ENCODING: 7BIT
ATTACHMENT IS REQUESTED REPORT
--BOUNDLINE
CONTENT-TYPE: TEXT/PLAIN; CHARSET=US-ASCII; NAME="XXXX-SHEET.CSV"
CONTENT-TRANSFER-ENCODING: 7BIT
CONTENT-DISPOSITION: INLINE
|
i managed to get an email with a .csv sheet attached but the file is empty.
How could i get it to fill it in??
Thanks,
Austere. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
