Please help me out here.
I am a complete newbie in VBA world.
It is very hard for me to explain everything in correct english because i use a Dutch version of Office 2003.
Config:
Windows xp sp2 Dutch
Office Professional 2003 Dutch
Problem:
I use the following sub to call a word document:
On Error GoTo Err_Knop3_Click
Dim oDoc As Object
Dim strBestand As String
strBestand = "c:\test.doc"
Set oDoc = CreateObject("Word.Application")
oDoc.Visible = True
oDoc.Documents.Open (strBestand)
oDoc.Activate
Exit_Knop3_Click:
Exit Sub
Word opens the right document, but the merge options are grayed out. In the original document it all works perfect, but opened from the access form, the document looses all mysql merge options.
I know there is an option to merge a query direct into word for a mailing to a printer. But i want to automate it.
What is the best solution to solve my problem?
Please help me out here, i'm starting to like access as it is, but the vba is a bit hard for me at the moment.