VBA for Outlook meeting room booking

[Giggs1991]

Hi All,

I have an excel workbook with the list of meeting rooms mentioned in column A of Sheet1.

For example, I have "Room1" mentioned in cell A1 in sheet1.

If I select, a time ,let's say 1pm to 2pm, in cell B1, a new link or button should appear in C1. When I click this new button in C1, it should automatically connect to Outlook calendar and send a "New Appointment" to that meeting room mentioned in cell A1 (Room1 in this case).

Can someone help with this code please.

 

[Macropod]

Cross-posted at: http://www.vbaexpress.com/forum/showthread.php?64811-VBA-for-Outlook-meeting-room-booking
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[Giggs1991]

The cross post has been removed