Table.FindRow method (Outlook)

Finds the first row in the Table that meets the criteria specified in Filter.

Syntax

expression. FindRow( _Filter_ )

expression A variable that represents a Table object.

Parameters

Name Required/Optional Data type Description
Filter Required String Specifies the condition that a row in the Table has to meet.

Return value

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.

Remarks

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.

See also

Table Object

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.