Default Properties Displayed in a Table Object
A Table contains rows and columns, where rows represent items in a folder, and columns represent item properties. When you call Folder.GetTable, you obtain a Table object that has a small pre-defined set of columns corresponding to properties common to default items for that type of folder. Similarly, when you call Search.GetTable, you obtain a Table that has columns corresponding to properties common to default items for all folder types. The pre-defined sets of properties are explicit built-in properties. The small size of these sets allows the GetTable call to perform relatively efficiently.
The following tables list the set of properties returned by GetTable for each type of folder or a search folder. Properties are stored as a 1-based array in a Columns object.
Columns for all Folder Types
The following table shows the properties that are returned as default columns in a Table for any folder, including a search folder, Inbox, Sent Items, Deleted Items, Journal, and Notes:
| Column | Description |
|---|---|
| 1 | EntryID |
| 2 | Subject |
| 3 | CreationTime |
| 4 | LastModificationTime |
| 5 | MessageClass |
Columns for the Calendar Folder
The following table shows the properties that are returned as default columns in a Table for the Calendar folder:
| Column | Description |
|---|---|
| 1 | EntryID |
| 2 | Subject |
| 3 | CreationTime |
| 4 | LastModificationTime |
| 5 | MessageClass |
| 6 | Start |
| 7 | End |
| 8 | IsRecurring |
Columns for the Contacts Folder
The following table shows the properties that are returned as default columns in a Table for the Contacts folder:
| Column | Description |
|---|---|
| 1 | EntryID |
| 2 | Subject |
| 3 | CreationTime |
| 4 | LastModificationTime |
| 5 | MessageClass |
| 6 | FirstName |
| 7 | LastName |
| 8 | CompanyName |
Columns for the Task Folder
The following table shows the properties that are returned as default columns in a Table for the Task folder:
| Column | Description |
|---|---|
| 1 | EntryID |
| 2 | Subject |
| 3 | CreationTime |
| 4 | LastModificationTime |
| 5 | MessageClass |
| 6 | DueDate |
| 7 | PercentComplete |
| 8 | IsRecurring |
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.