View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Ed[_31_] Ed[_31_] is offline
external usenet poster
 
Posts: 34
Default MailMerge Label printing from Excel

Once again, thanks Nick. I made the "dot" change, although it the
function clearly was
able to tell one application from another, as it did create the wanted
Word file from
the Excel file. However, some other fiddling with where things were
done got me
to the point where Word is now closing. However, the Kill of the
temporary
Excel file still doesn't work.

I have to divert to a more pressing project right now, but will get
back to this in
a week or so. I am so close it hurts to set it aside!

Ed


"NickHK" wrote in message
...
You still have :
With ActiveDocument.MailMerge

rather than
With .ActiveDocument.MailMerge
Note the addition of the ".", so this object is part of the wdApp
hierarchy.

Also, is "ChangeFileOpenDirectory" from wdApp ?
Should it be ".ChangeFileOpenDirectory" ?
etc

NickHK