Export (0) Print
Expand All

MailMergeDataSource.SetAllIncludedFlags Method

Office 2007
True to include all data source records in a mail merge.



expression   A variable that represents a MailMergeDataSource object.


NameRequired/OptionalData TypeDescription
IncludedRequiredBooleanTrue to include all data source records in a mail merge. False to exclude all data source records from a mail merge.


You can set individual records in a data source to be included in or excluded from a mail merge using the Included property.


This example marks all records in the data source as containing an invalid address field, sets a comment as to why it is invalid, and excludes all records from the mail merge.

Visual Basic for Applications
Sub FlagAllRecords()
    With ActiveDocument.MailMerge.DataSource
        .SetAllErrorFlags Invalid:=True, InvalidComment:= _
            "All records in the data source have only 5-" _
            & "digit ZIP Codes.  Need 5+4 digit ZIP Codes."
        .SetAllIncludedFlags Included:=False
    End With
End Sub

Community Additions

© 2014 Microsoft