I want Outlook to talk to MS Access
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.
"Mir" Mir @discussions.microsoft.com wrote in message
...
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
|