View Single Post
 
Old 07-16-2014, 11:42 AM
niton niton is offline Windows 7 64bit Office 2010 64bit
Competent Performer
 
Join Date: Jul 2012
Posts: 102
niton is on a distinguished road
Default

Object required. Here is sample code.

Code:
 
Private Sub Application_Quit()
    Dim olItems As Outlook.Items, olItem As Object, i As Integer
 
    Dim olInbox As Outlook.MAPIFolder
 
    Set olInbox = Application.GetNamespace("MAPI").GetDefaultFolder(olFolderInbox)
 
    Set olItems = olInbox.Items  ' <----
 
    For Each olItem In olItems
        i = i + 1
    Next
 
    Debug.Print " Number of items in Inbox: " & i
    MsgBox " Number of items in Inbox: " & i
End Sub
Reply With Quote