visual basic help Excel/word form filling in

[laandmc]

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.

 

[Dave Peterson]

This sounds like a good opportunity to use excel as your database and MSWord's
mailmerge feature.

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

And if you notice problems with the formatting of data (like zipcodes)...

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg>.)