Quick Question Regarding Outlook and Sql Server

[lewindha]

I work for a financial analyst and my boss complains of having to look through emails that he doesn't want everyday.

I thought if we made a database table of "wanted" email addresses, we could write a vbscript in Outlook(our mail client) that would query the Sql Server email table and see if that email is wanted, if not check for attachments, save attachments and delete email. All of this without him ever seeing the email.

I know I can check the email addresses and attachments with vbscript, but can I query the SQL Server with the Vbscript writer provided by Outlook?

Thanks for any help

 

[PHV]

Search your local drives for files named ado*.chm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244