Email back a survey form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Markus - 27 Sep 2006 01:41 GMT

I have a Word form to collect survey info that will be emailed. Is ther a
way to simplify the return of the form as an attachment to a specific email
address? That is, is there a way to use VBA to allow the respondent to click
on a submit button on this form and have it automatically emailed back to me
at a specific address as an attachment?

Thanks for any ideas on this,
Mark

Reply to this Message

Jezebel - 27 Sep 2006 02:43 GMT

Yes, you can set up VBA code to email a document to a specific address. But
trying to circulate a document with functioning VBA code in it has awful
security implications. Unless this exercise is entirely within a local
network, don't even think about it.

>I have a Word form to collect survey info that will be emailed. Is ther a
> way to simplify the return of the form as an attachment to a specific
[quoted text clipped - 7 lines]
> Thanks for any ideas on this,
> Mark

Reply to this Message

Markus - 27 Sep 2006 15:34 GMT

Jezebel,

Thanks. Just so I understand, technically it can be done. However, when
the email is sent back to me with the attached .doc form file, it will
contain VBA code, and so my security on my network may intercept it and
prevent it from arriving. Is that correct?

Would there be a way to copy the form to another .doc file without the vba
code inside, e.g., maybe copy all objects in the form .doc file except the
submit button. Then attach that .doc file to an emal and send it back to a
specific email address all after user clicks on submit?

I am a beginner at this VBA coding. Of course, my interest is only in the
repsonses, not the form .doc file itself. When a form is completed, is there
a data file associated with those responses separate from the form?

If not, could I write out the responses to a comma separated value file and
attach that to an email and send it to a specific email address, all when the
submit button is clicked?

Thanks again for any ideas on this,
Mark

> Yes, you can set up VBA code to email a document to a specific address. But
> trying to circulate a document with functioning VBA code in it has awful
[quoted text clipped - 12 lines]
> > Thanks for any ideas on this,
> > Mark

Reply to this Message

Jezebel - 27 Sep 2006 22:07 GMT

It wasn't *your* network I was thinking about, but your users' -- Sending
people a Word document that contains VBA code will run foul of even the most
basic anti-virus setups: 1) a lot of corporate networks won't let such
attachments into their internal email systems, 2) Norton and similar will
reject it as risky, and 3) Word will refuse to run the code unless the user
has their security set to low.

You can save form responses as a CSV file by checking 'Save data only for
forms' before saving. No code needed.

> Jezebel,
>
[quoted text clipped - 42 lines]
>> > Thanks for any ideas on this,
>> > Mark

Reply to this Message

Markus - 28 Sep 2006 01:06 GMT

Jezebel,

Oh, I see. Sounds like a submit button with vba code of any kind may keep
the survey from being delivered. As I recall, macros in a Word doc will do
the same if security is high. That sure limits what you can do.

Guess I'll have to keep the form simple and without a submit button, and
give instructions on emailing it back as an attachment.

Thanks for the help.
Mark

> It wasn't *your* network I was thinking about, but your users' -- Sending
> people a Word document that contains VBA code will run foul of even the most
[quoted text clipped - 52 lines]
> >> > Thanks for any ideas on this,
> >> > Mark

Reply to this Message

Jeff C - 27 Sep 2006 09:52 GMT

Use and Outlook Form. I think there are examples at Outlookcode.com, a great
site. Explore the Outlook Forums for more info. An Outllok form will do
just what you want.

Signature

Jeff C
Live Well .. Be Happy In All You Do

> I have a Word form to collect survey info that will be emailed. Is ther a
> way to simplify the return of the form as an attachment to a specific email
[quoted text clipped - 4 lines]
> Thanks for any ideas on this,
> Mark

Reply to this Message

Jezebel - 27 Sep 2006 11:17 GMT

Only if the recipients are running Outlook.

> Use and Outlook Form. I think there are examples at Outlookcode.com, a
> great
[quoted text clipped - 13 lines]
>> Thanks for any ideas on this,
>> Mark

Reply to this Message

Jeff C - 27 Sep 2006 11:38 GMT

True Jezebel, I shouldn't assume

Signature

Jeff C
Live Well .. Be Happy In All You Do

> Only if the recipients are running Outlook.
>
[quoted text clipped - 15 lines]
> >> Thanks for any ideas on this,
> >> Mark

Reply to this Message