RE: Email Reports

Chuck,

Just to add to the list of comments/eperiences...

We use the SNDEMAIL utility published by News400 (iSeries Network).
It's not fancy but it will handle a single attachment (spool file)
with no problem.  Converting a spool file to an IFS text file is
a no-brainer.  It also worked fine under V4R5.  Been running it 
for a couple of years with *no* problems.

Our mail goes out thru our local M$-Exchange server, but I
believe any SMTP complient mail server will work providing you
can get to it across your network :)  

The only problem we encountered was a break-up and/or loss of
large spool files.  To solve this you must change the AS/400
POP attribute for message splitting to *NOMAX (CHGPOPA MSGSPLIT).

Of course, the mail server on the other end may puke when it gets
a large attachment (we had this happen with an older version of 
M$-Exchange :).

Terry
  

> -----Original Message-----
> From: Chuck Lewis [mailto:clewis@xxxxxxxxxx] 
> Sent: Thursday, March 27, 2003 1:21 PM
> To: midrange-l
> Subject: Email Reports
> 
> 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