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!!