Search.GetTable Method (Outlook)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Obtains a Table object that contains items filtered by the Filter parameter in a preceding Application.AdvancedSearch method call.

expression .GetTable

expression A variable that represents a Search object.

Return Value

A Table that contains items that meet the criteria specified by the Filter parameter in a preceding Application.AdvancedSearch method call.

Unlike Folder.GetTable, Search.GetTable does not accept a Filter parameter. The filter for the Table is determined by Search.Filter. Since Search.Filter is a read-only property, the Filter parameter for the Application.AdvancedSearch method establishes the filter for the Table object returned by Search.GetTable.

The Filter parameter supplied to Application.AdvancedSearch must be a DASL query. The filter for AdvancedSearch will not accept a JET query. Do not prefix a DASL query for AdvancedSearch with “@SQL=”. If you add the “@SQL=” prefix, your query will raise an error. For more information on filters, see Filtering Items.

Search.GetTable returns a Table with the default column set for the folder type of the parent Folder. To modify the default column set, use the Add, Remove, or RemoveAll methods of the Columns collection object. For more information on default column sets, see Default Properties Displayed in a Table Object.

Unlike Folder.GetTable, you cannot use Table.Restrict to apply subsequent filters to a Table that is based on the Search object. Specify a new filter in Application.AdvancedSearch to re-apply a filter.


Other resources