Edit

Sorting Items in a Folder

  • Article

Items.Sort , Results.Sort, and Table.Sort allow you to sort Outlook items. This following table compares the few methods.

Items.Sort Results.Sort Table.Sort
Object of Sorting Items in an Items collection based on a folder Items in a Results collection based on a search Items in a Table object based on a folder or search folder
Applicable Properties as Sort Fields Explicit built-in properties with the exceptions listed in the Items.Sort topic Explicit built-in properties with the exceptions listed in the Results.Sort topic Explicit built-in properties and custom properties with the exception of binary and multi-valued properties
Referencing of Properties

  • By their explicit string names in the Outlook object model

  • Explicit built-in properties can only be referenced by their names in English and not any other localized language

  • By their explicit string names in the Outlook object model

  • Explicit built-in properties can only be referenced by their names in English and not any other localized language

  • By their explicit string names only; cannot reference properties by their namespaces

  • Explicit built-in properties can only be referenced by their names in English and not any other localized language

  • Custom properties can be referenced in English or a localized language
Format of Sort Fields

  • Enclosing square brackets ('['']') around explicit string names is optional

  • Property names are not case-sensitive

  • Enclosing square brackets ('['']') around explicit string names is optional

  • Property names are not case-sensitive

  • Enclosing square brackets ('['']') around explicit string names is optional

  • Property names are not case-sensitive
Error Conditions

  • Returns an error if property does not exist or property is not eligible for sorting.

  • If sort field is an empty string, no error is returned and the collection is not sorted.

  • Returns an error if property does not exist or property is not eligible for sorting.

  • If sort field is an empty string, no error is returned and the collection is not sorted.

  • Returns an error if property does not exist or property is not eligible for sorting.

  • Returns an error if sort field is an empty string

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.