Collect data by using e-mail messages

[Guest]

Hi!
I am using MS access 2007 and Outlook 2007 to collect data using e-mail
messages. I have tried this and is working.
The next step i want to do, is after receiving the email and the data is
stored automatically into the MS access-table (this works), to run a code
automatically or to send a new e-mail (with SendObject) to the user
automatically (this must be done automatically-not by user). Have any one
experience with Data Collection with MS-access/Outlook?

Thank you

 

[Pieter Wijnen]

I Would personally make a small vb or access application that on a timer:
1 Checks for new messages (a "timestamp" field)
2 Sends the automated message
3 updates the sent record's "timestamp"

Pieter