Share via

MailMergeDataSource.SetSortOrder Method

  • Article
Publisher Developer Reference

Sets the sort order for mail merge data.

Syntax

expression.SetSortOrder(SortField1, SortAscending1, SortField2, SortAscending2, SortField3, SortAscending3)

expression   A variable that represents a MailMergeDataSource object.

Parameters

Name Required/Optional Data Type Description
SortField1 Optional String The first field on which to sort the mail merge data. Default is an empty string.
SortAscending1 Optional Boolean True (default) to perform an ascending sort on SortField1; False to perform a descending sort.
SortField2 Optional String The second field on which to sort the mail merge data. Default is an empty string.
SortAscending2 Optional Boolean True (default) to perform an ascending sort on SortField2; False to perform a descending sort.
SortField3 Optional String The third field on which to sort the mail merge data. Default is an empty string.
SortAscending3 Optional Boolean True (default) to perform an ascending sort on SortField3; False to perform a descending sort.

Example

The following example sorts mail merge data first on postal code in descending order, then on last name and first name in ascending order.

Visual Basic for Applications 
  ActiveDocument.MailMerge.DataSource.SetSortOrder _
    SortField1:="ZIPCode", SortAscending1:=False, _
    SortField2:="LastName", SortField3:="FirstName"

See Also