emailing form contents 1

[EdwardMartinIII]

Is there a way to build a form in one of Office's apps, and then have someone be able to fill out that form, click the [submit] (or whatever) button, and have the contents of the form emailed to someone else? Or even the form itself, filled out -- I don't care.

I want to be able to offer a simple interface (such as a form or a web form) to my co-workers, who fill out the interface, and then I use all the data from that form to build my own docs.

They need to be able to hit the form a couple times a day.

Is this something some part of Office can do?

I've done a little VB and VBA here and there, so if there's a way to repeatedly offer a form via that tool, I'm open to ideas.

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

 

[mintjulep]

Do you have InfoPath? That's exactly the type of thing it's intended to do.

If not, Word has the ability to create forms, with fields to store input. Completed Word "forms" could be emailed to you, and you could use VBA to extract the information. Or the form document could contain some VBA to extract the data and send only the data.

 

[EdwardMartinIII]

Oh, I appear to have InfoPath 2007. I've never used it.

I can use it to produce a form that my co-workers can access and use several times a day?


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]

Oooooh, just managed to make it happen in InfoPath. Thanks! Startime for you!

Edward

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