View Single Post
  #1  
Old July 11th 07, 02:02 AM posted to microsoft.public.outlook.program_vba
PJFry
external usenet poster
 
Posts: 14
Default Collect Form Data using OL2003

I have a survey form that I send out on a monthly basis. The recipient opens
the form, answers the questions in a combo box and sends the form back to me.
I would like to have the results automatically exported to a text file. For
example:

Question one is cmbSurQ1. The user chooses 'Outstanding'. The code would
look in the survey inbox, read 'Outstanding' from cmbSurQ1 and append that to
a text file. There are eight questions and eight text files. (Each of the
questions belongs to a different group in the company). The code would
perform the same action on all of the questions in all of the messages.

I would like the text file to contain the recipient’s e-mail address, the
message subject, a note indicating which question and the result.

Our current process is to manually tally these items. This should speed
things up dramatically.

Please let me know what questions you have.

I code pretty regularly in Access, so I am familiar with VBA, just not the
Outlook objects.

Thanks!
PJ

Ads