Export information into a word document

[lovett10]

Thanks for any help in advanced. What i want to achieve is i have a form with combo boxes thats show..
Visit Number
Date of Work
Quote Number
Type Of Work
Enigneer Name
Customer Name

I have a template of a visit sheet, and if possible would like for when the user presses the button on the form it inputs the data from the comboboxes above into the word document in the correct places.

please let me know if and how this can be done.

P.s im using access 2010 and am on windows 7

 

[lovett10]

Ive searched the internet and this link http://www.techrepublic.com/blog/msoffice/how-do-i-fill-word-form-fields-with-access-data/164
best describes what im trying to achieve. Unfortunately ive tried following but the code gives me an error as in the first line...

Dim appWord As Word.Document

the Word.Document isnt recognised..

can anybody help?

 

[VNVfan]

It could be that you're missing the Microsoft Office Object Library. ([In Office 2003, sorry I haven't used Office 2010] go to Tools -> References in the VB Code window)

 

[lovett10]

It could be that you're missing the Microsoft Office Object Library. ([In Office 2003, sorry I haven't used Office 2010] go to Tools -> References in the VB Code window)

Hi thanks for the help, ive tried adding the library you have mentioned but it gave me an error. After searching the error i found that it isnt needed in 2010 so thats not the problem.

 

[lovett10]

Can anyone help?