Table.FindRow method (Outlook)
Finds the first row in the Table that meets the criteria specified in Filter.
expression A variable that represents a Table object.
|Filter||Required||String||Specifies the condition that a row in the Table has to meet.|
A Row object that represents the first row in the Table that meets the filter criteria. Returns Null (Nothing in Visual Basic) if no such row can be found, or the Table does not contain any rows.
FindRow always starts from the first row in the Table.
FindRow returns Null (Nothing in Visual Basic) if a property in Filter does not exist in the specified namespace. The property is considered a named property in the MAPI property set, PS_PUBLIC_STRINGS. FindRow does not return an error in this case.
FindRow returns an error if Filter is a blank string or an invalid restriction. In cases where FindRow does not find any row, the current row will not be repositioned to where it was before the call to FindRow.
To use content indexing search in a Table, use the Restrict method. FindRow returns an error if Filter contains content indexing keywords.
Support and feedback
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.