Printing Word Doc from Access Database

[cdavis]

i have a database which tells me when documents need to be returned to the contractor by way of a report utilising a query.

i would like to have a button on a form or report that would ,when pressed, bring up the relevant letter from Word that i could use to send the documents back to the contractor.

is it possible to open Word when in Access by way of a button or something??

 

[bat17]

If you are just trying to open a standard document you could do this with a Hyperlink. If you want to open a document and also add data then you will need to use code.

Peter

 

[cdavis]

After I have run a query and brought up information in my Access Database I click a button(connected to a macro) and open a document in Word. what i now want to do is have a mail merge between Word and Access.

i want to transfer the information that is shown in Access to the Word letter.

does anybody know how to do this please???

 

[bat17]

I have not used mailmerge but if you check out Helen Feddema's site she has quite a bit on using Word and Access together.

HTH

Peter