Hello,
Part of my job involves keeping tabs on unusual incident reports.
Everytime
a report comes in, a follow-up report has to be filed with our
regulators at
30-, 60-, and 90-day intervals after the initial incident. As simple as
this
might sound I have a difficult time keeping on top what follow-ups have
to
filed by what time.
I already have a report that produces a timeline based on today's date
however what I want to know is two things:
1. Is is possible to have Access generate the report automatically at a
regular interval (like every Monday morning)? And is it possible to
have the
program do this without even starting Access up?
2. Is it possible--once Access generates this report--to have the
program
automatically email it to my regional managers via Outlook?
Any help on this would be tremendously appreciated.
Thanks
David