MailMergeMappedDataField Object (Publisher)
Contribute to this content
Use GitHub to suggest and submit changes.
Last modified: July 28, 2015
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 Microsoft 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.
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