Can I Email A Form?

[charles.kendricks]

I need to conduct an email survey. Is there an easy way to incorporate
an access form (or excel spreadsheed) that can be incorporated or
reincorporated into an Access database for tabulation? I would like to
mail out the survey, have the recipients be able to check a check-box
in a form (or spreadsheet), and reply back to me with their responses
to the survey. Then I would like to be able to incorporate their
responses into a database.

 

[Douglas J. Steele]

At present, there's no way to e-mail a form and get data the way you're
looking to do.

You could e-mail an Excel spreadsheet and then import it into Access. What
part(s) of that process do you need help with?

 

[Mike Labosh]

I need to conduct an email survey. Is there an easy way to incorporate

an access form (or excel spreadsheed) that can be incorporated or
reincorporated into an Access database for tabulation? I would like to
mail out the survey, have the recipients be able to check a check-box
in a form (or spreadsheet), and reply back to me with their responses
to the survey. Then I would like to be able to incorporate their
responses into a database.

Here are some possible solutions:

1. Use HTML / ASP / ASPX / JSP / Servlets.
2. Send a url in your email that points to an Access form inside a
database on your secure private intranet. Bizarrely enough, you can
drag-n-drop an Access form from your database to your desktop, and then send
it as an email attachment. This will not work on the public Internet.
3. Use Microsoft InfoPath, because that's what it's for.
4. Use a distributed design in C# or VB.NET with MTS / COM+ Enterprise
Services / .NET Remoting to present a remote web-based UI that saves the
information in a central database.

Please do not try to use Access, Excel, Word etc for this, because they are
not intended to do things like this.
--


Peace & happy computing,

Mike Labosh, MCSD MCT
Owner, vbSensei.Com

"Escriba coda ergo sum." -- vbSensei

 

[Arvin Meyer [MVP]]

There is also a third party tool that I've used successfully:

http://www.mapilab.com/products/#easy_survey

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access