Print/Send A Report Everyday By 0730

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a report in MS-Access 97/2003 that needs to printed / sent everyday
by 0730. My email client is Lotus Notes 6.5. I have read the automation
process for printing a report, but there is nothing in the article on how to
print/send at a specific time. Can someone show me an example???

Thank you,
 
Set up a macro to do whatever it is you need Access to do. Then, go to:
StartMenu --> Settings --> Control Panel --> Scheduled Tasks

Select "Add Scheduled Task", then when it asks what you would like to run,
just select The Access program itself, don't worry too much about what you
are selecting. After you have Added a task, go back to the task, right-click
on the task, and select "Properties". Change the schedule to whatever you
would like. In the "Task" tab, put in this command:
"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"H:\PlantApps\Discipline Notices\Simon.mdb" /x "IncdataA33Update"

Note: You may have to change the location of your Access.exe if it is not
in the same folder mine is in. Also, you must put in the full address of
where ever it is your database is located. In my case, the database is on my
H drive. The "/x" means to run the macro. Now you can have your report print
whenever you would like, just leave your PC on.
 
Back
Top