Create script to automatically send emails based on a query

  • Thread starter Thread starter Jonathan Brown
  • Start date Start date
J

Jonathan Brown

I've got a script that pulls all the records of employees who haven't logged
into the database in the last 90 days and then sends them a reminder email.
The script is linked to a button on my switchboard that I have to click.

Is there a way to create some sort of ODBC connection to my database and
then schedule a script using Windows Scheduler to open my database and run my
reminder script and then close the database?

This might not be really related to Access programming, it might be more
along the lines of windows scripting, but I wouldn't even know where to begin.
 
When you say make a procedure in Access are you talking about the procedure I
wrote and associated with the onclick event of my email reminder button?

Also, in the macro window, what action do I select to run my procedure? I
found an action titled OpenStoredProcedure. In the Procedure Name action
argument do I put something like, "public sub cmdEmailReminder_click()"? it
doesn't specify which form the procedure is located though. The little help
window says, "Select the stored procedure of the table to open. The list
shows all stored procedures in the current database". The list is empty. Am
I completely confused about what a "stored" procedure is?
 
Does this line "msaccess.exe <your>.mdb /X MacroName" go in the Run box or
the Start in box? What goes in the other box? Please help, I need to run
this macro automatically from our server to send reminder emails.
Thanks.
 
Back
Top