First, export a tab delimited text file with the email address and stats
from a query on the Calls table. Use Pegasus mail client to do the mail
merge (create a template text file with placeholders to plug the data from
the text file into). Then, have the macro run a delete query on the Calls
table, or arachive the call records in the Calls Export (History) table.
The macro cam even launch Pegasus for you.
I do a very similar operation for our email billing and it works very well.
btw, if you have the latest copy of the radius.mdb (or whatever it is
named) you should have the necessary queries to do the archiving and
deletion of the Calls records :)
At 09:56 AM 7/7/98 -0400, you wrote:
>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
>Sorry if these have been answered before, the search page at iea is not
>working right now.
>Michael G. Minnich, President Access Visions Corporation
>Voice: 937.593.7177 x.126 Fax: 937.592.4165
InterNet Access Network
18 McDaniel Street
Dayton, OH 45405-4816
Voice: 937-461-3660 Fax:937-228-2773