I want to make an automated form that I send out to customers confirming their
orders. I think there is a way to do this in Visual basic but my knowledge on
this is very limited. This is to be done in either word or excel whichever
is easier??

I want basically a form that has catagories like

Name:
Order number:
delivery date:

which I can fill in and then press go and it produces an e-mail in the form:

Hi ______

We have processed your order _____ for delivery on _____

bla bla bla.

and possibly a button that sends it straight to an e-mail too for me to send
off.

Can anyone please help me on this? A step by step guide would be very good
as I say my visual basic knowlegde is basic. I can probably design the form
but not put any of the code in that I want.

Cheers.