Click here to Skip to main content
15,868,141 members
Articles / Programming Languages / Visual Basic
Article

Accessing Remote Exchange Server To read/delete mails using WEBDAV

Rate me:
Please Sign up or sign in to vote.
4.05/5 (17 votes)
5 Dec 2004CPOL2 min read 408.9K   66   126
Accessing Remote Exchange Server To read/delete mails using WEBDAV

Overview

The article is about reading /deleting the mails, attachments from a remote exchange server, I faced this requirement when my client told me to automate the reading the undeliverable mails and deleting them after reading from his inbox without any intervention. And making an entry into the database about all these mails.

There are many ways of accessing the exchange server like outlook objects, CDO, MAPI, CODEX And Webdav. But webdav is only one which doesn’t requires any configurations as such. You have to just give the webaccess to the mail account from exchange server from which you want to read or delete mails.

References required for the project

VB.NET
Imports System.xml
Imports System.Xml.Xsl
Imports MSXML2  

The whole project will be dependent on the MSXML2 and its methods like

VB.NET
.open("PROPFIND", ConnectingURL, False, UserName, PWD)
.open("DELETE", strurl, False, UserName, PWD)
.open("GET", strattachmentUrl, False, UserName, PWD)
.open("X-MS-ENUMATTS", strUrl, False, UserName, PWD)
  • ConnectingURL:- Is the Path of your Exchange server
  • Example:- http://255.255.255.255/exchange/administrator/inbox
  • UserName:- Is the name of inbox owner
  • Pwd:- Is the password of the inbox owner.

And to implement this project you need to have sound knowledge of XML, as the methods return results as XML. So all the manipulations is done on XML only.

Declaring the variables

Please ensure that MSXML2 with version of 4.0,you can download it from MSDN.

VB.NET
  Dim oXmlHttp As New MSXML2.ServerXMLHTTP40
  Dim xmlDOMParams As New System.Xml.XmlDataDocument
  Dim xmlDOMParamsAttachement As New MSXML2.DOMDocument40
  Dim xmlNdLstDonation, xmlNdLstDonation1, 
    xmlNdListHasAttach As XmlNodeList
  Dim PropstatNodes As System.Xml.XmlNodeList
  Dim HrefNodes As System.Xml.XmlNodeList
  Dim StatusNode As System.Xml.XmlNode
  Dim PropNode As System.Xml.XmlNode
With oXmlHttp
            '''Open and read all the mails of inbox'''
            '.open("PROPFIND",             
            .open("PROPFIND", ConnectingURL, False, UserName, PWD)
            .setRequestHeader("Depth", "1")
            .setRequestHeader("Content-type", "xml")
            .send()
            Debug.Write(.responseBody)
            Debug.Write(.responseXML)
            str = oXmlHttp.responseText
            ''Load the read mails into XML document'''
            xmlDOMParams.LoadXml(str)
            '''Get the list of text descriptions of all the mails'''
            xmlNdLstDonation = xmlDOMParams.GetElementsByTagName(
                "e:textdescription")
            '''Get the List of Subjects of all the mails'''
            'xmlNdLstDonation1 = xmlDOMParams.GetElementsByTagName("d:subject")
            xmlNdLstDonation1 = xmlDOMParams.GetElementsByTagName("a:href")

Relevance of the output

e:textdescription:- Gives you the body of Email

a:href:- Gives you the path of each mail as emails are stored as EML files in exchange server.

For example a email in your exchange server will be stored as :--

http://255.255.255.255/exchange/administrator/inbox/emailsubject.eml

d:subject:- Gives you the subject all the emails.

e:hasattachment:- Tells you whether the email contains attachment or not.

To delete the specific email

strurl = Pass the URL of mail which you want to delete.

http://255.255.255.255/exchange/administrator/inbox/emailsubject.eml

You can extract the names of mail from a:href tag and pass it to this method to delete more than one mail.

VB.NET
.open("DELETE", strurl, False, UserName, PWD)
.setRequestHeader("Depth", "infinity")
.send()

Get the list of attachments of a mail

VB.NET
Public Function GetAttachmentsListXML(ByVal strUrl As String) As String
        Const FOLDERITEM = "Inbox"
        Dim HttpWebRequest As MSXML2.XMLHTTP40
        Dim strPropReq As String
        Dim strOutPutFile As String
        Dim xmlAttachUrl As New MSXML2.DOMDocument40
        Dim xmlNdLstDonation2 As XmlNodeList
        Dim xmlNd As XmlNode
        Dim GetAttachmentsListXML1 As String
        Dim strURL1 As String
        HttpWebRequest = New MSXML2.XMLHTTP40
        With HttpWebRequest
            .open("X-MS-ENUMATTS", strUrl, False, UserName, PWD)
            .setRequestHeader("Depth", "1")
            .setRequestHeader("Content-type", "xml")
            .send()
            GetAttachmentsListXML1 = HttpWebRequest.responseText            
        End With
        HttpWebRequest = Nothing
    End Function

You can parse this GetAttachmentsListXML1 (XML) to get the path of attachment once you get the path of attachment you can pass that path to.

open("GET", strattachmentUrl, False,
UserName, PWD)

VB.NET
ReadAnAttatchment as string
Dim HttpWebRequest As MSXML2.XMLHTTP40
HttpWebRequest = New MSXML2.XMLHTTP40
HttpWebRequest.open("GET", strattachmentUrl, False, UserName, PWD)
HttpWebRequest.send()
ReadAnAttatchment = HttpWebRequest.responseText

Hope this code will help you people. Happy coding.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
GeneralEmail Tracking in VB.Net Pin
usha gupta12-Jan-09 19:42
usha gupta12-Jan-09 19:42 
GeneralRe: Email Tracking in VB.Net Pin
amit.arora13-Jan-09 2:46
amit.arora13-Jan-09 2:46 
GeneralRe: Email Tracking in VB.Net Pin
usha gupta13-Jan-09 19:02
usha gupta13-Jan-09 19:02 
GeneralRe: Email Tracking in VB.Net Pin
amit.arora14-Jan-09 2:27
amit.arora14-Jan-09 2:27 
GeneralRe: Email Tracking in VB.Net Pin
usha gupta14-Jan-09 18:19
usha gupta14-Jan-09 18:19 
AnswerRe: Email Tracking in VB.Net Pin
amit.arora15-Jan-09 2:34
amit.arora15-Jan-09 2:34 
GeneralNeed to autorefresh Mail every few minutes Pin
usha gupta10-Dec-08 23:05
usha gupta10-Dec-08 23:05 
GeneralRe: Need to autorefresh Mail every few minutes Pin
amit.arora14-Jan-09 2:34
amit.arora14-Jan-09 2:34 
GeneralEdit Email Body Pin
Nuno Neto4-Dec-08 23:13
Nuno Neto4-Dec-08 23:13 
GeneralRe: Edit Email Body Pin
Nuno Neto5-Dec-08 4:10
Nuno Neto5-Dec-08 4:10 
GeneralRe: Edit Email Body Pin
amit.arora14-Jan-09 2:28
amit.arora14-Jan-09 2:28 
GeneralRe: Edit Email Body Pin
morphias0@yahoo.com9-Apr-09 4:57
morphias0@yahoo.com9-Apr-09 4:57 
GeneralRe: Edit Email Body Pin
amit.arora9-Apr-09 8:35
amit.arora9-Apr-09 8:35 
GeneralRe: Edit Email Body Pin
for120630-Nov-09 5:32
for120630-Nov-09 5:32 
GeneralX-MS-ENUMATTS Pin
kobaid2-Nov-08 0:37
kobaid2-Nov-08 0:37 
GeneralRe: X-MS-ENUMATTS Pin
amit.arora21-Nov-08 4:41
amit.arora21-Nov-08 4:41 
QuestionX-MS-ENUMATTS http 403 Forbidden Pin
kobaid28-Oct-08 3:51
kobaid28-Oct-08 3:51 
AnswerRe: X-MS-ENUMATTS http 403 Forbidden Pin
amit.arora21-Nov-08 4:36
amit.arora21-Nov-08 4:36 
GeneralX-MS-ENUMATTS Pin
dafsoft1-Oct-08 2:30
dafsoft1-Oct-08 2:30 
GeneralRe: X-MS-ENUMATTS Pin
amit.arora21-Nov-08 4:37
amit.arora21-Nov-08 4:37 
General440 Login Timeout Pin
dafsoft27-Sep-08 12:11
dafsoft27-Sep-08 12:11 
GeneralRe: 440 Login Timeout Pin
Rajeev Gopinathan16-Oct-08 10:06
Rajeev Gopinathan16-Oct-08 10:06 
GeneralRe: 440 Login Timeout Pin
pollo200620-Nov-08 22:57
pollo200620-Nov-08 22:57 
GeneralRe: 440 Login Timeout Pin
amit.arora21-Nov-08 4:40
amit.arora21-Nov-08 4:40 
GeneralRe: 440 Login Timeout Pin
xeno7627-Nov-08 0:45
xeno7627-Nov-08 0:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.