This documentation is archived and is not being maintained.

MailMergeDataSource.Filters Property

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

Visual Basic for Applications
Sub FilterDataSource()
    With ActiveDocument.MailMerge.DataSource
        .Filters.Add Column:="Region", _
            Comparison:=msoFilterComparisonIsBlank, _
            Conjunction:=msoFilterConjunctionAnd
        .ApplyFilter
    End With
End Sub



Show: