JS:
It can be done, to be sure, but it takes a number of steps to automate this.
First, Access has no scheduling capability built in. So you have use
something like the Windows scheduler to schedule Access to run, open your db
and to output a report at a specific time. If you look on our web in the
Code and Design tips area under Reports, there's a discussion of how to do
exactly this and some sample code.
Second, the code in that example will print a report at a specific time, but
you want to e-mail it. So you need to create a whole routine to create the
report as a file and attach it to an e-mail and then send it. You'd have
the vbs run by the scheduler run your routine (rather than output the report
directly as shown in the example) by using the Application.Run
(objAccess.Run) command calling a function that you create in the database
itself that outputs and e-mails the file.
Third. that of course requires that you create a function to automate file
creation and attachment to an e-mail. Using Access' main tools, there's no
way to do this without user interaction. But if you take a look at our PDF
and Mail Library for Access (there may be other tools out there as well,)
you can use it to create a field and e-mail and send it all without user
interaction.
Hope that helps
