Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Can we read emails from MS outlook Inbox?

Author  Topic 

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2008-04-25 : 11:38:02
Not sure if this is possible, I have a requirement, when email comes into our MS outlook Inbox, we need to identify the email based on the From email address and read the data which is in the body of the email. I do'nt know if we can do something like that using SQL 2005, any ideas?? Thanks!!

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-04-25 : 14:03:14
well first you have to ask yourself if you really, really, really, REALLY need to do this from sql server.
it's not what it's meant for.

however you could create a clr sproc that would do this.
of course you have to distinguish between and outlook inbox (a file on client computer) and an exchange store on the server.
you can connect to the exchange with linked server if i'm not mistaken... never tried it though.
reading from the client outlook file is a different story though...


_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page
   

- Advertisement -