baronmatthews
IS-IT--Management
OK, as it stands right now, I have an Access database that uses some ODBC connections to connect to an Oracle DB we have. It then runs a query to find specific information and, if found, emails that file to a specific user. It is in the task scheduler to run every couple of hours. What I want to figure out how to do is this: I want to create a script that I can have on the server itself, no need for Access to come up and run from the remote location. From this script, I want to have the SQL query written into it that then gets the needed info from our Oracle DB and emails it to the user. I'd perfer the email to be sent directly over the stmp or any other process instead of needing to pull of Outlook. I'd like the data to be in the subject of the email, rather than an attachment like Access does it. Anyone that could point me in the right direction would be greatly appericated.