Thanks Ron ... That definitely works a treat
Unfortunately it printed the document before the mailmerge took place
Have you any suggestions as to how I can force the mailmerge prior to
printing
Thanks again from the prompt and accurate response
This NG must be one of the best
"Ron de Bruin" wrote in message
...
Hi JRB
Try this example that print a Word file
Sub test()
Dim WD As Object
Set WD = CreateObject("Word.Application")
WD.Documents.Open ("C:\ron.doc")
WD.ActiveDocument.PrintOut Background:=False
WD.ActiveDocument.Close
WD.Quit
Set WD = Nothing
End Sub
--
Regards Ron de Bruin
http://www.rondebruin.nl
"JRB" wrote in message
...
Is it possible to open Word with a specific document from an excel
procedure
I have managed to open word using:
Application.ActivateMicrosoftApp xlMicrosoftWord
but can find no way to specify the document to load
I would like to run a mail merge, using Word, to create some mailing
labels,
print them and then return to Excel and closing the Word program
Any (and all) suggestions greatly appreciated
TIA