Forms in word submitted via email

[Timg]

Hi everyone, I had a question regarding sending a form
from word. Here is what I am trying to do. I've created
a form. This form will reside on a network drive and a
shortcut icon will be created on the customers' desktop.
Once the customer double clicks on the icon, the form
will be brought up and can be filled out by the user.
Then the user will click on submit button to send the
contents of their form to a specified (central) email
address. Oh yeah, the customers have email but do not
have any browser capabilies, only email.

Does anyone know if this can be done?

 

[Peter Hewett]

Hi Timg

You should be able to do what you want. I'm not sure what you mean by a Word "form".
People use it ambiguously in this news group to mean one of three or four different
things!

Do you mean:
1. A straightforward Word template
2. A Word Template that contains FormFields (inserted using the Forms toolbar) [a
protected mode form]
3. A Word Template that contains ActiveX controls (inserted using the Control Toolbox
toolbar)
4. A UserForm created from within the VBA IDE (editor)

Depending upon the complexity of your "Form" one of the above methods should be reasonably
straightforward.

The email may be tricky, it depends on whether your client(s) use Outlook or not. If they
use Outlook (not Outlook express) check out the following link:

How to control Outlook from Word
http://word.mvps.org/FAQs/InterDev/ControlOLFromWord.htm

If they use something other than Outlook you'll probably have to use the CDONTS (Microsoft
CDO for NTS 1.n Library) library. You get access to this library by including it as a
project reference from the VBA IDE.

HTH + Cheers - Peter