MailMergeMappedDataField Object

MailMergeMappedDataFields MailMergeMappedDataField

Represents a single mapped data field. The MailMergeMappedDataField object is a member of the MailMergeMappedDataFields collection.

A mapped data field is a field contained within Publisher that represents commonly used name or address information, such as First Name. If a data source contains a First Name field or a variation (such as First_Name, FirstName, First, or FName), the field in the data source will automatically map to the corresponding mapped data field. If a publication is to be merged with more than one data source, mapped data fields make it unnecessary to reenter the fields into the publication to agree with the field names in the database.

Using the MailMergeMappedDataField object

Use MappedDataFields(index) to return a MailMergeMappedDataField object. This example returns the data source field name for the pbFirstName mapped data field. This example assumes the current publication is a mail merge publication. A blank string value returned for the DataFieldName property indicates that the mapped data field is not mapped to a field in the data source.

Sub MappedFieldName()
    Dim strMappedDataField As String
    With ActiveDocument.MailMerge.DataSource
        strMappedDataField = .MappedDataFields(pbFirstName).DataFieldName
        If strMappedDataField <> "" Then
            MsgBox "The mapped data field 'FirstName' is mapped to " _
            & .MappedDataFields(pbFirstName).DataFieldName & "."
        Else
            MsgBox "The mapped data field 'FirstName' is not " & _
                "mapped to any of the data fields in your " & _
                "data source."
        End If
    End With
End Sub