View Single Post
  #2  
Old July 26th 08, 04:34 PM posted to microsoft.public.outlook.program_vba
Norman Yuan
external usenet poster
 
Posts: 14
Default 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


Ads