Populating Word template from web form

[EdwardMartinIII]

To start off, this is the ideal solution, but I'm allowed to be somewhat creative, if technology isn't willing to be friendly.

We're using Office 2007.

What my employer would like is:

1. For us to have a web form (in the local network) that collects a bunch of data bits, such as names, phone numbers, a few strings here and there.

2. Then, when the User hits the [Submit] button, those pieces of data go into specified fields on a Word document.

3. All other fields on that Word document are updated (it draws content from other "sub" docs).

4. The completed and updated and populated Word doc is then emailed to the User, ready to send to the Client.

I can do #1 pretty easily.
I don't know where to even begin for #2.
We already have templates that are populated by fields, which is part of #3.
I don't even know where to begin for #4.

Any hints or suggestions or even links would be awesome.

Thanks!


Edward

"Cut a hole in the door. Hang a flap. Criminy, why didn't I think of this earlier?!" -- inventor of the cat door

 

[EdwardMartinIII]

Would a macro have the capability to do all of this? Maybe if, instead of a web form, I used a data input form for Access, then maybe a macro could do the data collection, doc building, and emailing?

Edward

"Cut a hole in the door. Hang a flap. Criminy, why didn't I think of this earlier?!" -- inventor of the cat door