OrderFields Object (Outlook)

Office 2013 and later

Contribute to this content

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

Represents the collection of OrderField objects in a view.

The OrderFields collection represents the Outlook item properties used to sort Outlook items displayed in the view. Use the Add method or the OrderFields collection to create a new order field for the following objects derived from the View object:

OrderField objects contained in an OrderFields collection are applied to Outlook items displayed in the view in the order in which the objects are contained in the collection.

The following Visual Basic for Applications (VBA) example iterates through the SortFields collection of the current TableView object, displaying the label and XML schema names of each OrderField object in the collection.

Private Sub DisplayTableViewSortFields() 
 Dim objTableView As TableView 
 Dim objOrderField As OrderField 
 Dim strOutput As String 
 If Application.ActiveExplorer.CurrentView.ViewType = _ 
 olTableView Then 
 ' Obtain a TableView object reference for the 
 ' current table view. 
 Set objTableView = _ 
 ' Iterate through the OrderFields collection for 
 ' the table view, obtaining the label and the 
 ' XML schema name for each field used to sort 
 ' the items in the view. 
 For Each objOrderField In objTableView.SortFields 
 With objOrderField 
 strOutput = strOutput & .ColumnFormat.Label & _ 
 " (" & .ViewXMLSchemaName & ")" & vbCrLf 
 End With 
 ' Display a dialog box containing the concatenated 
 ' sort field information. 
 MsgBox strOutput 
 End If 
End Sub