export data in database to Microsoft Word document

[beemomo]

I have some invoice data on an MS Access form, and I wish to export the data into Microsoft Word document, can anyone help me please?

Many thanks..

[HarryTheB]

In my version of Word (2003) if you select Tools, Letters and Mailings, Mail Merge - the mail Merge Wizard (which appears on the right of the document) is very straight forward. It takes you through various steps including where you want to take you merge data from, in your case you need to point it to the table that contains the data being displayed on your form.

[beemomo]

In my version of Word (2003) if you select Tools, Letters and Mailings, Mail Merge - the mail Merge Wizard (which appears on the right of the document) is very straight forward. It takes you through various steps including where you want to take you merge data from, in your case you need to point it to the table that contains the data being displayed on your form.

Thanks for your reply n_____n, HarryTheB.

But I would like the user of the database to export the data from MS Access form, instead of opening the Word to do it. Actually, my case is:

1)
The user will need to create an invoice template in Word for each new record of invoice being inserted into the Access From , 'Invoice' (the data inserted will be store in a table named 'Invoice') once they clicked the buttton "Create Invoice" on the 'Invoice' form.

2)
After the user create the Invoice Template in Word, the invoice need to be converted into PDF format and to be saved into the format of "INV 0100 - P85037 " . Then, when the user click on "View Invoice" button on the same 'Invoice' form again, they can view the invoice being created for that particular record.

Does these make senses? Many Thanks...