Schedueled Task (1 Viewer)

[ChristopherL]

Hi there,
I have a report that I run manually from my computer every day.
This report is created by a macro in microsoft access, then it runs a VBA macro to send it out..

Is there a way that I can add this as a schedueled task since I usually forget to send it out?

Regards,
C

 

[namliam]

Yes quite easilly too, just call the MSAccess.exe with the command line to run the database/macro and you are golden.

http://support.microsoft.com/kb/209207/en

 

[ChristopherL]

Yes quite easilly too, just call the MSAccess.exe with the command line to run the database/macro and you are golden.

http://support.microsoft.com/kb/209207/en

Thank you!
Sorry for late reply, I've been on vacay

I am quite new to this and how it works..
So for this to run a macro called macro1 and VBA function "sendemail".
How do I make that work?

 

[namliam]

Try reading the linked page and see where you get stuck?
The switch /x
Starts Access and runs the specified
macro. Another way to run a macro when
you open a database is to use an
AutoExec macro.