open a word document by clicking a buttton in access form

[beemomo]

Hi everyone and anyone, i have a form in Access named "Invoice" which store information for each particular invoice. After filling in the particular detail of an invoice, I want to click on a button "Create Invoice" to open a word document so that i can perform the mail merge function to select the Invoice Data from access and then convert it into PDF file and lastly save it as a Invoice file like INV0100 - P85037,

That's mean each Invoice record in Access form will have 1 Invoice file. After the invoice file is created, I want to click on "View Invoice" button to view the invoice being created just now. For example, for the Invoice record of the Invoice form with Invoice ID INV0100, if I click on "View Invoice" button, the INV0100 - P85037 will appear and so on.

I have google around to find the solutions, but I just can't get exactly what I want. Anyone has the solution please? Many Thanks.

[sierra7]

Hi
This is fairly ambitious!

You can open a Word document from Access but you would then have to program a macro in Word to do the Mail Merge. I will be interested to learn how to then save this as a PDF?

What's wrong with generating the Invoice in Access as a report (with all the text from the Mail merge document built in) and then printing it via PDF printer software to a file?

S7