Next Available Meeting with Userform Variables

Status
Not open for further replies.

Daniel Murphy

New Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Good Afternoon All,

This is my 1st post. I'll try and be as complete in my request as possible.

We have (a charitable housing association in the UK) scenarios where we want to book a meeting, invite others and book a room for a set time defined by the organiser. Another variable the organiser may choose to exercise is if the room has a screen.

The rooms have the capacity of the room in brackets within the name field (not in the column marked capacity - which has been left blank (I'm in Finance not IT))

I am comfortable creating userforms in the VBA builder but not as strong within Macros.

I envisage a macro that operates from either excel or outlook and pops up a userform. The user can enter up to 12 emails (attendees)
, selects if they need a room and or if they require a screen,
selects the duration of the meeting,
selects the minimum and maximum start and finish times (9am and 5pm as a default).

I believe it'd be easier to manage the variables in a separate table saved within the macro ie define each room and it's properties, but ultimately returns the next available space that meets all requirements and gives the option to send the invite with a variable subject line.

The macro should work from any computer. We use Microsoft Outlook Exchange for all calendars and colleagues.

You can see that the "location" field within the below calendar (that has been shared with me) is blank. although it says in the box below ... "When posting to this folder use: IPM.Appointment"

I'd like the macro to be able to saved within either outlook or excel. If outlook isn't open it should open it, if outlook is open it should use that instance.

I hope that's clear enough! Really hope you can help, it'll save days over a year.

upload_2017-5-4_16-48-42.png


upload_2017-5-4_16-14-44.png
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
not in the column marked capacity - which has been left blank (I'm in Finance not IT))
Don't blame IT for this one. :) That is just an informational field - it's more or less useless as it doesn't prevent anyone from inviting more. The advantage of adding it to the display name is that if you add the calendars to profile as shared calendars, you can see the capacity with little effort.

envisage a macro that operates from either excel or outlook and pops up a userform. The user can enter up to 12 emails (attendees)
, selects if they need a room and or if they require a screen,
selects the duration of the meeting,
selects the minimum and maximum start and finish times (9am and 5pm as a default).
it might be easier and more portable to put it in a sheet - code behind custom forms is picks and needs to be enabled on each computer. With it in Excel, as long as the users can run macros, you won't have a problem.

See Create a drop-down list - Office Support for one way to do a selection. Then you just need a macro to do a lookup and send that information to a new meeting - then the user picks the recipients.

Did you want the macro to pick a room or just present the user with the options to pick a room? This would be the hardest part - it might be easier to do this in outlook because you have the room find to show you if the room is available.

although it says in the box below ... "When posting to this folder use: IPM.Appointment"
That's not a problem - it's the default for all calendars - appointments because meetings when you add addresses.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
R AN ENCRYPTED CONNECTION TO YOUR MAIL SERVER IS NOT AVAILABLE. CLICK NEXT TO ATTEMPT USING AN UNENCRY Using Outlook 2
T Here is Practical Explanation about Next Life, Purpose of Human Life, philosophical/religious facts, theories etc. Using Outlook 0
D Add date next to day name in Outlook Today calendar view Using Outlook 1
D after delete mail, open the next one Outlook VBA and Custom Forms 0
witzker Macro to set contact reminder to next day 9:00 Outlook VBA and Custom Forms 45
M Setting flag follow up for next business day Outlook VBA and Custom Forms 1
F Set (flagged) reminder for next business day Using Outlook 4
X Delay sending an email until the next working day (public holidays) Outlook VBA and Custom Forms 0
S set a flag task date as the next weekday Outlook VBA and Custom Forms 4
M Change default "automatically test account settings when Next is clicked" Using Outlook 1
Connie Boyer Exporting Outlook calendar/find next repeating meeting Using Outlook 3
P How to save sent mail and forward it the next day Exchange Server Administration 3
M what's next after Outlook? Using Outlook 9
S Outlook 2010: Message Rules come back next time I restart Outlook Using Outlook 0
B Need help adding an image next to the Month Name in the header. Calendar Printing Assistant 1
J Print next 7 days view of calendar (2010) Using Outlook 3
E Next five calendar days Calendar Printing Assistant 2
P Task view - due next 21 days Using Outlook 1
T Outlook 2010 Closes the Window When I Click "Next Item" (Down Arrow) Using Outlook 2
B Moving to next message closes message window Using Outlook 1
M In Outlook 2010, upon deleting an open e-mail, the next e-mail does not open automatically in full s Using Outlook 2
I Reminder on Sent Msg being removed upon next Send/Receive execution in Outlook Using Outlook 1
S 2010 Calendar How to change the Current month and next month in header bar Using Outlook 1
M OL2007 doesn't properly shut down. Always hangs at next restart... Using Outlook 1
S Outlook 2003 suddenly doesn't open next msg after delete Using Outlook 1
G Email messages being received but not displayed until the next day on Outlook 2010 Using Outlook 2
V Clearing the Previous Appointment/Next Appointment Tabs when view multiple calendars for resources. Using Outlook 1
J HOW TO SET DEFAULT E-MAIL FONTS AND LINE SPACING - using a theme for a particular e-mail butn don't know how to set so it stays that way for the next Using Outlook 1
1 What is the meaning of this icon next to some messages in my outlook 2007 inbox? Cannot find any inf Using Outlook 2
B My sent mail does not appear in the 'Sent Items' until the next day. Have tried turning off my computer and turning it back on but that doe Using Outlook 2
A How to change time, what Exchange UM wait for next button Exchange Server Administration 5
B Previous printed email, printing on next email print job Using Outlook 4
S 2003: AutoPick Next Calendar feature appears to be disabled Exchange Server Administration 3
N Display online status next to name is greyed out Using Outlook 4
E Outlook 2007..... one day it's there and the next it's not! I click on the icon in startup and nothing. Using Outlook 5
D Outlook 2010; How to set it to automatically open the next messsage Using Outlook 3
D Follow up flag only displays Set Flag, Clear Flag. Missing Today, Tomorrow, This Week, Next Week, No Using Outlook 2
K Changing the default value for 'Test Account Settings by clicking the Next button' Using Outlook 4
W Snooze defaults to next reminder time and s/b time before/until the event Using Outlook 3
A Custom form - hitting 'next item' button hangs Outlook Outlook VBA and Custom Forms 2
J User cannot login owa if I select the option 'User must change password at next logon' in exchange 2010 Using Outlook 3
A how to capture events for next item Outlook VBA and Custom Forms 10
W How do I calculate the next recurrence date? Outlook VBA and Custom Forms 1
T Next Item & Previous Item Events Outlook VBA and Custom Forms 1
J Outlook 2007 Hide Messages Option not Available Using Outlook 2
F "This action is not available in the current mode" Using Outlook 0
Bri the Tech Guy Registry Tweak to make "Run a Script" Action Available Outlook VBA and Custom Forms 2
Ascar_CT Rule behavior analysis - any tools available? Using Outlook 0
E for Mac: Assign Task not available!? Using Outlook 1
T How to create meeting recurrences that are not available in the appointment screen? Using Outlook 1
Similar threads


















































Top