Re: Email Reports

["Chris Devous" <cdevous@xxxxxxxxxxx>]

Can your 400 connect to your mail server?  You will need to setup an SMTP 
gateway on 
the 400.  There is a good article on this at:

http://www.bytware.com/Support/MPlus/egateway.html

How you transport the result is up to you, we use Brad Stone's spooled file 
tools, which 
includes emailing reports (www.bvstools.com), and we really like it.  This is a 
not terribly 
expensive, and very effective set of tools.

You can also "do it yourself" using the mail api's.  Not for the meek.

Another option would be to post the report to your company's web page using 
FTP.  
This is fairly easy to do, you construct a database file containing the 
appropriate HTML 
header code and a BODY tag followed by a <PRE> tag for preformatted text, 
CPYSPLF 
the spool file into the db file, add a record containing </PRE></BODY></HTML> 
tags, 
and FTP the entire thing to a virtual directory on your web server.

We actually do both out of a nightly reporting batch scheduled job, and it 
works very 
well.  No human intervention required.

--Chris

On 27 Mar 2003 at 13:21, Chuck Lewis wrote:

> Hi Folks,
> 
> 
> 
> We have had our remote sales force ask that reports be emailed to
> them. The normal routine has been to run the queries that generated
> these reports and then mail them out. And obviously that takes time.
> 
> 
> 
> We are on V4R5 (hoping to upgrade be on V5R2 real soon on a new box.)
> 
> 
> 
> So is anyone doing anything like this ?
> 
> 
> 
> I'm aware of some of the third party tools. So any feedback on them
> would be fine. Also any home grown stuff ?
> 
> And this might be a stupid question, but if our AS/400 does not have a
> public address, is this even possible ? We have a VPN setup where
> folks can get to our AS/400 remotely.
> 
> Thanks,
> 
> Chuck
>