2007 Data Collection via e-mail

S

sabrefox

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top