access to word please help!

[fiesta_rich]

hi im setting up a database for a friend of mine who is setting his own business up and i want to transfer data from Access to Word to print an invoice off but i dont want to do it using mail merge I want to do it using VBA as I have done the whole database using VBA can anyone help me??

any help will be brill



rich

[fiesta_rich]

any one please help??

[marianne]

do you know that access can make a report base on you tables or queries? why the need to transfer data from access to word for the purpose of printing invoice while you can do it without printing the invoice in the word file.

anyway, if you have created you invoice template in a report form of access, then you can use the code below to export it to word file.


docmd.OutputTo acOutputReport,"reportname",acformatrtf,"c:\",true