Removing Incoming Email in MS Exchange, C# Example

The purpose of one of our projects was MS Exchange handler for processing incoming email.

The basic source of knowledge was this article "Developing Managed Event Sinks/Hooks for Exchange Server Store using C#" by Logu Krishnan, published to the address http://www.codeproject.com/csharp/CsManagedEventSinksHooks.asp, and also examples from Microsoft Exchange SDK.

We utilized Synchronous Events and created the handler, which fires on OnSyncSave event. The handler creates activity record in Microsoft CRM and then removes the message in the Exchange database before the commitment:

public void OnSyncSave(IExStoreEventInfo pEventInfo, string bstrURLItem, int IFlags) {try {if (IFlags == ((int)EVT_SINK_FLAGS.EVT_SYNC_COMMITTED + (int)EVT_SINK_FLAGS.EVT_IS_DELIVERED)) {

ProcessMessage(pEventInfo, bstrURLItem, IFlags);

}

catch (Exception ex) {

log.Debug(ex.Message + " " + ex.StackTrace);

}

finally {

LogManager.Shutdown();

}}

For Exchange handlers debugging - it is the extremely convenient to use system log4net in RollingLogFileAppender or RemoteAppender modes (for multiple instance of COM + objects). You can read more on this subject here http://logging.apache.org/log4net/To allow the handler incoming mail removal, it is necessary to give proper rights to the user, under which account the COM+ application runs the handler. These are rights on change of the information in user's boxes for whom it is registered (Windows 2003 Server: Active Directory Users and Computer -> Users -> Properties (for COM+ application account) -> Exchange Advanced -> Mailbox Rights). And now the code:

private void DeleteMessage(string bstrURLItem) {try {

ADODB.Connection oCn = new ADODB.Connection();

oCn.Provider = "exoledb.datasource";

oCn.Open(bstrURLItem, "", "", -1);

if(oCn.State == 1) {

log.Debug("Good Connection");

}

else {

log.Debug("Bad Connection");

}

ADODB.Record rec = new ADODB.Record();

rec.Open(bstrURLItem, oCn,

ADODB.ConnectModeEnum.adModeReadWrite,

ADODB.RecordCreateOptionsEnum.adFailIfNotExists,

ADODB.RecordOpenOptionsEnum.adOpenSource,

"", "");

rec.DeleteRecord(bstrURLItem, false);

rec.Close();

oCn.Close();

rec = null;

oCn = null;

}

catch (Exception ex) {

log.Debug(ex.Message + " " + ex.StackTrace);

}}

Happy customizing!Boris Makushkin

Boris Makushkin is Software Engineer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, San Diego, Los Angeles, Houston, Atlanta, New York, and Miami and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, VB/C#.Net, Crystal Reports and Microsoft CRM SDK developer.

MORE RESOURCES:

WorkForce Software to Host its First Annual Career Fair in Michigan - MarketWatch

JDA Software, i2 Scrap Merger - Wall Street Journal

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/1-0fd=Rurl=http://online.wsj.com/article/SB122840422009579487.html%3Fmod%3Dgooglenews_wsjcid=1277452365ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNHSETomoGaehueIOfuY2WwkeIYlXgJDA bSoftware/b, i2 Scrap Merger/abrfont size=-1font color=#6f6f6fWall Street Journalnbsp;-/font nobr4 hours ago/nobr/fontbrfont size=-1By KERRY E. GRACE I2 Technologies Inc. ended its planned $346 million sale to JDA bSoftware/b Group Inc., under which the two supply-chain bsoftware/b companies b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-1fd=Rurl=http://www.reuters.com/article/mergersNews/idUSBNG30148820081204cid=1277452365ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNF5Zr2avI71MnUOBp6u6shV89nrpwUPDATE 1-I2 Technologies ends merger deal with JDA bSoftware/b/a font size=-1 color=#6f6f6fnobrReuters/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-2fd=Rurl=http://www.bizjournals.com/dallas/stories/2008/12/01/daily43.htmlcid=1277452365ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNFBm8NzPmDWTL3cXIE93gUZdMNMSAi2 Technologies: No sale to JDA bSoftware/b/a font size=-1 color=#6f6f6fnobrBizjournals.com/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-3fd=Rurl=http://blogs.barrons.com/techtraderdaily/2008/12/04/i2-shrs-tumble-20-sale-to-jda-software-terminated/cid=1277452365ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNF7FJzU2bIrzL9yztR022RjyPzg7Ai2 Shrs Tumble 20%; Sale To JDA bSoftware/b Terminated/a font size=-1 color=#6f6f6fnobrBarron's Blogs/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/1-4fd=Rurl=http://newsticker.welt.de/index.php%3Fchannel%3Dfin%26module%3Dsmarthouse%26id%3D819028cid=1277452365ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNEqthRzIBjTcAzpOZkm_j7uTRV9fAnobrWELT ONLINE/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/1-5fd=Rurl=http://www.dallasnews.com/sharedcontent/dws/bus/stories/120508dnbusjdai2.2d693dad.htmlcid=1277452365ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNFPq-h6lua6L_owNXl8g_YhFr36HQnobrDallas Morning News/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1277452365hl=ennobrall 28 news articles/nobr/a/font/div/font/td/tr/table

Microsoft Warns Against Fake #39;Blue Edition#39; Software - CRN

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/2i-0fd=Rurl=http://www.efluxmedia.com/news_Microsoft_Starts_Legal_Action_Against_Blue_Edition_Pirates_30601.htmlcid=1277436405ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNEesPvWcN8IrCR5a0K0P6W36qL5qwimg src=http://news.google.com/news?imgefp=ZmsJa4zgGbkJimgurl=www.efluxmedia.com/content/news/news_30601.jpg width=80 height=60 alt= border=1brfont size=-2eFluxMedia/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/2-0fd=Rurl=http://www.crn.com/software/212201891cid=1277436405ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNFG5FMUqk_FitG2uxVOMINZwRAASgMicrosoft Warns Against Fake #39;Blue Edition#39; bSoftware/b/abrfont size=-1font color=#6f6f6fCRN,nbsp;NYnbsp;-/font nobr4 hours ago/nobr/fontbrfont size=-1Microsoft said it has been receiving complaints from unsuspecting customers having been stung after buying counterfeit Windows XP bsoftware/b and quot;illicit b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/2-1fd=Rurl=http://www.sfgate.com/cgi-bin/blogs/sfgate/detail%3Fblogid%3D19%26entry_id%3D33206cid=1277436405ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNGwhEI2iCyPJNFzWqWH2Rn0w8WWHAMicrosoft goes after bsoftware/b pirates/a font size=-1 color=#6f6f6fnobrSan Francisco Chronicle/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/2-2fd=Rurl=http://www.computerworld.com/action/article.do%3Fcommand%3DviewArticleBasic%26articleId%3D9122479%26intsrc%3Dnews_ts_headcid=1277436405ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNEmbQKB0-vaeahk7iRssX1WHTPbgQMicrosoft targets Blue Edition#39; bsoftware/b sales scams/a font size=-1 color=#6f6f6fnobrComputerworld/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/2-3fd=Rurl=http://www.techflash.com/microsoft/New_Microsoft_piracy_case_targets_bogus_Blue_Edition_software35512684.htmlcid=1277436405ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNH-oQYs2E5dWkSPuxmNRPN3XwkxyANew Microsoft piracy case targets bogus ‘Blue Edition’ bsoftware/b/a font size=-1 color=#6f6f6fnobrTechFlash/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/2-4fd=Rurl=http://seattlepi.nwsource.com/business/390552_msftpiracy04.htmlcid=1277436405ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNGwjOn-R5VyigBFbm4DX6wBkGRgxgnobrSeattle Post Intelligencer/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/2-5fd=Rurl=http://uk.sys-con.com/node/767835cid=1277436405ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNHbl-R2lfnEZzHuTlx0cdfbnVINWAnobrSYS-CON Media/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1277436405hl=ennobrall 35 news articles/nobr/a/font/div/font/td/tr/table

Everest Software Partners with Foxfire to Offer Integrated ... - MarketWatch

Apple yanks antivirus advice from its Web site - Computerworld

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/4i-0fd=Rurl=http://blogs.zdnet.com/security/%3Fp%3D2242cid=1276552788ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNGfmuHxX8tWFfYvSFjrtIMswzlntAimg src=http://news.google.com/news?imgefp=K5gxmlGfKB8Jimgurl=blogs.zdnet.com/security/images/macbook_monoculture.jpg width=80 height=53 alt= border=1brfont size=-2ZDNet/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/4-0fd=Rurl=http://computerworld.com/action/article.do%3Fcommand%3DviewArticleBasic%26articleId%3D9122359cid=1276552788ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNGcMgg9RjPNiM8wUOlmMH5RiJRepAApple yanks antivirus advice from its Web site/abrfont size=-1font color=#6f6f6fComputerworld,nbsp;MAnbsp;-/font nobr5 hours ago/nobr/fontbrfont size=-1quot;The Mac is designed with built-in technologies that provide protection against malicious bsoftware/b and security threats right out of the box,quot; he went on. b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-1fd=Rurl=http://www.informationweek.com/news/hardware/mac/showArticle.jhtml%3FarticleID%3D212201455%26subSection%3DNewscid=1276552788ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNFjmsduJ0VWuHXaBYdWIp6gVX56aAApple Recommends Antivirus bSoftware/b For Mac OS X/a font size=-1 color=#6f6f6fnobrInformationWeek/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-2fd=Rurl=http://news.cnet.com/8301-1009_3-10110852-83.htmlcid=1276552788ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNHSBQN4ODdJhFvrGchUCKN5x_8MeQApple suggests Mac users Install antivirus bsoftware/b/a font size=-1 color=#6f6f6fnobrCNET News/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-3fd=Rurl=http://blog.wired.com/business/2008/12/apple-on-the-ne.htmlcid=1276552788ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNGsmxHOCAnNEHwrvFwP8koSpGxHOQApple on the Need for Anti-Virus bSoftware/b: Now You Do, Now You Don#39;t/a font size=-1 color=#6f6f6fnobrWired News/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/4-4fd=Rurl=http://www.toptechnews.com/story.xhtml%3Fstory_id%3D0030003Q2LU6cid=1276552788ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNGFUsYK7Ws4uvn_VZ4naNILeLN4VwnobrCIO Today/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/4-5fd=Rurl=http://www.businessweek.com/magazine/content/08_50/b4112084938245.htm%3Fchan%3Dtechnology_tech%2Bmaven%2Bpage%2B-%2Bnew_this%2Bweek%27s%2Bcolumncid=1276552788ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNF1j3bCy9XGEOI1jS6KFGfIeCRA-gnobrBusinessWeek/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1276552788hl=ennobrall 253 news articles/nobr/a/font/div/font/td/tr/table

Software maker beats Wall Street estimates, wins praise for ... - MarketWatch

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/5-0fd=Rurl=http://www.marketwatch.com/news/story/stable-management-helps-synopsys-tough/story.aspx%3Fguid%3D%257B19A4FCAB-E07B-4D35-9B34-907314C9D7F2%257Dcid=1277546157ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNGwZwXZIDfst5thYZPVt5ukafX6UAbSoftware/b maker beats Wall Street estimates, wins praise for b.../b/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr2 hours ago/nobr/fontbrfont size=-1By Benjamin Pimentel, MarketWatch SAN FRANCSICO (MarketWatch) -- Shares of Synopsys Inc. were up more than 12% Thursday after the chip design bsoftware/b b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/5-1fd=Rurl=http://money.cnn.com/news/newsfeeds/articles/apwire/b3dd00bd9cc8669d439b6787e7adc0a8.htmcid=1277546157ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNGnYalKDqtvPcXd-IKAu5mdRcVp0wSynopsys shares jump on 4Q earnings/a font size=-1 color=#6f6f6fnobrCNNMoney.com/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/5-2fd=Rurl=http://www.marketwatch.com/news/story/Teen-retailers-zigzag-sales-Fortress/story.aspx%3Fguid%3D%257B603147C5-8804-4B48-BDAF-496D3DEAB5B6%257Dcid=1277546157ei=mzw4SZeNCYHI9ATY_eXuAQusg=AFQjCNFpF_AA7dIGfrVBFEZktCdAONf9HATeen retailers zigzag on sales, Fortress tumbles/a font size=-1 color=#6f6f6fnobrMarketWatch/nobr/font/fontbrfont class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1277546157hl=ennobrall 16 news articles/nobr/a/font/div/font/td/tr/table

Insight Distribution Software Announces Advanced Route Accounting ... - MarketWatch

FOX Systems Relies on Robust Neocase Software#39;s Solutions for ... - MarketWatch

AVG Named #39;Spicies Award#39; Winner for Top Anti-Virus Software for ... - MarketWatch

Bottomline Technologies Named to Software Magazine#39;s 26th Annual ... - MarketWatch

Software - Google News

RELATED ARTICLES

Microsoft Great Plains RW: Report Writer
Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). Great Plains Report Writer (RW) module allows for modification and creation of Great Plains reports to suit your business needs.

Computer Based Language Development and Spell-checking
Language development computer:Computer-based method for aiding language development seems like an interesting idea, the trick with this would be in getting the computer to take on part of the role of the human in the checking process.In all computer aided learning applications aimed at the very young, there is a danger that the computer may be seen as a replacement for a human instructor, however computer are notorious for not volunteering information or inability to deal with erratic behaviour.

Data Quality Best Practices for Salesforce.com
Executive SummaryAn effective plan for entering, cleaning and updating the data for your salesforce.com (SFDC) system is critical for achieving success with SFDC.

Microsoft Great Plains Security Setup - Overview For Consultant
Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Former product name was Great Plains Dynamics / eEnterprise.

Microsoft Great Plains e-Commerce - additional considerations for programmer
Microsoft Great Plains, designed back in 1990th as database transferable and graphical platform independent ERP application - Great Plains Dynamics/Dynamics C/S+/eEnterprise. For eCommerce developer the most important is to understand Great Plains tables structure and business processes in Sales Order Processing, Accounts Receivables, Inventory Control (inventory items allocation, backordering, etc), posting to Bank Reconciliation and General Ledger.

3 Reasons Why Medical Billing Software is Leading the Way
Since technology changes so quickly, it is hard to begin by saying "in the old days . .

Easy Guide to RAID Recovery
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive Disks. It is a method of combining several hard drives into one unit.

Windows Screensavers Explained
In this article you will find some background information about screensavers and their history. You will also learn how Windows screensavers differ from other programs and how you can use it to your own advantage.

The Truth: Netzero 3G
We've all seen the ads on TV for Netzero 3G. You know the ones, "speeds so fast you sworn it was broadband" Well if your using it, you may not think it really is.

Adware and Spyware Blockers
The most important things you can do for your computer right now is to install adware and spyware blockers. Everyone is aware of computer viruses and run an anti-virus program to guard your computer against them.

10 Things You Could be Using Photoshop For, But Probably Arent
Most people don't use Photoshop to its fullest capabilities. Here are just ten uses to which you could put this highly versatile software.

CRM 101: Customer Relationship Management for Beginners
Customer Relationship Management, abbreviated "CRM," is the term for a business strategy that is designed to improve customer service. CRM is also designed to increase customer satisfaction and gain new customers, thus increasing a business' revenue.

Groupware: What Works the Way Businesses Do?
GroupwareThe internet is full of 1.5 million to 7 million indexed pages of groupware packages available on the market today.

Putting Screensavers Under Control
No matter how much you enjoy your favorite screensavers, sometimes they can be rather annoying. Don't like them interrupting your presentations? Hate them disturbing you watching movies? Look no further.

Free Program Removes Spyware not Detected by Premium Security Scan
What is Spyware?Spyware monitors your surfing habits and sends the data off to some remote server in cyberland. Your computer can get infected with spyware easily by visiting a web page or installing a software program.

How to Make Own CMS
Every day millions of new web documents emerge on the Internet, and the amount of web management tools is growing simultaneously. These tools are usually referred to as Content Management Systems, CMS for short.

Linux vs Windows Operating Systems
With so many Microsoft Windows related viruses, errors, and other software problems, many average computer users are looking at alternative operating system platforms, such as Linux. It is important that users, frustrated with Windows, don't simply install a version of Llinux without knowing what they are in for.

Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example
Microsoft Great Plains fits to majority of horizontals and retail business is good fit as well. We'll consider the system, consisting from Microsoft Great Plains as Accounting, Inventory Pricing and Microsoft Retail Management System (RMS) Headquarters and Store Operations Manager.

SQL Administrator Skills Required to Support Microsoft Great Plains
Microsoft Great Plains is becoming more and more popular and we see new purchases among midsize and large corporations, where, in our opinion, Microsoft SQL Server DB administrator position is a must. If you are database administrator and you are part of the decision making team, purchasing Microsoft Business Solutions Great Plains for your corporation, we would like to set your expectation on the level of SQL knowledge, skills and experience needed to support Microsoft Great Plains in-house? Data querying.

Microsoft Great Plains Integration Manager - Working With Text File
Microsoft Business Solutions main middle market ERP application - Microsoft Great Plains has multiple integration options: MS SQL Scripting (stored procedures and views), ADO.Net programming, Microsoft SQL Server DTS packages.