create an automatic merge to word

[Guest]

I have created a query to merge data to a word doc. I have attached a command button to open the file directly
Dim stAppName As String, stDB As String
stAppName = "C:\Program Files\Microsoft Office\Office11\Winword.exe"
stDB = "C:\Everest\CHPIndividual.doc"
Call Shell(stAppName & " " & stDB, 1)

 

[Byron]

I would strongly suggest that you visit Albert D.
Kallal's web site at:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.htm
l (watch out for the word wrap)

and check out what he has there. It is excellent for what
you are doing.

HTH

Byron

-----Original Message-----
I have created a query to merge data to a word doc. I

have attached a command button to open the file directly