E-Mail turnaround document

[Rick Solie]

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]

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?

 

[Rick Solie]

Thanks a lot--I'll give this a shot. Other responses are welcome, please.

 

[Sue Mosher [MVP-Outlook]]

The combination of Access 2007 + Outlook 2007 provides good built-in functionality for such surveys.

 

[Rick Solie]

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.)