Collecting data via email

[Rob A]

Hi,
First and foremost I wnat to say thanks to all the users and MVP's that
contribute, the MS user group has been a great resource for me.

Access 2007, I would like to collect data from emails that I am recieving
from a form that is filled out on a web site and emailed to me. I have
looked at the collect datavia... from Acess however the data is from an html
form that is emailed out and completed and sent back. Is it possible without
having the form?


The form is on a third party site that I pay for but do not have FTP rights.
I get the emails with the data and that is fine. All the emails have all the
fields with an equal sign after them even if the are blank. Below is an
example of what the data looks like when it arrives.It does arrive in a
simple stationary.

A CMA has been requested. The prospect has been added to the cma campaign.

First Name = Joy
Last Name = Doe
Address = 123 Main St
City = Salt Lake City
State = UT
zip = 84118
email = (e-mail address removed)
bedroom = 4
bath = 2
property type = residential
year built = 1971
square footage = 1250
Garage = Yes
phone = 800-555-3214
phone2 =
mortgage = None
intent = Tax
General Comments =

 

[Graham R Seach]

Rob,

Data collection in Access 2007 depends on the original email being sent from
Access 2007/Outlook 2007 in either HTML or InfoPath format. That same email
must then be filled out and returned to you for processing.

You can't just take any old email and use the data collection feature to get
the data into the database. You can't write code to handle the intrinsic
data collection feature either (yet).

The only way to do it, is to write custom code to parse the email body, and
push the data into the database in code. See Tony Toews website for more
information about how to do that:
http://www.granite.ab.ca/access/email.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Rob A]

thanks

Rob,

Data collection in Access 2007 depends on the original email being sent
from Access 2007/Outlook 2007 in either HTML or InfoPath format. That same
email must then be filled out and returned to you for processing.

You can't just take any old email and use the data collection feature to
get the data into the database. You can't write code to handle the
intrinsic data collection feature either (yet).

The only way to do it, is to write custom code to parse the email body,
and push the data into the database in code. See Tony Toews website for
more information about how to do that:
http://www.granite.ab.ca/access/email.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia