VBA To Mail Merge From Excel To Word

[jo15765]

How can I mail merge with VBA from Excel to Word? For example, the headers in Excel would be what mapped to the "fields" in Word.

I know how to manually do such, but I am sure there is a way to do such in VBA.

[macropod]

Other than running a mailmerge what, exactly, would such a macro do? If the mergefields don't already exist in the Word document, what 'mapping' do you envisage?