Email back a survey form

[Markus]

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

 

[Jezebel]

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.

 

[Jeff C]

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.

 

[Jezebel]

Only if the recipients are running Outlook.

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.

 

[Jeff C]

True Jezebel, I shouldn't assume

 

[Markus]

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

 

[Jezebel]

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.

 

[Markus]

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