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 I 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.
I am using OL 2003
Thanks in advance!
PJ
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 I 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.
I am using OL 2003
Thanks in advance!
PJ