2007 Data Collection via e-mail - ADO DAO RDO RDS
This is a discussion on 2007 Data Collection via e-mail - ADO DAO RDO RDS ; I was realy impressed at the cool new feature that allows updating tables in
Access via e-mail forms. However I wanted to send out e-mails automatically
instead of having to run the wizard everytime.
Automating this process requires entering a ...
-
2007 Data Collection via e-mail
I was realy impressed at the cool new feature that allows updating tables in
Access via e-mail forms. However I wanted to send out e-mails automatically
instead of having to run the wizard everytime.
Automating this process requires entering a record into the
MSysDataCollection table and creating the e-mail using VBA. Everything works
great, except for the final piece. Replying to the resultant email has no
effect on the database. When I click Manage Replies, I can see the new data
collection message; however, there is a note that states "The settings of
this e-mail message must be synchronized with Microsoft Office Outlook.
Click to sychronize now." After clicking it, the e-mail functions as
expected.
Does anyone have any idea what actually occurs when I click this, and how I
can perform the same action using VBA?
-
Re: 2007 Data Collection via e-mail
Did anyone find a solution to this problem? I'm currently trying to do the same thing w/ automating the ability to collect data via emails without having to use the wizard every time & still haven't been able to do so. Any one out there could send over some advice?