Unless you use three different 'RunMerge' macros (e.g. RunMerge_Letter, RunMerge_Label, RunMerge_Envelope) you would need whatever code you use to choose the merge type to change these two lines:
Set wddoc = .Documents.Open(ThisWorkbook.Path & "\Mail Merge Main Document.docx")
and:
.MainDocumentType = wdFormLetters
The first line tells the macro which document to use (each merge requires a different document) and the second line tells the macro what kind of merge to do with that document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|