This topic has not yet been rated - Rate this topic

MailMergeDataFields Object (Publisher)

A collection of MailMergeDataField objects that represent the data fields in a mail merge or catalog merge data source.

You cannot add fields to the MailMergeDataFields collection. When a data field is added to a data source, the field is automatically included in the MailMergeDataFields collection.

Use the DataFields property to return the MailMergeDataFields collection.

The following example displays the field names in the data source attached to the active publication.

Sub ShowFieldNames() 
 Dim intCount As Integer 
 With ActiveDocument.MailMerge.DataSource.DataFields 
 For intCount = 1 To .Count 
 MsgBox .Item(intCount).Name 
 Next 
 End With 
End Sub

Use DataFields(index), where index is the data field name or the index number, to return a single MailMergeDataField object. The index number represents the position of the data field in the mail merge data source. This example retrieves the name of the first field and value of the first record of the FirstName field in the data source attached to the active publication.

Sub GetDataFromSource() 
 With ActiveDocument.MailMerge.DataSource.DataFields 
 MsgBox "First field name: " & .Item(1).Name & vbLf & _ 
 "Value of the first record of the FirstName field: " & _ 
 .Item("FirstName").Value 
 End With 
End Sub

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.