Button on form needed to run mail merge from query

[nic79uk]

Hi,

I was wondering if anyone could help.

I am creating an access database which stores information about customers and their orders. I have set up a mail merge linked to a query which produces an invoice letter for new orders which I put on the database. This works fine however I would like to simplify the process for the other users that will begin using the database.

I would like a button on the order form (frmOrder) I have which will automatically produce an invoice in word using my word document (BWF-Invoice) which fills in the fields from a query (qryInvoice).

I have tried copying and pasting loads of code and inserting my details but as I am only beginning to use access and have not really used any VBA yet I am finding it really difficult. Particularly as I don't understand all the techie lingo. I would be so grateful for any help.

I've seen in some posts that another way to do this is by creating a report but as I have lots of merge fields the formatting is difficult.

Please help!!

[alansidman]

Thought this may be beneficial

http://www.datapigtechnologies.com/f...mailmerge.html