Change data source on word document

capdownlondon

Registered User.
Local time
Today, 01:22
Joined
Mar 18, 2007
Messages
52
I've opened a merged word document from a button on a form on my database, but is it possible to also have it set the data source on the word document to the current database when it opens it from the form button?
Im using access 2003 btw.
Thanks
 
Make a duplicate copy of the letter/document to merge.The Word document dictates which datasource it uses when you set it up using the MERGE Wizard: Select Recipients. Browse for the Database table/query that you want to link it to. When you open the copy of the letter/document that is linked to a Query, You can control the query content first then use your button to open the document in Word which will use the queried results as its source.

Hope that helps,
Goh
 

Users who are viewing this thread

Back
Top Bottom