Read and Reply to email using vbscript or macro basing on subject line

[Dev]

Hi all,
What i'm trying to do is:
1. When an email arrives with certain subject line
2. Read that email subject
For example subject line can be: Status 1 or Status 2
3. Depending the subject line, i need to query a sql server sproc and
send some data back to the email sender.

Any idea how to do this.

If anybody has sample code(either macro or
vbscript) that would be helpful.

I would try to incorporate ADO sub to grab data from sql server, if
anybody can provide code to read new mail and parse subject line and
how to respond by adding body text (with results from sql query) would
be very helpful

I'm running Outlook 2002.

Thanks

 

[Dev]

can anybody help me on this please...