Create Form that can be stored for Access

[Guest]

I just started a new job where part of the team prints out survey results,
hand tallies them and inputs the data to Excel. I am back in the dark ages.
I want to create a form that replaces the text surveys and gives me the
abilty to export that data into Access. I do quite a bit of coding in Access
and I am familiar with VB logic. I have some very limited coding in Outlook.
Here is what want to do:

Have code that reads the subject, then, based on the subject (say, Survey
001) combs through the inbox and exports the survey results to a text file.
(From here on I know what to do): Access picks up the file, loads it, etc.

We have eight questions. I have created a form with combo boxes for each
question. The boxes are labeled 'cmbSrvyQ1' to 'cmbSrvyQ8'. I want the code
to evaluate the message and export the e-mail address and question result for
each recipient to a text file, say SrvyQ1.txt.

Clear as mud? Any help is very welcome!

PJ

 

[Sue Mosher [MVP-Outlook]]

You didn't say what version of Office is involved. Office 2007 can do all this automatically, with no coding required.

In earlier versions, collecting data with a custom Outlook form requires that the form be published to the Organizational Forms library or to each sender and recipient's Personal Forms library. If you can do that, you might want to start with the generic survey form at http://www.outlookcode.com/d/forms/survey.htm

 

[Guest]

I am using Outlook 2003.

I do not appear to be able to publish the form listed below.

 

[Sue Mosher [MVP-Outlook]]

Then you won't be able to use Outlook forms for this task. You might consider using a Word document with form fields or even an intranet web page that mails you the results.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

 

[Guest]

I was able to solve the publishing issue. The form you suggested might do
the trick.

Thanks for the advice.
PJ