Opening a Document from MS Access

[fearlessfreap24]

I have a database that is mail merged with a MS Word document. I have figured out how to create a button on the form to open Word. How do I create a button that will open the mail merged document?

 

[Rolliee]

Use your command button wizard and it will take you the process and write the code for you.

rollie@bwsys.net

 

[fearlessfreap24]

i have tried that, instead of opening an aplication, i selected the document. when the button is clicked i get an error message.

 

[nberryman]

Try the following

'****** Code Start ********
Private mobjWordApp As Word.Application

Private Sub Command1_Click()
Const conTEMPLATE_NAME = "\Templates\merge.dot"

Set mobjWordApp = New Word.Application
With mobjWordApp
.Visible = True
.WindowState = wdWindowStateMaximize
.Documents.Add Template:=(.Options.DefaultFilePath( _
wdUserTemplatesPath) _
& conTEMPLATE_NAME)
End With
End Sub
'****** Code End ********
Neil Berryman
IT Trainer
neil_berryman@btopenworld.com