Need Urgent Help

[Nizar]

Hi everyone,

I'm developing a small Access 2003 application for a purchase service that includes managing informations about Suppliers, Customers, Carriers, and Orders.
With the Orders issue, I'v created a form to enter all the informations about the order; customer, supplier, carrier, orderID, and a subform to enter the items with their quantity and unit price... I want to:

1- Add a botton in the form that opens a Word document; a Purchase Order, that includes all the information entered in the form.
2- Add a botton to send this document as an attachement from Access via Outlook.

I need a guide step by step to understand how it works in Access with examples if is it possible.

Any help is highly appreciated,

Best Regards,

 

[KeithG]

Does it have to be a MS Word document? I would just use a report but you could use the word document also. Look up mail merge, this is were you can create a word template and merge it with a query so you can populate the query info in the work document.

 

[Nizar]

Thanks KeithG,

Is there any good examples or tutorials for this subject?

Regards,

 

[The_Doc_Man]

My wife teaches this stuff. No, there are no GOOD books. Several fair-to-middlin' books exist. Go to a book store and find a couple. Thumb through them. See which one appeals to you. Each of us likes different styles of reference and tutorial. For me to name anything is wrong. My likes and yours will be very different.

 

[KeithG]

Its not to hard to do the MS word mail merge. Go to tools => office links => merge with word. Not sure if that is the exact wording.

 

[DCrake]

Simple Software Solutions

Hi

There is a step by step article on the MS Kb Article No 210271. This will answer all your questions.

 

[Nizar]

Thank you all for your advices
Appreciate it alot,
Best Regards,

 

[Nizar]

Hi Again,

Searching on this Forum and on net, I've succeeded to send my current record to word, but I still have a problem concerning the Order Details ( Items, Quantity, Price ...). I could not find how to send records on the subfom. I've searched but i didn't get relible results

Regards,
Thanks in advance