D
Dave
Is there a way to automatically have Access e-mail out a
report each morning?
Thanks!
report each morning?
Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Steve Schapel
Dave,
Yes. The specifics of how to do this will depend a lot on the details
of whether the report is going to one or more recipients, the format you
want the report to be sent as, and what event is applicable to trigger
the emailing. Have a look at the SendObject action/method.
Yes. The specifics of how to do this will depend a lot on the details
of whether the report is going to one or more recipients, the format you
want the report to be sent as, and what event is applicable to trigger
the emailing. Have a look at the SendObject action/method.
G
Guest
Actually, I have the report set up as a macro and I can
run the macro and it is sent to the appropriate people.
What I was really looking for is a way to have the macro
run at a certain time each day without anybody initiating
the macro.
Thanks.
run the macro and it is sent to the appropriate people.
What I was really looking for is a way to have the macro
run at a certain time each day without anybody initiating
the macro.
Thanks.
S
Steve Schapel
Dave,
Thanks for the further information, which is helpful.
You can use Windows Task Scheduler, or a third-party scheduling
programme, to run the macro. The command line will probably be
something like this...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourDB.mdb" /x macroname
Other possibilities, which may be applicable if you don't need the
timing precise, are to use the On Timer event of a form which would
normally be open at the time that you want the reports to go. Or to run
the macro when the database is first opened for the day, or when a
particular form is first opened for the day.
Thanks for the further information, which is helpful.
You can use Windows Task Scheduler, or a third-party scheduling
programme, to run the macro. The command line will probably be
something like this...
"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\YourDB.mdb" /x macroname
Other possibilities, which may be applicable if you don't need the
timing precise, are to use the On Timer event of a form which would
normally be open at the time that you want the reports to go. Or to run
the macro when the database is first opened for the day, or when a
particular form is first opened for the day.
G
Guest
hi ..thanks for the help..i really needed it..but can u give the code of the macro or how to implement it...i am not much familiar with access...wht i need is to send the report automatically when one part of project handled by a person is completed. so as soon as he clicks on the complete button it should send out a report to the next person who is going to handle the project as that he could know that he should start with his project now. ru getting me?...pls help me...or may be recommend a really gud book for this.