Job

D

Dan

Hi:

There is any way to automate (like an SQL DTS package)
running and sending by e-mail at certain time a report
from Access XP?!

Thanks,

Dan
 
J

Jim/Chris

Use Windows Task Scheduler, or one of the many third-party
scheduling programs available today, to run the macro using
a command line like
this...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\MyDB.mdb" /x
macroname

The macro would contain the email report command

Jim
 
D

Dan

Hi Jim:

Thanks!

I was thinking the scheduler too, but when I am trying to
create a new schedule...nothing happens?!?

Dan
 
J

Jim/Chris

I have Windows 2000 and Office 2000. Here is my Task
Scheduler run command for the access database
c:\mrs_Dev\AAA\test2c.mdb and the macro MorningReport

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"c:\mrs_Dev\AAA\test2c.mdb" /x "morningreport"

Watch for word wrap

Jim
 
D

Dan

Thank you, Jim!; I will try and see...are you running
those from the command line because my scheduler is not
working...

Dan
 
Top