Retrieving mailmerge fields from s source document

[BazF]

I need some help please. I need to list out all mailmerge fields from a Word source document so I can run a mailmerge to retrieve data for checking our database.
I need some vba which will read through the sourcedocument and output all fields to a word document and including the mailmerge formatting.
Reason is the word Sourcedocument has over 2000 merge fields and doing it manually would take hours .

i,e In WORD,
click Mailings , Insert Merge Fields, then select each field.


Thanks

 

[macropod]

Your approach is entirely wrong - all you're doing is creating new mergefields, not generating anything like a report of the fields actually used in the document (or their formatting). For what you want, simply open the mailmerge main document and delete everything that isn't a mergefield.

Cheers
Paul Edstein
[MS MVP - Word]