VBA to display and choose merge fields

macropod · #3 12-16-2020, 02:17 PM

Here's some code to get you started. As coded, the macro simply outputs the list of available fields to a message box.

Code:

Sub GetAllMergeFields()
Dim MMDF As MailMergeDataField, StrFlds As String
With ActiveDocument
  If .MailMerge.MainDocumentType = wdNotAMergeDocument Then Exit Sub
  For Each MMDF In .MailMerge.DataSource.DataFields
    StrFlds = StrFlds & vbCr & MMDF.Name
  Next
End With
MsgBox StrFlds
End Sub

To be able to select from the list, you'd need to output it to some kind of dropdown or listbox.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Displaying FORMTEXT fields when merge fields are empty or null	sfkHooper	Mail Merge	6	01-19-2016 04:24 PM
Pivot table - I cant display item labels when no fields in value area	differentdrummer	Excel	0	12-12-2013 05:13 PM
Can I have a dropdown list to choose from in mail merge?	lawlaw	Mail Merge	3	11-29-2012 04:47 PM
Conditional merge fields in mail merge	Aude	Mail Merge	1	01-06-2012 07:38 PM
How to display sort fields	keith1952	Word	1	10-31-2011 05:58 AM