Edit

Share via

MailMergeFilterCriterion.CompareTo property (Publisher)

  • Article

Returns or sets a String that represents the text to compare in the query filter criterion. Read/write.

Syntax

expression.CompareTo

expression A variable that represents a MailMergeFilterCriterion object.

Return value

String

Example

The following example changes an existing filter to remove from the mail merge all records that don't have a Region field equal to WA. This example assumes that a mail merge data source is attached to the active publication.

Sub SetQueryCriterion() 
 Dim intItem As Integer 
 With ActiveDocument.MailMerge.DataSource.Filters 
 For intItem = 1 To .Count 
 With .Item(intItem) 
 If .Column = "Region" Then 
 .Comparison = msoFilterComparisonNotEqual 
 .CompareTo = "WA" 
 If .Conjunction = "Or" Then .Conjunction = "And" 
 End If 
 End With 
 Next intItem 
 End With 
End Sub

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.