Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm running Excel & Word 2000 on nt4, sp6
I'm trying to create a mailmerge file from Excel with data from the excel sheet. I get a 'variable not defined' compiler error on the 'wdMailingLabels' value of the '.ActiveDocument.MailMerge.MainDocumentType = ' line. I expect similar compile errors on other values. How can I find what I need to code these in order to execute the macro? Dim wordApp As Object Set wordApp = CreateObject("Word.Application") With wordApp .ActiveDocument.MailMerge.MainDocumentType = wdMailingLabels End With wordApp.Quit Set wordApp = Nothing thanks for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening word docs in excel | Excel Discussion (Misc queries) | |||
Opening a Word Template from within Excel | Excel Worksheet Functions | |||
Opening a Word Document in Excel | Excel Programming | |||
opening and writing into notepad | Excel Programming |