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

S

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
 
Top