Items object (Outlook)
Contains a collection of Outlook item objects in a folder.
Use the Items property to return the Items object of a Folder object.
Use Items (index), where index is the name or index number, to return a single Outlook item.
Note
The index for the Items collection starts at 1, and the items in the Items collection object are not guaranteed to be in any particular order.
The following Microsoft Visual Basic for Applications (VBA) example returns the first item in the Inbox with the Subject "Need your advice."
Sub GetItem()
Dim myNameSpace As Outlook.NameSpace
Dim myFolder As Outlook.Folder
Dim myItem As Object
Set myNameSpace = Application.GetNameSpace("MAPI")
Set myFolder = _
myNameSpace.GetDefaultFolder(olFolderInbox)
Set myItem = myFolder.Items("Need your advice")
myItem.Display
End sub
The following VBA example returns the first item in the Inbox. In Microsoft Office Outlook 2003 or later, the Items object returns the items in an Offline Folders file (.ost) in the reverse order.
Sub GetItem()
Dim myNameSpace As Outlook.NameSpace
Dim myFolder As Outlook.Folder
Dim myItem As Object
Set myNameSpace = Application.GetNameSpace("MAPI")
Set myFolder = _
myNameSpace.GetDefaultFolder(olFolderInbox)
Set myItem = myFolder.Items(1)
myItem.Display
End sub
Name |
---|
ItemAdd |
ItemChange |
ItemRemove |
Name |
---|
Add |
Find |
FindNext |
GetFirst |
GetLast |
GetNext |
GetPrevious |
Item |
Remove |
ResetColumns |
Restrict |
SetColumns |
Sort |
Items Object Members Outlook Object Model Reference
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.