Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Course Of The Month
7 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Save Messages (called tickets by the compagny) to a SQL Server Database .
Posted on 2016-09-19
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 .
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 .
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
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.
Link the Outlook Folder(s) to your table and check "Auto Save" option. This will save sent items automatically to DB.
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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL).
Depending on business requirements, a single Stored Procedure can return differe…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory.
NOTE: For Outlook 2016 and 2013 perform the exact same steps.
Open a new email: Click the New email button in Outlook.
Start typing the address: …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses
Course of the Month7 days, 13 hours left to enroll
728 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.