1. fetch the data from the database
2. save the report to a text file
3. email the report to the user
4. delete or archive the calls records
Run the script every month.
Go to www.flicks.com to get a free ASP smtp component.
Danny Sinang
-----Original Message-----
From: Michael G. Minnich <mminnich@logan.net>
To: RadiusNT@iea-software.com <RadiusNT@iea-software.com>
Date: Tuesday, July 07, 1998 10:02 PM
Subject: How to e-mail usage reports?
>We have just upgraded to 2.5.124 using (temporarily) an Access database. We
>want to e-mail a usage report to each member at the end of each month,
>showing username, call history, and total usage. Can someone please point
>us to how we can do this?
>
>It would also be nice to automatically then delete or archive the calls
>records for the prior month. I kind of remember a script discussion on this
>point recently.
>
>Sorry if these have been answered before, the search page at iea is not
>working right now.
>
>TIA,
>*********
>Michael G. Minnich, President Access Visions Corporation
>Voice: 937.593.7177 x.126 Fax: 937.592.4165