I require a VBS script to be written do perform the following functions:
1.) Query an Access Database, extract information from the database, Automatically E-mail users based on the information it calculates from the extraction.
2.) Make the script editable so that we can change the static portions of the E-mail and change some of the variables from the data.
We have a server that users log into. The server then tracks the date and time that they connected to the database.
If a user does not connect in "x" days, then it will send an e-mail to the user and CC: the administrator with a warning that they have not connected in "x" days or more. (The email contents and the "X" value must be configurable)
The E-mail will be sent every day and will notify the client the total number of days they have not connected.
The server is hosted on a Windows box and the script cannot be run in PHP