RE: E-Mail Reports Generated on the AS/400

We had the same problem.  We are not using client access, but connect 
all of our PC's to the AS/400 via TCP/IP.  We ended up developing a 
solution using Microsoft Access and FTP.  The user starts the  Access 
application and an AS/400 terminal session on their computer.  They 
can they display the spool file attributes, and hit Copy on the 400 
session.  They press Paste on the Access screen, which then uses FTP 
and the spool file info to copy the spool file to a database file 
using RCMD, and then does a GET of the database file to transfer it to 
their PC, then attach the PC file into a mail attachment.  If the user 
has Monarch on their system, it will also run a Monarch script to 
parse the spool file and convert it into an Excel file.  It might seem 
a little convoluted, but it works very well for us.

Fred Gamache
Fgamache@nlvl.com

-----Original Message-----
From:   Kim Lykins [SMTP:klykins@us.pepperl-fuchs.com]
Sent:   Friday, September 19, 1997 10:40 AM
To:     MIDRANGE-L@midrange.com
Subject:        E-Mail Reports Generated on the AS/400

I need to e-mail reports which are generated on the AS/400.   I would 
like this to be somewhat automated if possible.  Has anyone ever done 
this?  If so how?  I am using TCP/IP.

Thanks,

Kim

Name: Kim Lykins
Company: Pepperl+Fuchs, Inc.
Phone: 1-330-425-3555
Fax: 1-330-425-4607
E-Mail: klykins@us.pepperl-fuchs.com
Visit our Web Site: http://www.pepperl-fuchs.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to 
"MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your 
message.
| Questions should be directed to the list owner/operator: 
david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---