Export (0) Print
Expand All

Items.FindNext Method

Office 2007
After the Find method runs, this method finds and returns the next Outlook item in the specified collection.

Syntax

expression.FindNext

expression   A variable that represents an Items object.

Return Value
An Object value that represents the next Outlook item found in the collection.

Remarks

The search operation begins from the current position, which matches the expression previously set through the Find method.

The method returns an Outlook item object if the call succeeds; it returns Null (or Nothing in Visual Basic) if it fails.

Example

This Visual Basic for Applications (VBA) example uses the GetDefaultFolder method to return the Folder object that represents the default Calendar folder for the current user. It then uses the Find and FindNext methods to locate all the appointments that occur today and display them in a series of message boxes.

Visual Basic for Applications
Sub DemoFindNext()
    Dim myNameSpace As Outlook.NameSpace
    Dim tdystart As Date
    Dim tdyend As Date
    Dim myAppointments As Outlook.Items
    Dim currentAppointment As Outlook.AppointmentItem
    
    Set myNameSpace = Application.GetNamespace("MAPI")
    tdystart = VBA.Format(Now, "Short Date")
    tdyend = VBA.Format(Now + 1, "Short Date")
    Set myAppointments = myNameSpace.GetDefaultFolder(olFolderCalendar).Items
    Set currentAppointment = myAppointments.Find("[Start] >= """ & tdystart & """ and [Start] <= """ & tdyend & """")
    While TypeName(currentAppointment) <> "Nothing"
       MsgBox currentAppointment.Subject
       Set currentAppointment = myAppointments.FindNext
Wend
End Sub



Community Additions

ADD
Show:
© 2014 Microsoft