GordonPrince
asked on
easiest way to make an appointment for me + one of 8 rooms
I'm using Outlook 2007. I'm trying to come up with an easy way to book an appointment for me + one of 8 rooms.
If I make a Group Schedule for me + the 8 meeting rooms, the scheduler tries to find a way to find a time when me + all 8 of the meeting rooms are available. I want a time when me and any one of the 8 rooms is available (the rooms are all the same).
What would people recommend as a good way to teach people how to do this?
If someone has an idea about a macro that could do it, I could go that way if necessary (I'm an experienced VBA programmer).
If I make a Group Schedule for me + the 8 meeting rooms, the scheduler tries to find a way to find a time when me + all 8 of the meeting rooms are available. I want a time when me and any one of the 8 rooms is available (the rooms are all the same).
What would people recommend as a good way to teach people how to do this?
If someone has an idea about a macro that could do it, I could go that way if necessary (I'm an experienced VBA programmer).
Hi, GordonPrice.
It's been awhile. Hope you're doing well.
I think I can do what you want in a macro. Armed with the names of the rooms and a starting and ending time a macro can search for the first room that's free and add it to the appointment. Is that what you had in mind?
It's been awhile. Hope you're doing well.
I think I can do what you want in a macro. Armed with the names of the rooms and a starting and ending time a macro can search for the first room that's free and add it to the appointment. Is that what you had in mind?
ASKER
BlueDevilFan: The macro seems like the way to go, if you can think of something that would work.
Needs to become a button on the Outlook toolbar that offers next available appointment for me + one of the 8 rooms. A display would be nice, but a pop-up with the date/time would be adequate to start with.
If the user answers vbYes then book meeting in the room,
vbNo = show me the next availability,
vbCancel = stop showing me the choices.
My rooms are IR1, IR2, IR3... IR8.
I've worked with Recipient.FreeBusy recently, so that's one option. But if there's something that could be stitched together in a macro, I'd like to consider that, too.
Any ideas greatly appreciated.
Needs to become a button on the Outlook toolbar that offers next available appointment for me + one of the 8 rooms. A display would be nice, but a pop-up with the date/time would be adequate to start with.
If the user answers vbYes then book meeting in the room,
vbNo = show me the next availability,
vbCancel = stop showing me the choices.
My rooms are IR1, IR2, IR3... IR8.
I've worked with Recipient.FreeBusy recently, so that's one option. But if there's something that could be stitched together in a macro, I'd like to consider that, too.
Any ideas greatly appreciated.
I haven't forgotten about this question. I should have something today.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is excellent. Thanks.
Thanks and you're welcome.
1) Create a new Meeting Request, and add all of the attendees in the To: field, and all of the rooms in the Resources: field.
2) Click on the Scheduling tab, and under the Options button, select AutoPick > Required People and One Resource.
3) Click the AutoPick Next or Previous button to locate the appropriate time slot. Only one of the free resources (rooms) will be selected, and the others will be automatically disabled/excluded from the invite.