RE: Email Reports -- MIDRANGE-L

There are a couple of utilities published in "Iseries Network" that will do
the trick.  IIRC, one's called MIMEML (Dave Leland) and the other is called
MSF (David Morris.)  You can also use SNDDST for this.  

The easiest thing to do is convert the spooled files into text files in an
IFS directory and send them as attachments.  It's much easier to preserve
formatting that way.  Wrap your preferred mail sending program/command in a
program that loops through a distribution list.

If you can set the mail server on your 400 to use your regular mail server
as a relay, you're done.  IIRC what you need to do is CHGSMTPA and set the
mail router parameter to the name (if you have DNS or a host table) or IP
address of your mail server.  

Seems to me there's a simple doc on the bytware.com site that explains this
better than the above.  This is one of those best kept secrets things that
you can set up in half a day if everything goes smoothly. 

We've been sending reports by e-mail for a couple of years now with nothing
more elaborate.  There are also fairly inexpensive programs you can buy.

 
> -----Original Message-----
> From: Chuck Lewis [mailto:clewis@xxxxxxxxxx]
> Sent: Thursday, March 27, 2003 10:21 AM
> 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
> 
>  
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
NOTICE:
All e-mail sent to or from this e-mail address will be received or otherwise
recorded 
by The Sharper Image corporate e-mail system and is subject to archival, 
monitoring, review by and/or disclosure to Sharper Image security and other 
management. This message is intended only for the use of the addressee and
may 
contain information that is privileged and confidential. The contents of
this message 
may contain personal views which are not the views of The Sharper Image. If
you are 
not the intended recipient, dissemination of this communication is
prohibited.