This documentation is archived and is not being maintained.

MailMergeDataSource.SetAllErrorFlags Method

Office 2007
Marks all records in a mail merge data source as containing invalid data in an address field.


expression.SetAllErrorFlags(Invalid, InvalidComment)

expression   A variable that represents a MailMergeDataSource object.


NameRequired/OptionalData TypeDescription
InvalidRequiredBooleanTrue marks all records in the data source of a mail merge as invalid.
InvalidCommentOptionalStringText describing the invalid setting.


You can individually mark records in a data source that contain invalid data in an address field using the InvalidAddress and InvalidComments properties.


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