Edit

Share via

MailMergeDataSource.ApplyFilter method (Publisher)

  • Article

Applies a filter to a mail merge data source to remove (or filter out) specified records containing (or not containing) specific data.

Syntax

expression.ApplyFilter

expression A variable that represents a MailMergeDataSource object.

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.