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.
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.
Go to Heaven for the climate, Hell for the company.
~~Mark Twain
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?
Cheers
Paul Edstein
[Fmr MS MVP - Word]