Wednesday 29 June 2011

Meeting Roomss... Lets book them - Outlook Meeting Room Finder

Hi today i would like to introduce to a very handy tool which me and my office personnel's are quite linking.
Recently i joined my new office and its quite beautiful, but i soon found big beautiful things have some problems which VBA can solve in many times. 

The issue is we have 20-30 meeting rooms in the office and they all can be booked via sending the appointment item to a certain patterned email address each unique for individual meeting room's.

To cut short the story this tool analyses all the meeting room's shared calender selected on the basis of the patterned email address assigned to each one of them. And it collate a list scanning those shared calenders illustrating the time periods between which the required time slot (duration input by user in mins) can be booked and in which meeting room the appointment can be booked.

This entire code is written in VBA within outlook. Give this handy tool a check and alter it to your requirements and make it work for you so that you are never late in you next appointment.

Also the code includes a feature for minimizing the user form in VBA.




Download:
Download Solution
Download solution


References:
Outlook Calender Scan: http://www.vbaexpress.com/kb/getarticle.php?kb_id=671
UserForm Minimize: http://www.vbaexpress.com/kb/getarticle.php?kb_id=165

4 comments:

Unknown said...

Hi, ran this utility on exchange 2010 (we have 10 room mailboxes, all are disabled). 7 of these work fine but 3 of them show the following message "calendar not shared". All are identical in the setup and have checked perms etc. Would you be able to provide any hints/pointers.......Thanks

Anonymous said...

Finding a good best venue for conference was not easy .I tried to find in conference venue finder and I'm sure that I can find the best venue that will satisfied me.

conference venue finder

Drew Watts said...

Wow!! Really found this booking style great. Our office is not too spacious so we have to hire meeting rooms in other place and for our meeting and conferences we always opt to corporate events NYC, which also have amazing conference halls and rooms.

jhon said...

The Bricklayers Arms at 22 Kingsgate Street. Kingsgate Street was approximately where the southbound carriageway of Southhampton Row is today.Shanghai Serviced Office