Access 2007 send notifications automatically
Posted on 2012-09-13
i have several dbs that have the ability to open and send notifications through our outlook mail system to a prepopulated list of people as a result of pressing a cmd button to send the notifications. I would like to set these to be sent based on date and time, like every friday at 8am or somehting. Problem is, from what i have found, i can only send if the db is opened, but there are many times that they may not be opened on that specific day. How can i go about making these send automatically based on a date/time regardless of whether or not a user goes in and opens the db. I'd like to remove as much of the manual process as possible.