We have a need to send a questionnaire via Outlook. The recipient would fill
in the form, return it to us via e-mail, and then we would like to insert the
data automatically into SQL Server (no typing on our part). We don't know
what sort of e-mail client the recipients might have (could be Outlook
Express, a web client, Thunderbird, anything). Ideally the form we send out
could be programmed to edit the responses. Any idea how this might be
accomplished?
Marvin P. Winterbottom - 23 Jul 2007 15:10 GMT
you need to spend a little money, but Adobe Acrobat Pro will make a pdf
document that they can fill in, and the data can be exported to excel. You
need acrobat reader to fill out the form, but everyone has that, don't they?
> We have a need to send a questionnaire via Outlook. The recipient would fill
> in the form, return it to us via e-mail, and then we would like to insert the
[quoted text clipped - 3 lines]
> could be programmed to edit the responses. Any idea how this might be
> accomplished?
Rick Solie - 23 Jul 2007 15:20 GMT
Thanks a lot--I'll give this a shot. Other responses are welcome, please.
> you need to spend a little money, but Adobe Acrobat Pro will make a pdf
> document that they can fill in, and the data can be exported to excel. You
[quoted text clipped - 7 lines]
> > could be programmed to edit the responses. Any idea how this might be
> > accomplished?
Sue Mosher [MVP-Outlook] - 23 Jul 2007 15:23 GMT
The combination of Access 2007 + Outlook 2007 provides good built-in functionality for such surveys.

Signature
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
> We have a need to send a questionnaire via Outlook. The recipient would fill
> in the form, return it to us via e-mail, and then we would like to insert the
[quoted text clipped - 3 lines]
> could be programmed to edit the responses. Any idea how this might be
> accomplished?
Rick Solie - 24 Jul 2007 15:26 GMT
Thanks. I've seen your books. One of my colleagues suggested this also, but
unfortunately our agency just upgraded to Office 2003 so Office 2007 won't be
available for awhile. (We try to stay current with yesterday's technology
here.)
> The combination of Access 2007 + Outlook 2007 provides good built-in functionality for such surveys.
> > We have a need to send a questionnaire via Outlook. The recipient would fill
[quoted text clipped - 4 lines]
> > could be programmed to edit the responses. Any idea how this might be
> > accomplished?