asked on

Outlook calendar custom right-click menu action

I have MS Access database with Appointments table.
I know how to create an appointment in Outlook Calendar based on record from that table.

What I want to achieve is to be able to right-click an appointment in Outlook Calendar and to select a context menu command which will open a form in MS Access database on the record, from which the appointment was originally created.

Any ideas are really highly appreciated.
Thanks a lot in advance!

David Lee

Hi, msacc97.

What version of Outlook are you using?

msacc97

ASKER

Outlook 2007

David Lee

Then this is doable. I can supply the Outlook commands and instructions. Do you know the Access commands necessary to open the form?

msacc97

ASKER

Yes, I'm pretty familiar with Access.
Thank you for your help!

ASKER CERTIFIED SOLUTION

David Lee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

msacc97

ASKER

BlueDevilFan,

Thank you so much!
I will check the solution tomorrow

David Lee

You're welcome.

msacc97

ASKER

BlueDevilFan,

How can I get parameters for the appointment selected (date and time, subject, category etc)?
So I can find an appropriate record in Access database

Thank you

SOLUTION

David Lee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

msacc97

ASKER

Application.ActiveExplorer.Selection(1)
Application.ActiveExplorer.Selection(1).Start
Application.ActiveExplorer.Selection(1).Categories ..etc
finally did the trick for me.

BlueDevilFan, thanks a lot for your help!

David Lee

You're welcome.