1) Write Outlook automation code that subscribes to the MAPIFolder.Items.ItemAdd event on the Sent Items folder and uses ADO code to push the data into your database.

2) Same thing, only on the Inbox.

See http://www.outlookcode.com/d/database.htm for references.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"NIMISH" wrote in message oups.com...
Hi All,

I am sure it is possible with Outlook / Access combination.

Step 1
When I send meeting request, I want that request to be added in Access
database
When I assign task to my team members, that task should be added in
Access database.

In both of above cases please assume that columns are well defined in
Database.

Step 2
When individual respond to meeting request, their response (Accept,
Reject, Tentative) should go directly into Access Table.
When team member progress task assigned to them, their progress should
go directly to Access table.

Is it possible?

Nimish