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

Zakarya ISSER
Zakarya ISSER used Ask the Experts™
on
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 .
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011
Commented:
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.
Senior Data Architect
Commented:
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.
Ryan McCauleySenior Data Architect

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial