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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Sharing Access MDB or Accdb with client using older or newer version of Office 1
automatic emailing using a macro within an access database based on system time 3
Menu Macro Not Executing - Need Help 1
Automatic Emails sent to my Contact Groups by Microsoft 1
Macro to select and delete levels of a document 2
Access Lock File .LACCDB / Now shows as a notepad file 0
Making a macro only work on certain files 2

Top