Display the information in a list of mails : Email « Outlook « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
VBA / Excel / Access / Word » Outlook » Email 
Display the information in a list of mails
 
Sub Application_NewMailEx(ByVal EntryIDCollection As String)
    Dim myMailItem As Object
    Dim intMsgIDStart As Integer, intMsgIDEnd As Integer
    Dim intCutPoint As String, strMailItemID As String

    intMsgIDStart = 1
    intCutPoint = Len(EntryIDCollection)

    intMsgIDEnd = InStr(intMsgIDStart, EntryIDCollection, ",")

    Do While intMsgIDEnd <> 0
        strMailItemID = Strings.Mid(EntryIDCollection, intMsgIDStart, _
            (intMsgIDEnd - intMsgIDStart))
        Set myMailItem = Application.Session.GetItemFromID(strMailItemID)
        Debug.Print myMailItem.Subject
        intMsgIDStart = intMsgIDEnd + 1
        intMsgIDEnd = InStr(intMsgIDStart, EntryIDCollection, ",")
    Loop

End Sub

 
Related examples in the same category
1.Send email for all records in an Access table
2.Send email by Using POP3
3.Searching for Items
4.Adds an addressee, a subject, and body text; applies the HTML format; sets the importance to high; and sends the message:
5.Sending a Message
6.Send a table through email
7.Using the CreateItem Method to Create Default Items
8.Send out an email by using the DoCmd.SendObject
java2s.com  |  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.