MailMergeDataSource.SetSortOrder method (Publisher)

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, and then on last name and first name in ascending order.

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

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.