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

[Guest]

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?

 

[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?

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.