Send a report through electronic mail at predetermined time

[Guest]

I would like a report to be sent to the Top Management at 9.00PM Daily
without anyone running the Macro. I had already set a Macro for Sendobject.
But, the report is sent only when the Macro is run. I want to run it (send
the report ) on a daily basis at 9.00PM automatically. ( Even if no one is
available in office to run the Macro).

 

[Guest]

I would use the the Windows task scheduler or any other scheduling product.
Using the windows scheduler...
- add a Scheduled Task
- migrate to Microsoft Access as the program you want to run
- when you've completed the wizard, right click to view the properties of
the new task
- you'll need to add the path of your database, in quotes, to the end
of the existing string in the "Run" box.
- then, at the end of the path you just added, enter the following...
/x NameOfMacro
- it should look something like this: "C:\Program Files\Microsoft
Office\Office\msaccess.exe" "C:\My Documents\MyDatabase.mdb" /x NameOfMacro
--the first part may vary depending on the version of Access
you're running--

That should do it