MailMergeMappedDataField object (Publisher)

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 automatically maps 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.

Remarks

Use MailMergeDataSource.MappedDataFields (index) to return a MailMergeMappedDataField object.

Example

This example returns the data source field name for the pbFirstName mapped data field. This example assumes that 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

Properties

• Application
• DataFieldName
• Index
• Name
• Parent
• Value

See also

• Publisher Object Model Reference

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.