Launch a Word document from Access 2003

[Guest]

I'm converting an Access 2000 application to Access 2003. The application
uses the 'CreateOject' method to create a reference to MS Word and then opens
a document in Word prefilling a template with name and address information
stored in the Access database. This method works properly in Access 2000.
However, when I try to execute the same procedure in Access 2003 I receive
the message 'Requested object is not available'. Why am I getting this
message and how do I correct it?

 

[Albert D. Kallal]

Hum, hard to tell. It is possible that some security issue here...

I would try to make the word merge manually at first..and see if any new
dialog prompts pop up.

I have a working same that does a mail merge, and it does work for a2003.
You can give it a try..and at least you will it is "possible" that your new
setup can work. And, you might even enjoy my template word merge sample. You
can find it here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Guest]

Albert,
I've tried your method and modules within my application but can't seem to get
past the Word Merge Template dialog box referencing the query where my data
is located. I added the query name following the call to "MergeSingleWord"
but it's not picking up this query.

The form that I placed the button on to execute the procedure is a tabbed
form that gets its data from one of my primary tables. How do I get the
template to recognize the query as its data source?