View Single Post
  #1  
Old July 10th 07, 06:54 AM posted to microsoft.public.outlook.program_forms
PJFry
external usenet poster
 
Posts: 14
Default Create Form that can be stored for Access

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
Ads