Search.GetTable method (Outlook)
Obtains a Table object that contains items filtered by the Filter parameter in a preceding Application.AdvancedSearch method call.
Syntax
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.
Remarks
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.
See also
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.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for