By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 900 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

export data in database to Microsoft Word document

P: 50
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..
Jan 29 '08 #1
Share this Question
Share on Google+
2 Replies


P: 3
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.
Jan 29 '08 #2

P: 50
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...
Jan 30 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.