Re: Email Reports

[MEovino@xxxxxxxxxxxxxxxxx]

> 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.

We use an RPG program that calls the JavaMail API.  You can see how I did
this here -
http://mywebpages.comcast.net/meovino/opensource/rpgjavamail.html

Feel free to improve it if you'd like.

You can use any SMTP server you can access and relay mail through (we're
using Domino's SMTP running on a second 400 - our production box is not on
the public internet).

> 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.

That's how we do it as well, although we are playing around with Infoprint
server to generate PDF's.

Mike E.




                                                                                
                                     
                    "Chuck Lewis"                                               
                                     
                    <clewis@xxxxxxxxxx>         To:     "midrange-l" 
<midrange-l@xxxxxxxxxxxx>                       
                    Sent by:                    cc:                             
                                     
                    midrange-l-bounces@xx       Subject:     Email Reports      
                                     
                    drange.com                                                  
                                     
                                                                                
                                     
                                                                                
                                     
                    03/27/2003 01:21 PM                                         
                                     
                    Please respond to                                           
                                     
                    Midrange Systems                                            
                                     
                    Technical Discussion                                        
                                     
                                                                                
                                     
                                                                                
                                     




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.