| View previous topic :: View next topic |
| Author |
Message |
tvssv
Beginner
Joined: 11 Mar 2009
Posts: 58
Topics: 25
|
 Posted: Mon Jul 15, 2019 8:04 am Post subject: How to send email with dataset as a text file. |
 |
|
Hi,
Please help me out with JCL to send the report generated in job as a text file attachement to recepients.
Thanks & Regards
Jagan
_________________
Thanks
TVSSV |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
tvssv
Beginner
Joined: 11 Mar 2009
Posts: 58
Topics: 25
|
| Posted: Tue Jul 16, 2019 5:15 am Post subject: |
|
|
Hi Kolusu,
Thank You. You are Super.
With the help of your link I have coded the below JCL control cards.
| Code: |
HELO SYSA
MAIL FROM: <email>
RCPT TO: <email>
DATA
FROM: <email>
TO: <email>
SUBJECT: XXXXXX WEEKLY REPORT
MIME-VERSION:1.0
CONTENT-TYPE:MULTIPART/MIXED;BOUNDARY=MIME_BOUNDARY
--MIME_BOUNDARY
CONTENT-TYPE:TEXT/PLAIN
CONTENT-DISPOSITION:INLINE
<PRE> <FONT FACE="ARIAL" SIZE=24>
THIS IS AN AUTOMATED MESSAGE GENERATED FROM THE MVS JOB XXXXXX.
THE ATTACHMENT IN THIS EMAIL CONSISTS OF WEEKLY FTP TIMES.
--MIME_BOUNDARY
CONTENT-DISPOSITION: ATTACHMENT;FILENAME="WEEKLY_MIDT_FTP_TIMES.TXT"
CONTENT-TYPE: TEXT
|
This is working perfectly. It is sending the attachment and inline text in email. But I did not see the effect of
| Code: |
<PRE> <FONT FACE="ARIAL" SIZE=24>
|
I am not getting any error also. Actually where this will get into effect is it is in applicable to text in attachment or for the text in email.
How to change the font in attachement and the text in email. Please advise.
Thanks
TVSSV
_________________
Thanks
TVSSV |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Tue Jul 16, 2019 7:24 am Post subject: |
|
|
| tvssv wrote: | Hi Kolusu,
Thank You. You are Super.
|
I would appreciate if you can drop the superlatives. Thanks.
| tvssv wrote: |
This is working perfectly. It is sending the attachment and inline text in email. But I did not see the effect of
| Code: |
<PRE> <FONT FACE="ARIAL" SIZE=24>
|
I am not getting any error also. Actually where this will get into effect is it is in applicable to text in attachment or for the text in email.
How to change the font in attachement and the text in email. Please advise.
Thanks
TVSSV |
You do realize that text files do not have metadata like font, color or any other attributes. Your text editors like notepad/wordpad have the ability to change the font and size.
If you want font and colors to your attachment then you either need to print the report as PDF or doc or generate the report as HTML.
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
tvssv
Beginner
Joined: 11 Mar 2009
Posts: 58
Topics: 25
|
| Posted: Tue Jul 16, 2019 10:18 am Post subject: |
|
|
Hi Kolusu,
Thank You.
It would be great help if you could provide any document related to this.
How to send the report as PDF or doc. Please advise. Is it possible to send in excell format as well?
Thanks
TVSSV
_________________
Thanks
TVSSV |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Tue Jul 16, 2019 4:11 pm Post subject: |
|
|
| tvssv wrote: | Hi Kolusu,
Thank You.
It would be great help if you could provide any document related to this.
How to send the report as PDF or doc. Please advise. Is it possible to send in excell format as well?
Thanks
TVSSV |
Sigh* You could have helped your self if you followed my earlier suggestion of searching this board.
<Repeat mode on>
Please search before posting. check this link
<Repeat mode off>
http://www.mvsforums.com/helpboards/viewtopic.php?p=40338
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
tvssv
Beginner
Joined: 11 Mar 2009
Posts: 58
Topics: 25
|
| Posted: Wed Jul 17, 2019 9:21 am Post subject: |
|
|
Hi Kolusu,
Thank You.
My requirement is to send the file in excell format. Is it possible. I have searched but I did not found. May be my search string is not correct. I searched as "text file as excel attachement"
Please help.
Thanks
_________________
Thanks
TVSSV |
|
| Back to top |
|
|
Robert Sample
Beginner
Joined: 15 Dec 2009
Posts: 12
Topics: 0
Location: Atlanta
|
| Posted: Wed Jul 17, 2019 10:23 am Post subject: |
|
|
| Quote: | | My requirement is to send the file in excell format. Is it possible. |
That depends upon what you mean by "excell" (sic) format -- a comma-delimited sequential file can be converted in Excel quickly and easily. If you mean a native Excel .xls (or some variant), then the answer is … maybe. SAS can use ODS to generate Excel on the mainframe. If you don't have SAS, then you may need to find and download the Microsoft output file format document for Excel (which ran over 1,000 pages the last time I checked in 2012) and use that as a guideline to write code to convert your report into .xls (or .xlsx) and then transfer it to a PC. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Thu Jul 18, 2019 8:23 am Post subject: |
|
|
| tvssv wrote: | Hi Kolusu,
Thank You.
My requirement is to send the file in excell format. Is it possible. I have searched but I did not found. May be my search string is not correct. I searched as "text file as excel attachement"
Please help.
Thanks |
tvssv,
As Robert mentioned, creating a simple CSV file from a mainframe file is quite simple. we can add the delimiter(for example tab char CHR(9)) as a header and if you FTP it to the PC and save as .xls and you should be able to open with Excel
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Nic Clouston
Advanced
Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home
|
| Posted: Thu Jul 18, 2019 9:00 am Post subject: |
|
|
Kolusu, I dont know how you searched but when I use keyword TXT2PDF and Author Kolusu and search forum Utilities I get no hits.
I want to update that thread as the first link does not work. In fact, I cannot find the link to download the file on that website. The documentation link still works. I found a link to a tar.gz file on another site
https://homerow.net/files/txt2pdf-19.113.tar.gz
_________________
Utility and Program control cards are NOT, repeat NOT, JCL. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Fri Jul 19, 2019 6:43 am Post subject: |
|
|
| Nic Clouston wrote: | Kolusu, I dont know how you searched but when I use keyword TXT2PDF and Author Kolusu and search forum Utilities I get no hits.
I want to update that thread as the first link does not work. In fact, I cannot find the link to download the file on that website. The documentation link still works. I found a link to a tar.gz file on another site
https://homerow.net/files/txt2pdf-19.113.tar.gz |
Nic,
I searched for PDF and author as kolusu and it did find the link mentioned above.
Thanks for bringing it to my attention that links is broken
All of tools from Lionel Dyck are found here
http://www.lbdsoftware.com/tcpip.html
The link you posted is from the original author and I believe Lionel made more changes to it.
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Nic Clouston
Advanced
Joined: 01 Feb 2007
Posts: 1075
Topics: 7
Location: At Home
|
| Posted: Fri Jul 19, 2019 7:51 am Post subject: |
|
|
Interesting. Keyword 'txt2pdf' Author 'kolusu'. If I check 'Search topic titles and message text' I get no hits. If I check 'search message text' I get the result I want. It obviously does not search the message text if the keyword is not found in the title. Not what I expected.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
Please search before posting. check this link
