Edit

Share via

MailMergeDataSource.DataFields property (Publisher)

  • Article

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

Syntax

expression.DataFields

expression A variable that represents a MailMergeDataSource object.

Return value

MailMergeDataFields

Example

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 & " " & _ 
 mdfLast.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.