Try this...
#Define DWORD_DOCUMENT sys(5)+ curdir()+ 'ToolsCreateLabels1.doc'
.Application.MailingLabel.CreateNewDocument("5160","",DWORD_DOCUMENT, wdPrinterManualFeed)
I had a similar problem, Office 97 and Office 2000 both want an entire path with the file name...
Hope this helps.
>>It sounds like the problem is that you're opening the datasource rather than the main document in the first place. You want to execute the MailMerge.Execute method on the main document, not on the data source.
>>
>>Tamar
>
>Thanks, but when I run the ole code on my machine it runs fine, it is when I
>run on another machine in the office that I get a OLE Error. For some reason
>my machine can run the code below but not on another machine.
>
>.Application.MailingLabel.CreateNewDocument("5160","","ToolsCreateLabels1", wdPrinterManualFeed)
>
>Word is using the AutoText Feature to run the label merge on my machine but on another machine they do not have the same Word Template. I have even tried to adding a document in word with my 'Normal.dot' template in the ADD Method.
>Is there a work around? Is this readable?
Thanks,
Stacy
Black Mountain Software, Inc.