Store email into sql server 2008 via Outlook 2007
Posted on 2009-02-23
I have written an application that stores files under the filestream datatype. It allows me to save any binary file onto the file system and to retrieve the file via the DB. I then also open the file in its respected application.
I did the following as a test to see whether database would save an entire email file:
I copied and saved an entire email message into a temp folder(with .msg extension), then stored it and successfully retrieved it via outlook again. So I know that this part actually works
The thing is that I want to enable the user to do this from outlook itself.
I want to allow the user to do the following:
-Click a custom button in outlook to load a form.
-This form will allow the user to connect to the database automatically and to choose a company-> Then choose an active project and task to which the email should belong.
-The email should then be saved as a .msg file in the database that refers to that specific task.
Is there any way that this could be done?
I would appreciate some samples, links and any other information.