RUN SQL Server R2 Query based on Outlook Rule/Script

[pawanhsharma]

Hello All,

I guess there might be some way to trigger an SQL Query based on incoming Email. Here is what I want to do. I get several load delete request which I need to then process in SQL by running particular Query based on subject line of the mail. The subject line is predefined to determine which table, what environment and load or delete etc.
Ex: The subject line would be in the format
FullTableName#Environment#Server#RequestNumber#User#Load or DEL
Where the details are separated by "#"
This is fixed format and then I have to use the details and load or delete the data attached in the mail by running SQL Query. The attachment is always in Text format.
The problem is I have to keep track of mails all the time and some time it is on priority so it has to be done within time.
Is there any way I can save all the queries in SQl and trigger one based on subject line and process the attachment.
I guess that is very long and weird request but I believe there is some way to automate this as All the application are VBA compatible.
Thanks in advance.

 

[pawanhsharma]

Any help ?