schedule report mailing without leaving access open?

Is there a way I can schedule something that will open an access
database, run a report, email it to an Outlook distibution list (in
word/RTF format), and then close the database? All of this is using
Access 2003.

If I use a macro then I have the be in the database already!

re: schedule report mailing without leaving access open?

http://www.mvps.org/access/modules/mdl0042.htm

re: schedule report mailing without leaving access open?

Will that just open the database, or will that actually run the a
report, email it, and then close the database?

Or at least is there a way to open the database and open a form?



*** Sent via Developersdex http://www.developersdex.com ***

re: schedule report mailing without leaving access open?

You can use the AutoExec macro. It executes when you open the database
(unless you hold the Shift key). A simple OpenForm will do; do the rest
of your activities from that form, I'd say.

Michael Botsko wrote:
[color=blue]
> Will that just open the database, or will that actually run the a
> report, email it, and then close the database?
>
> Or at least is there a way to open the database and open a form?
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***[/color]

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
For human replies, replace the queue with a tea

re: schedule report mailing without leaving access open?

it's a scheduler. it'll open the database. You could create a macro
to call the code you need to do the rest.

Yeah, the code will even cook your dinner.