Fields Used

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tywardreath - 02 Sep 2005 03:38 GMT

Hi

I have a shared database that is really large. Several people have created
mail merge documents only using a few of the database's fields. Is there a
way I can extract a list from Word of the mail merge fields used within a
document? If that is possible, is there a way to automate this process as
there are a LOT of mail merge files to go through (over 3,000).

Cheers, Tywardreath.

Reply to this Message

Greg Maxey - 02 Sep 2005 03:44 GMT

You might use a macro something like the following that will display a list
in the VBA immediate window:

Sub ListMergeFieldsInDoc()
Dim oFld As Field

For Each oFld In ActiveDocument.Fields
If oFld.Type = wdFieldMergeField Then
Debug.Print oFld.Code.Text
End If
Next
End Sub

Signature

Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

> Hi
>
[quoted text clipped - 6 lines]
>
> Cheers, Tywardreath.

Reply to this Message