Automatic Report Generation

[yeahyeahyeah]

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

 

[gemma-the-husky]

1. yes, can check for a date. you will need a mechanism to make it happen only once. You can't use Access, without starting access up.

2. you can prepare e-mails in access with docmd.sendobject, for your e-mail client. lots of options.