Table of contents
TOC
Collapse the table of content
Expand the table of content

MailMergeDataSource.Filters Property (Publisher)

office 365 dev account|Last Updated: 8/24/2017
|
3 Contributors

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
© 2018 Microsoft