Thinking of meetings you have organised, you can do a few things to make them stand out, like configuring your calendar view to show your own meetings in a different colour. … click Conditional Formatting, add a new rule and click Condition… to set it up. Go to the Advanced tab, click on Field and choose All Appointment Fields, then Meeting Status, then set equals Meeting organizer as the condition, set your colour, font etc choice and save it all out.
Ghost meetings – you’re organiser, nobody else shows up How many times have you joined an online meeting that you organised, waited a few minutes and then realised that the other party/parties have actually declined but you didn’t notice? Sure, you can see in the tracking tab of a meeting, but might not check until you’ve already started the meeting and wonder why you’re on your Jack Jones. At this time of year, it’s quite likely you’ll have regular meetings with colleagues, customers or partners, and that instance has been declined by all of the invited attendees: the only real solution is to look ahead at your calendar, check the tracking responses and delete meetings which nobody else will attend. What a palaver. Never fear, dear reader. Here’s an Excel spreadsheet with a macro which will list all the future meetings where you are the organiser and all of the attendees have either not responded or have declined, so you can easily decide which ones to go and remove. Download the ZIP file from the link above, save/open it on your PC and you’ll see there’s a single XLSM file within. Open that in Excel, allow changes and enable Macros so it will run, then click the Scan Calendar button to show you a list of meetings that you might be able to delete since everyone else has already bailed out. It will take a couple of minutes to run but will eventually show you a list sorted with the earliest at the top. Have a great holiday season, everyone. See you in the New Year! |
Tag: meetings
594 – One day, meetings != Teams
When you create an appointment in Outlook and decide to turn it into a Teams meeting by clicking the icon on the Then there’s the text that gets added to the end of any existing appointment text, which gives dial-in info and provides a link for users who like to click on URLs or who are running a calendaring client which doesn’t support Teams natively. Some degree of customization can be done to this auto-text, but it’s an admin task rather than an end-user one.
The option is accessed from the main Outlook window, under File | Options | Calendar, and is just above the groovy feature which lets you choose to shorten the default meeting time, so as to allow you and the attendees to get out of your chair once or twice in a working day. From the ToW history files: When you create a thing in your calendar that’s just for you, that’s an Appointment. When you start to invite other people to your thing, then it becomes a Meeting. The Outlook UI changes when you’re dealing with Meetings vs Appointments (e.g., see tracking information on who accepted your meeting invitation, etc). When the Teams integration to Outlook was first rolled out, the workflow to create a meeting was typically to put the time in your diary, invite your desired attendees, then click the Teams Meeting button to add all the extra stuff that anoints the meeting to become a Teams one. That was a one-way process, though – if you clicked in error or decided to forego the online element, you either had to hack out the properties and text (since merely removing the “join” links in the text didn’t get rid of the Join Meeting UI in Outlook, as that was lit up by the contents of the various custom fields in the item) or, more likely, ditch the meeting and create a new one.
The bypass feature is meeting-specific, so if you are scheduling 1:1s with customers or partners, you might want to let the striaght through, but if hosting a larger meeting then having a lobby could let you get your internal team straight before bringing in your guests. |
575 – Who’s meeting?
![]()
Who has responded? Have most people declined?
If you are organising or attending a large business meeting with lots of attendees, it’s useful to be able to slice and dice the attendees more effectively – have most people declined and should I move the date, for example – click on the big Copy Status option at the top of the list.
If you right-click the table and select Table > Totals Row then if you filter the headings – like the responses, for example, you’ll be able to quickly see how many Accepted, Declined and so on. What could be interesting, too, is showing attendees names alongside their role, department, which office they’re from, their actual email address etc… Well, thanks to the magic of macros, use this Address Book Resolver spreadsheet, and just paste the responses from the Copy Status… step into cell A1, then hit the Resolve button. Some attendees might be external users (so won’t be known to your address book), and some of the names in the first column might not be unique enough to resolve, and will be highlighted (alongside external users) by a red Unknown in the Job Title column.
To use this sheet for resolving any list of bulk display names or alias names, just paste them into column A (and hide Columns B and C if you’re not using the output from a meeting invite tracking list). To prepare the spreadsheet for use, download the Address Book Resolver file as above (here it is again). Open the ZIP file and open the enclosed XLSM file or save it somewhere on your machine, then open it. Make sure you Enable Editing, then Enable Content so you can run the Macro that does the lookups. This is an evolution of the Alias resolver sheet posted back in ToW 417. |
547 – I Stream a stream
Streaming technology has risen with the availability of high-speed, low-latency internet access, allowing users to play on-demand – rather than watch or listen at the time a broadcaster decides – and is wiping out the need to record live TV to watch later, maybe even obsoleting the concept of broadcast TV. Perhaps the next vanguard is the gaming industry – as Microsoft and Sony get ready to launch next-generation consoles, buying a disc-based game to install and play will soon feel as old-hat as going to Blockbuster to rent a VHS for the night. Streaming games on-demand as part of a subscription service may be norm, rather than buying and owning a title outright. The console isn’t the only destination, though – streaming to mobiles is on the way.
Back in the workplace, streaming takes a different form, from virtualizing and delivering applications on-demand to running whole desktops somewhere else and displaying the output on a remote screen, not unlike the old mainframe/terminal model. And of course, there’s streaming of other types of media besides applications.
If you miss that, or weren’t at the meetin Unfortunately, you won’t get paid millions of dollars and given tons of free stuff but you might get some sort of corporate kudos and recognition.
It’s not just for storing recordings of meetings in the hope that people who couldn’t be bothered to turn up the first time will somehow tune in to watch the re-run; you can create new content and upload that for your colleagues to view, too. You could use the Record a Slide Show feature in PowerPoint, to make an (editable) recording of you giving a presentation and publishing it, or if you’re just looking to do something quick and easy (up to 15 minutes in duration), you can even kick off a screen-recording (with audio and video) from the Stream site directly.
Maybe record it to a VHS tape and post it to them? |
540 – All Together Now
Jared also announced Team Room services (more on rooms.microsoft.com), providing a management and monitoring service for physical rooms that are equipped with Teams kit, as well as the performance of the meeting space. The intent is to make the meeting experience better when we have a mix of in-person and remote people, as the world transitions to some kind of normality.
It takes some getting used to, especially if the meeting is one where there’s a predominant speaker – like a teacher – who appears in one of the chairs in the room rather than separate from it. Also, you might have some people who sit relatively close to their camera and will appear huge, while others look like they’d be sitting with feet dangling in the air. To learn more about how to use Together Mode, and for some info on what is planned for the future, see here. |
528 – Shorten your meetings (again)
Eagle-eyed reader John Westworth pointed out that a simpler way of doing much the same thing exists within Outlook already, if you’re on the Microsoft365 subscription. The feature arrived back in March 2019, in version 1902 (Build 11328.20146). Note: to find the version of the Office suite, go into Word – not Outlook itself – and under File | Account you’ll see what version you’re currently using. This year-old but hitherto little-known feature is called “End Meetings Early”: it lets you choose a value to over-ride the default meeting duration, so if you create what is ostensibly a 30-minute meeting, I’ll actually end some number of minutes early. In Outlook, go to File | Options and look under the Calendar section on the left, to set your favoured options. If you create your appointment or meeting – remembering that a meeting is just a special type of appointment, to which other people are invited – either With most of the world still WFH, it’s a handy way of making sure you don’t get in back-to-back meetings during the day, with no chance to get away from your screen. Assuming, of course, that everyone obeys the finish time rather than just over-running to the next half or full hour boundary… If you use the Teams client to create meetings, it doesn’t currently have the functionality to shorten them, so for now, it’s best to stick to Outlook for setting the meeting up. |