user forms

[Mike Cloghessy]

I posted this under the "web authoring" newsgroup and
wasn't sure if that was the proper one. So I will post it
here as well....

I have designed a survey form in Microsoft Word whereby
the recipient can fill out the form, click on the "submit"
button and the survey form will come back to me via
email. In testing I get a notification for email, but
nothing appears. What I would like is the survey form to
show up filled out by the recipient. That way I can print
them up for compilation.

Please help.

Mike Cloghessy

 

[dz]

When you say form, you mean a physical page in a Word
document and not a VBA Userform, right?

If so, have you tried sending the form as an attachment?

 

[dz]

If you did mean userform, then did you populate a document
with the information to actually send via email?

 

[Mike]

Thank you for your reply. I should have been more clear.
I designed the survey form in Microsoft Word using the
Visual Basics Editor. I have populated the form with the
necessary tools. I did include a "submit" button at the
end of the form. Under "properties" for this button I did
include my email address under the "Actions" box, which is
recommended. So when I test it I do get email
notification but the form is not there (just a blank
screen). I am told that the URL must be included.
However I do not know where to include it under the
properties nor do I know how to find the URL of the form.
The survey form is saved to my desktop.

Any suggestions would be greatly appreciated.

Mike C.

 

[dz]

Okay, I think I understand what's happening. I'm going to
reiterate as best I can and then please verify/correct the
information:

1. You load and show a userform in which the user fills
in information.
2. When the user is done, the submit button is clicked.
3. You then attempt to have the userform itself emailed?

If no. 3 is true, then it's not possible to my knowledge.
You need to populate SOMEthing with the text values from
each of the userform textboxes, comboboxes, etc. Can you
supply your code from the submit button?

 

[Mike]

My plan is to email this survey form as a web page, a pdf
and a Word document to cover all possibilities. So
initially the web page would be sent as an attachment.
But once opened and filled out, the plan again, was to
have them hit the "submit" button and the completed form
would come back to me via email, where I could print it
off. Does this make sense?

I guess I am not sure what you mean by "populate"
something with the text boxes. In any case here are the
property settings for the "submit" button...

Action - mailtowith my email address)
Caption - Send
Encoding - application/x-www-form-urlencoded (this is the
default setting)
Height - 22.5
HTML Name - blank
Method - Get
Width - 31.5

Again thank you for you help.

Mike

 

[Mike]

One other point....The sending and receiving of this
survey form would take place within a company network
(intra network). I don't know if this make a difference
or not.

Mike C.

 

[dz]

Wow. Hmmm, you are very industrious. I'm going to
suggest a couple of things, but I believe this is beyond
my expertise:

1. What I do in these kinds of situations is I create an
Outlook form. You can automate the Outlook form fill-in
from Word VBA. I create a protected document with
formfields, then the user fills it in and presses a button
and the Outlook form is automatically filled in and sent
to the appropriate addressee(s). This provides you
excellent tracking ability.

2. If Outlook forms are overkill, then maybe just a Word
protected document for the survey form that you could
attach to the email to be sent to you.

3. If 1 and 2 don't tickle your fancy, then I suggest you
create a brand new thread so that someone else who might
have experience with intranet webpage issues can answer
your question. I'm afraid that at this point people will
ignore your question from here out, so you need to re-
submit it. Make sure you put in every ounce of info. that
you provided in all of the threads here.

dz

 

[Guest]

Here is the code for the submit button in a different
form...

<p class=MsoNormal align=center style='text-
align:center'><span
style='font-family:Arial'><INPUT TYPE="SUBMIT"
ACTION="mailto:[email protected]" VALUE="Send"
<o></o></span></p>

Mike C.

 

[Mike]

How do I create an Outlook form? Reposting has not panned
out. The only suggestion is creating a ASP pages, which
is like building a new house when all you want is a new
door.

Mike C.

 

[dz]

It's close to impossible to explain how to create an
Outlook Form. Sue Mosher has written an amazing book that
is my "Bible" for these things. "Microsoft Outlook
Programming, Jumpstart for Administrators, Developers, and
Power Users."

She also has a great website:
http://www.outlookcode.com/messages.aspx?forumid=3

Outlook Forms can be quite involved, but once you get the
hang of it, it's a life-saver.

In the interim, or even as an alternative, if all of your
users have access to Word, I would suggest just creating a
macro to pull up a protected form that they can fill in
and then provide a send via email button to you. Again,
if you don't care about the format and just need the text,
you can also just populate the email message with the data
that you need and be done with it.

 

[Mike]

I believe this is what I want to do. How do I create a
macro? I have the form saved as a Word document with the
radio buttons, text boxes, etc. How do I provide a "send
via email button" and is this getting me into the same
problem as before? There are no guides for email in the
properties section. Or do I have to use VBA tools in the
word document.

Mike C.

 

[Mike]

Okay here is what I've done.

I have a Word document with radio buttons and text boxes
using Web controls. I have also included a "submit"
button. When I click on this button the Outlook mail
window pops up with my address listed but just a blank
screen below. How do I code the "submit" button so that
the form itself appears in the window below along with the
email menu? Or is this possible? Am I right back where I
started?

Mike