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 ...

+ Reply to Thread
Results 1 to 2 of 2

2007 Data Collection via e-mail

  1. Default 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?

  2. Default 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?

+ Reply to Thread