I am running a vey old version of mainframe FOCUS, Rel. 7.1. My question/plight: I have a program that holds an output file in Excel format. I need to e-mail that Excel file to a user. How would I go about doing this in an older release of mainframe FOCUS?

Thank you - looking forward to hearing from all of you.

This message has been edited. Last edited by: Kerry,

I think you can do it with JCL:

//*------------------------------------------
//*   SEND MAIL FILE text
//*------------------------------------------
//STEPERR  EXEC PGM=IEBGENER                      
//SYSIN    DD  DUMMY                              
//SYSPRINT DD  SYSOUT=A                           
//SYSUT1   DD  DISP=SHR,DSN=XX.XXXX.MAIL(MYLIST)  
//         DD  *                                  
SUBJECT: XXXXXXXXXXXXXXXXXX
mime-version: 1.0          
content-type: text/plain;  
content-disposition: attachment;             
//         DD  DSN=WW.HHHHH.DATASET,DISP=SHR 
//*                                          
//SYSUT2    DD  SYSOUT=(Z,NETSMTP)           

Dataset MYLIST :

helo mvaa                                    
mail from:<xxxx§yyy.com>     
RCPT TO:<user§yyy.COM>        
data                                         
from:   xxxx§yyy.com         
to:     user§yyy.COM          
cc:                                          

AC1,

Thank you for the suggestion... I'll take your sample and modify it for my test and see what happens. I appreciate your reply.

My daughter just came back from a trip to Italy and she loved it. She wants to come back.

ac1,

I tried what you suggested, however, nothing comes to my outlook e-mail. I only see messages that the job routed something to SMTP, but that's about as far as it gets. If you have any suggestions, I would love to hear them.

Thanks again!

I assume the mail server has to be specified somewhere in the JCL, or is it pre-defined to the mainframe somehow?

It is specified somewhere in the JCL, as in this case in ac1's reply.

quote:

//SYSUT2 DD SYSOUT=(Z,NETSMTP)

The mail server is referenced via the domain name immediately following HELO. In ac1's example, it was "mvaa"
You may need to check with your system folks what the domain name for your environment is. The //SYSUT2 DD SYSOUT=(Z,NETSMTP) indicates that Z is the JES class used for SMTP processing. Again, your systems folks should be able to give you the value for that.

Hi, Diptesh, and thank you for replying. I have confirmed those items, but it might be that we don't have SMTP. Do you know of a way that I can check to see if our mainframe has SMTP installed and ready to use? Some of our systems are really quite old, and I just was wondering... perhaps I don't have the use of SMTP.....

Webmeister:
I may be mistaken, but I think SMTP comes with the MVS operating system. However, it needs an SMTP server (software) running. It is possible that your environment may not have it. Your mainframe systems folks should be able to verify whether it is set up.
There are also other third party email utilities that are available. Maybe your company has one of those?
If your windows environment has SMTP available, I think FTP can kick off a command file (looking for documentation). If that is the case, you could FTP the Excel file, then another FTP that executes a cmd file which sends the email. I know this is a roundabout way, but that's what is needed sometimes!

Diptesh,

Thank you for replying.... it does look like we don't have SMTP. The other possibility you mentioned sounds interesting.... can you please tell me more, or point me to where I can get more information? We are using WS-FTP.

Thanks again.

Webmeister:
Sorry, it is not FTP, but a home-grown product we have at my company that allows us to kick off command files.
However, here is another option.
1. FTP your Excel report to a server somewhere.
2. Create a Windows script that will check for the existence of the Excel file. If it exists, the script will use SMTP on Windows to send the email with attachment, then delete the file.
3. On any PC (that will be logged on to the network when the excel file is FTP'd), use the Scheduled Tasks (Start... Settings...Control Panel) to schedule the script to run at whatever time (or time interval) you choose.
If you do not have SMTP on Windows, there are freeware products that you can use. A couple of examples are 'bmail' and 'Free SMTP Server' (from softstack).

Thank you again Diptesh,

I appreciate you taking the time to reply and make suggestions. I am somewhat following the FTP track, i.e., assign the user to a server and then using JCL, FTP-ing my output file to a server, where the user can determine if the file exists there or not,

Sounds like a sensible solution, yes?