|Outlook Developer Reference|
Version Added: Outlook 2007
expression A variable that represents a Table object.
|MaxRows||Required||Long||Specifies the maximum number of rows to return from the Table.|
A Variant value that is a two-dimensional array representing a set of row and column values from the Table. The array is zero-based; an array index (i, j) indexes into the i-th column and j-th row in the array. Columns in the array correspond to columns in the Table, and rows in the array correspond to rows in the Table. If
The GetArray method offers a conceptually simple means to get values from a Table by copying all or part of the data in the Table (based on the current row) to an array and indexing into the array.
GetArray always starts at the current row of the Table. It returns an array with MaxRows number of rows if there are at least
After obtaining the appropriate rows from the Table and before it returns, GetArray always repositions the current row to the next row in the Table, if there exists a next row.
GetArray(n) operates as if Table.GetNextRow is called n times.
The values in the columns map to columns in the Table, and are therefore determined by the format of the property name used for the column. For more information, see Factors Affecting Property Value Representation in the Table and View Classes.
The following code sample obtains a Table by filtering on all items in the Inbox that contain "Office" in the subject. It then uses the Table.GetArray method to copy the data from the Table to an array, and prints the property value of each item returned.
For more information on specifying property names in a filter by namespace reference, see Referencing Properties by Namespace.
|Visual Basic for Applications|