How can I open a Word file through an Access switchboard?

D

Damo447

I have a mail merged letter created and I an looking to be able to open it
through an Access Switchboard menu. I am using Access 2003. Is there a way?
 
F

fredg

I have a mail merged letter created and I an looking to be able to open it
through an Access Switchboard menu. I am using Access 2003. Is there a way?
Click to expand...

Is this the Switchboard created by the built-in Switchboard Manager?

Create a new Module:
Public Sub FindDoc()
Application.FollowHyperlink "C:\PathToDocument\DocumentName.doc"
End Sub

Open the switchboard manager and edit the switchboard.
Add a new command
Run Code
In the Function Name box write:
FindDoc

Save the changes.

If this is your own made switchboard, add a command button.
Code the button's click event:

Application.FollowHyperlink "C:\PathToDocument\DocumentName.doc"

That's all you need do.
 
Top