+ Reply to Thread
Results 1 to 7 of 7

Booking System for boardroom - Is it possible in Outlook for multiple users or Excel

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    Durham, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Booking System for boardroom - Is it possible in Outlook for multiple users or Excel

    Hello, this is my first thread and I feel challenged by the amount of knowledge and capability I've noticed as I read through the threads.

    I'm trying to identify a way of setting up a booking system for some meeting rooms we have at work. Always looking for a way of simplifying something that soaks up one of my colleagues time.

    I read this post about a golf booking system and it looks like it could be adapted to suit, I can imagine a different worksheet for each room and the fields for entry on choosing the timeslot being the meeting title, who booked and a contact number and the slot showing the meeting name when hovered over possibly.

    http://www.excelforum.com/excel-general/640650-using-excel-for-a-booking-system.html

    I noticed a similar thread about Outlook, I know nothing about this sort of stuff within Outlook and not sure it may be possible. I am just in my infancy with hyperlinks and macros and do not feel confident enough to start there as I do not know where to begin. Keen to learn and would love to figure out and play around within a program; learn best this way.

    Look forward to any advice,
    Smudges

  2. #2
    Registered User
    Join Date
    04-23-2013
    Location
    Durham, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Booking System for boardroom - Is it possible in Outlook for multiple users or Excel

    I have had a go at converting the file I found here among the threads.

    It's very good (credit to Leith Ross) I just tinkered with this. Would like to know how I would add an auto save and auto email function on booking or cancelling. And how you could select more than one cell ie to book a longer timeslot in one action rather than single cell entries.

    Boardroom Booking V1.zip

    Thanks
    Smudges

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Booking System for boardroom - Is it possible in Outlook for multiple users or Excel

    A system that I have used set up the room in Outlook as a "person" with a calendar and people could then see when the room was busy. Seemed to work OK

    Regards
    Alastair

  4. #4
    Registered User
    Join Date
    04-23-2013
    Location
    Durham, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Booking System for boardroom - Is it possible in Outlook for multiple users or Excel

    Thanks Alistair, I've found that I know little about Outlook but will have a bash, did you use the invite section in own outlook to book the room within it's own calendar?
    Did you look at the excel file? this was the preferred way to go for those I spoke to.
    Cheers Smudges

  5. #5
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Booking System for boardroom - Is it possible in Outlook for multiple users or Excel

    Hi Smudges

    The little you know about Outlook probably far exceeds my knowledge!

    I was a mere user and yes, having checked that the room was not already booked, I would invite the room to a meeting. (I am pleased to say that was one attendee who never was unable to attend!)

    I have not looked at the Excel system because the Outlook system worked so well, also because it does not involve a separate system - if you are using outlook to invite attendees it is simple to add another.

    Good luck with your decision

    Regards
    Alastair

  6. #6
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Booking System for boardroom - Is it possible in Outlook for multiple users or Excel

    Hi
    Have a look at this link which I am sure will help you decide which way to go:

    http://www.ljmu.ac.uk/ITHelp/email/118299.htm

    Good Luck.

    Tony

  7. #7
    Registered User
    Join Date
    04-23-2013
    Location
    Durham, England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Booking System for boardroom - Is it possible in Outlook for multiple users or Excel

    Thanks Tony,
    have had a brief look and know someone at work who can set up the accounts I need.
    Really appreciate the help.
    Cheers
    Smudges

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1