RE: emailing reports -- MIDRANGE-L

Along those lines, consider the size of these reports.  They may grow, as
well as,.. when emailed, they usually are kept on the email server, (how
many copies?).

You may want to consider converting the report(s) to an HTML document and
saving it on a server/IFS via FTP or CPYTOPCD/CPYTOSTMF then email a
shortcut, (1 copy of the report).

1. Create a PF such as HTMLFOOT with the HTML tags </BODY></HTML>
2. Create an HTML PF with a record length suitable for the spool file in
QTEMP.
3. Write HTML tags to the file in QTEMP. 
        e.g.    <HTML>
                <HEAD> some stuff here
                <TITLE>Report title, etc. etc.
                </TITLE>
                </HEAD>
                <BODY>
4. CPYF FROMFILE(QTEMP/HTMLPF) TOFILE(YOURLIB/HTMLPF) CRTFILE(*YES)
5. CPYSPLF FILE(SPLFILE) TOFILE(YOURLIB/HTMLPF) MBROPT(*ADD)
6. CPYF FROMFILE(YOURLIB/HTMLFOOT) TOFILE(YOURLIB/HTMLPF) MBROPT(*ADD)

At this point you have an complete HTML document as a PF on your AS/400.
You can FTP to a server or copy to the IFS on your AS/400 and email a
shortcut/link.

You might be able to do this all within a CLP or a combination of CLP & RPG,
or even ILE, etc. or a number of variations.

Hope this helps,..

Regards,
Jon A. Erickson
Sr. Programmer Analyst
800.COM Inc.
1516 NW Thurman St
Portland, OR  97209-2517

Direct: 503.944.3613
Fax: 503.944.3690
Web: http://800.com


-----Original Message-----
From: Rob Berendt [mailto:rob@dekko.com]
Sent: Wednesday, January 12, 2000 6:43 AM
To: MIDRANGE-L@midrange.com
Subject: Re: emailing reports


If the files are simple text then you can do  CPYSPLF to a 
disk file and use the send mail api's to send it out.  The 
packages might be fine.   This do-it-yourself method will 
allow you to gain knowledge that you might use to enhance 
other applications.  You might stop generating reports and 
using emails in some cases.  It'll snowball...





pshrader@wkep.com on 01/11/2000 05:12:21 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        emailing reports

I need to implement a method to email AS/400 reports to my users,
preferably by converting the file to a PDF or Rich Text document to read
with Acrobat or Word. I have seen some information on Gumbo's SpoolMail
program. Anyone familiar with this product or other solutions out there?
Also, any comments on Gumbo's technical support?

Thanks in advance.

Patrick Shrader
White Knight Engineered Products

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| 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 subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| 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 subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---