MailMergeDataSource.DataFields property (Publisher)

Returns a MailMergeDataFields collection that represents the fields in the specified data source.



expression A variable that represents a MailMergeDataSource object.

Return value



This example displays the value of the FirstName and LastName fields from the active record in the data source attached to the active publication.

Sub ShowNameForActiveRecord() 
 Dim mdfFirst As MailMergeDataField 
 Dim mdfLast As MailMergeDataField 
 With ActiveDocument.MailMerge.DataSource 
 Set mdfFirst = .DataFields.Item("FirstName") 
 Set mdfLast = .DataFields.Item("LastName") 
 MsgBox "The active record in the attached " & _ 
 vbLf & "data source is : " & _ 
 mdfFirst.Value & " " & _ 
 End With 
End Sub

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.