Share via

Filters Property [Publisher 2003 VBA Language Reference]

  • Article

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

expression.Filters

expression Required. An expression that returns one of the objects in the Applies To list.

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

Applies to | MailMergeDataSource Object