MailMergeFilterCriterion.Conjunction property (Publisher)

Returns or sets an MsoFilterConjunction constant that represents how a filter criterion relates to other filter criteria in the MailMergeFilters object. Read/write.

Syntax

expression.Conjunction

expression A variable that represents a MailMergeFilterCriterion object.

Return value

MsoFilterConjunction

Remarks

The Conjunction property value can be one of the MsoFilterConjunction constants declared in the Microsoft Office type library.

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, and then adds the filter to the following filter, so that the filter criteria must match both filters combined and not just one or the other.

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 
 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.