Edit

Share via

MailMergeDataSource.Filters property (Publisher)

  • Article

Returns a MailMergeFilters object that represents filters applied to the mail merge or catalog merge data source.

Syntax

expression.Filters

expression A variable that represents a MailMergeDataSource object.

Return value

MailMergeFilters

Example

This example adds a new filter that removes all records with a blank Region field and then applies the filter to the active publication. This example assumes that a mail merge data source is attached to the active publication.

Sub FilterDataSource() 
 With ActiveDocument.MailMerge.DataSource 
 .Filters.Add Column:="Region", _ 
 Comparison:=msoFilterComparisonIsBlank, _ 
 Conjunction:=msoFilterConjunctionAnd 
 .ApplyFilter 
 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.