We help IT Professionals succeed at work.

Outlook calendar custom right-click menu action

msacc97
msacc97 asked
on
743 Views
Last Modified: 2012-08-14
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!
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2010

Commented:
Hi, msacc97.

What version of Outlook are you using?

Author

Commented:
Outlook 2007
CERTIFIED EXPERT
Top Expert 2010

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

Author

Commented:
Yes, I'm pretty familiar with Access.
Thank you for your help!
CERTIFIED EXPERT
Top Expert 2010
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
BlueDevilFan,

Thank you so much!
I will check the solution tomorrow
CERTIFIED EXPERT
Top Expert 2010

Commented:
You're welcome.

Author

Commented:
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
CERTIFIED EXPERT
Top Expert 2010
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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!
CERTIFIED EXPERT
Top Expert 2010

Commented:
You're welcome.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.