Appending Incoming Text E-mail with CSV to an Access Table

[DoctorV3774]

Below we have a typical output of data from an Outlook form into a
e-mail. We have a folder we setup for handling these incoming survey
done on an Outlook form. These e-mails come in as a regular Outloo
e-mail with no attachments just text. What is the code we need for a
event like Application_NewMail() that would automatically append th
text data contained in the e-mail (Data shown below) to a Table name
Tbl_Data into an Access database located atC:\SurveyOutlook.mdb

Note in Tbl_Data we have fields that correspond to each answer.
Field Answer1 in Access corresponds to A1 in Outlook e-mail
Field Answer2 in Access corresponds to a2 in Outlook e-mail
Do we use the Comma Separated values in the CSV Format or a1 goes t
Answer1 etc?

Sample of what each incoming e-mail's format looks like


Q1: Text: What do you think of this form?
A1: this is great!

Q2: Y/N: Would you use this form
A2: Yes

Q3: Agree Scale: How much do you agree or disagree
A3: Strongly Agree

Q4: 1-10: On a scale of 1-10 how satisfied are you with tihs form
A4: 5



CSV Format:
"this is great!","Yes","Strongly Agree","5" :

 

[Hollis D. Paul]

Note in Tbl_Data we have fields that correspond to each answer.
Field Answer1 in Access corresponds to A1 in Outlook e-mail
Field Answer2 in Access corresponds to a2 in Outlook e-mail
Do we use the Comma Separated values in the CSV Format or a1 goes to
Answer1 etc?

A better solution would be to have the form put the data into an Access
table at the server, then access the database directly to download the
new records.

Or, use CDO on the server to generate an email message with your custom
Outlook form and stuff the survey data into custom fields that are
labeled properly. You could then use an Outlook rule to move the
message data into a the local access database.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA