Scheduling Reports

[Rhonda Noble]

Hello,

Here's the problem: I have many reports which have many different
distribution lists. I have created a macro that will e-mail the reports
upon activation, which is good, but what I'd really like is to set up a
daily schedule for these assorted reports to automatically run and be
e-mailed. Example: report 123 to activate M - F @ 8:00am and e-mailed out
to distribution.

Can I get there from here??? Any help will be greatly appreciated.

Thanks,
Dean

 

[SA]

Dean:

There's two ways to go about doing this. Probably the easiest is to create
a vb function that will output your report as desired. Then use Windows
Scripting Host and vb script to launch access and run your function (using
the Application.Run command). Then use the Windows task scheduler to
automate the output time.

You'll find a sample script on our web in the Code and Design tips area
under Reports and scheduling reports.