![]() |
|
#16
|
||||
|
||||
|
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] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
mail merge in excel to send pdf forms
|
heyullama | Excel | 7 | 12-01-2013 03:32 PM |
| Excel Mail merge | Joren | Word | 0 | 07-09-2013 07:38 AM |
mail merge with excel and words
|
don0712 | Mail Merge | 1 | 01-29-2013 06:53 PM |
Templates, pictures, Mail Merge and Excel
|
kckay | Word VBA | 1 | 05-17-2012 08:51 PM |
Mail Merge from Excel
|
Kieroncsmith | Mail Merge | 2 | 02-16-2012 10:35 PM |