Save Messages (called tickets by the compagny) to a SQL Server Database .

I have to save email détails in our database using C# . I found that writing a macro in outlook or writing outlook plugins could do that for me , but with that approach we must do this for every Outlook contact .

So after searching I found that the best approach is to do that within the exchange server to watch over a specific mailbox for incoming emails .

How can I do that please ? I'm quite new to the field . Could please provide me some solution with implementations .

Zakarya ISSERAsked: 2016-09-19

Who is Participating?

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with Premium. Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 19

xtermieCommented: 2016-09-20

You can try an existing Outlook Add-on that does this www.geniusconnect.com

Link the Outlook Folder(s) to your table and check "Auto Save" option. This will save sent items automatically to DB.

LVL 28

Ryan McCauleyData and Analytics ManagerCommented: 2016-09-23

It depends on your version of Exchange - what was called an "Event Sink" in 2007 and earlier can now be handled by a "Transport Rule" or "Mail Flow".

Event Sinks allow you to register custom code on the Exchange server that will execute at specific points in message processing (when a message is received or sent, as one example):

https://support.microsoft.com/en-us/kb/317680 (Example of a sink when mail is sent)
https://support.microsoft.com/en-us/kb/324021 (Example of a sink when mail is received)

On newer versions of Exchange, this is accomplished via "Transport Rules" and "Mail Flows":

https://technet.microsoft.com/en-us/library/jj919238(v=exchg.150).aspx

Though a bit less flexible, they appear to be significantly easier to implement as they're native functionality (rather than custom code), though they appear to allow for custom code execution as well rather than just the pre-defined options. I've never used them before, but they appear to cover what you're looking for.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

LVL 28

Ryan McCauleyData and Analytics ManagerCommented: 2016-10-12

Both comments contributed with different approaches, but either woudl work.