automatic emailing using a macro within an access database based on system time

[Stuart]

Hi there,

I have a database designed with reports created,

the database is kept open all the time and has multiple access.

there may be more than one person logged in to the database at any one
time,

what I want to happen is for access to be able to automatically send a
report each night at 6pm.

can someone help with a macro that could do this?

The To box should be fixed and I wanted to predefine what the message
should say etc.

Can someone please help with this?

Many thanks in advance,

Stuart

 

[Jae]

I'm not good at Access myself. So, if some MVPs could answer your question,
disregard this reply. If not, try my suggestion. I never tried it myself, but
theoretically, it should work.

1. Try the below site. It's a 5 min. tutorial which teaches you how to run a
macro on certain time.
http://www.datapigtechnologies.com/flashfiles/schedulemacro.html

2. Once you master the art of running macro on time, create another FE for
your database.

3. Create Autoexec for that FE. The macro should be "send object." (Since
you said "to box is fixed," I'm assuming you are sending it to just one
person. If you have to send it to multiple ppl, you'd probably have to write
a code w/ loop).

4. Have that FE run on time.

Again, I'm not sure that would work. But, theoretically it should. Good luck
and let me know how it went.

 

[Stuart]

This is not really what I'm looking for.

I dont want an email sent each time I load the database.

The database will be open all the time. I want it to automatically
email based on the system time. I only want one report sent out to
three people each night.

Can one of the MVP's help with this?

Thanks

 

[Jae]

Did you finish watching the tutorial?

This is not really what I'm looking for.

I dont want an email sent each time I load the database.

The database will be open all the time. I want it to automatically
email based on the system time. I only want one report sent out to
three people each night.

Can one of the MVP's help with this?

Thanks