Edit

Default Properties Displayed in a Table Object

  • Article

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.