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.
| Author |
Topic |
|
pssheba
Yak Posting Veteran
95 Posts |
 Posted - 2008-02-21 : 03:02:41
|
| sql 2005 table ?Hi everyone,I need to assemble information from my outlook account into a database table. Is it possible to insert "title" of a set of mails recieved into a table ? sender's name ? recipient's name? body? etc...thanks |
|
|
s_narayanan
Starting Member
3 Posts |
Posted - 2008-02-21 : 11:55:51
|
| Yes. It is possible. Here are some of the ways.1. You can use the Outlook COM API. I wouldn't recommend this because SQL Server will be running in a different machine and will not have access to your local outlook not unless you configure Outlook on the SQL Server itself and you will even run into security issues.2. If you are not particular about Outlook and your email server is Exchange you can consider WebDAV.I hope this helps.ThanksNarayanan |
 |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-02-21 : 12:17:22
|
| Depending on your requirements you could write a macro in outlook to create an excel spreadsheet for you and then you can upload the data into SQL server rather easily. |
|
|
|
|
|
|
is it possible to extract mails from outlook into