I want Outlook to talk to MS Access

[Mir]

Hi all,

I am trying to populate my Access Database table with data from Outlook. I
created this Access database tool that sends Reminders (follow up) in
Outlook. But now I want Outlook to talk to MS Access, so that when someone
clicks "Complete" on a reminder, it would access the Access database table
and flag it as complete.

Please help.

Thank you!
Mir

 

[Norman Yuan]

It is fairly easy to write a VBA macro to update the "Complete" field in a
database table, be it Access database or other. You use ADO to open a
connection to the target database, and then execute an SQL statement to
update data in database.

Almost all VB/VBA books have examples of using ADO for database access.