anybody know how to make a form on word/excel that will email you back?

[bigronstud266]

Im looking to make a form that if I send it to someone in an email they can fill it out and click a "submit" button and it will email me back. Is this possible in Word or excel?
Thanks,
Ron

[jong2k4]

I've never heard of such a feature. The problem is that even if Word or Excel could do that with a Microsoft email client, the execution of that feature wouldn't work with any other client or with a webmail system... Another option: Excel and Access have support for "web fronts," which is to say that you can put an Excel or Access form on a website and users can enter information into it and then submit it.

[Cheryl]

It is possible using a macro (vba). Here's a link to two different ways to do it

http://word.mvps.org/FAQs/InterDev/SendMail.htm

if you do a google search on automatically email word document, or something to that effect, you should get some other ideas, but I think they'll all use vba.


Cheryl