#25: Where shall we meet again?

Posted on May 3, 2024 by ewand

If you are of the 400 million or so users of Microsoft 365, you probably use email as one of the key services, provided by Exchange Online. A little more than 28 years ago, Microsoft released Exchange Server, its first proper server product* and a key progenitor of Active Directory, an enabler of pervasive use of email in business and even standardising the means to deliver mail to your mobile.

Though its main usage is email and calendaring, Exchange was designed in an era when “groupware” was the next big thing; the idea was that the server would be a database of loosely structured data that end users would interact with using forms to display and edit those data. As it happens, an email message is just a bunch of data items like the recipients’ names, the subject and a whole load of hidden fields used in routing, storing and managing that message. When you open that message in Outlook, it uses a form which looks like an email to interpret the fields.

Outlook 97 and its numerous successors all feature a form editing capability – right-click on the toolbar, choose Customize then on the resulting dialog, you’ll see a hidden “Developer” tab.

Tick that box to unveil it and you’ll see a new ribbon tab with all kinds of functions, one of which is to choose a form from various libraries, or even design a new one (based on an existing form, such as an email or a contact card).

A relatively simple use of this kind of thing would be to add a custom field or two to an existing form; it might be easier to use categories but if you wanted to include some more structured information to a contact form, for example, you could put additional data fields with validation logic behind them. Essentially what you’d be doing here is adding some custom fields to the database, and you’d also be customizing the form which is used to view and edit that newly extended data structure.

For one practical application of this technique, see ToW 259, which shows you how to track who you sent and received Christmas cards to/from, by modifying your contacts form.

The downside of customizing a form is that you need to distribute the newly extended form otherwise people won’t be able to see the additional fields – that’s essentially an automatic process when using Exchange and Outlook within a single organization (the form is published on the server), but it becomes a whole lot messier when dealing with external parties. And it doesn’t work at all on web, or mobile, or the “New Outlook” (which is basically the web client wrapped up to look like an app). So, it’s super useful these days.

New Outlook, new Meetings

One of the subtle changes that New Outlook introduces to anyone who switches from Old Outlook, is a change in name to a key part of its functionality. In Outlook, you have appointments (which are things you put in your own diary) and meetings (which are appointments to which you invite other people or resources – or have been invited by the organizer – and that changes the form which is used to interact with the calendar entry).

New Outlook simply has “Events”, which essentially combines the previous two concepts in one. As well as a different UI, New Outlook adds some other functions, like the “In-person event” button, which lets you make the point that a meeting is taking place IRL rather than only virtually.

This same functionality is not available in Old Outlook or in mobile versions, only in Web App and New Outlook – but that doesn’t really matter too much, as all the “in-person” switch does is to append “[In-person]” to the end of the Title line.

Clearing the switch removes the text, though it’s just searching for that string and hacking it out (set a Subject line of I like people [In-person] [In-person] [In-person] and then toggle the switch back and forth a couple of times to observe). A more elegant way of building this would have been to make a new field on the Appointment / Meeting object called “in-person” and then had Outlook et al flip that switch, rather than just tagging a bit of text on. Oh well…

If you’d like to explore what lies beneath your favourite Outlook form, try opening the item (Contact, message, Task etc) in Old Outlook, and if you don’t see a Developer tab, repeat the exercise from earlier and right-click / customize / enable Developer. You’ll then see a “Design This Form” option, which flips your current item into developer mode, exposing hidden regions. Look in the “all fields” tab, and you’ll find every property that has been set on the item.

This trick can be useful for finding out when an appointment has really been created in someone else’s calendar (if they share their calendar) – if they are suddenly unavailable to meet, you could see if they had that blocking appointment in there already or just created it after you’d asked…

APPENDIX

Email was first invented in 1971, and by the mid 1990s it was in common use amongst people who worked on terminals or desktop computers as a large part of their job. While standards like X400 and SMTP existed for exchanging email with other entities, you weren’t going to be emailing your bank manager or booking a doctors appointment. For some reason, X400 never really took off as intended – who knows why? Most companies which used email relied on it for internal communications – IBM’s NOSS internal system (a PROFS implementation) had over 350,000 users by the end of the 1980s, with no easy way to send email to external parties.

As dial-up services like AOL and ComuServe started gaining popularity amongst home users, and those walled-garden opened up and allowed exchange of email over the internet, companies began to adopt email more widely and people would start to put their email address on their business cards (alongside their fax number).

*Exchange was arguably Microsoft’s first proper server product, apart from Windows NT Server on which it ran. There were other back-end products which pre-dated Exchange, like SMS (systems management software), SNA server (for communicating with mainframes) and the early NT variants of SQL Server which had been based on Sybase’s SQL Server. These and Exchange had been bundled together as Microsoft BackOffice for a while. Exchange was the first Microsoft server product that most end users would interact with.

672 – Why your meetings are clashing

Posted on March 10, 2023 (Updated March 10, 2023) by ewand

Look at your work calendar for the next two weeks or so; if you’re a part of a multi-national organization that routinely has meetings with people all over the world, your nicely ordered diary might be a maelstrom of overlapping and clashing appointments. Welcome to the start of the 6-monthly Daylight Saving Time Shuffle! Of course, you might have clashing for other reasons.

Meetings in Outlook – apparently, other PIMs are available – are created in the time zone of the organizer. If you’re in London and have set up a weekly 4pm meeting, most of the time that’s at 8am for the people in San Francisco, but for the next 2 weeks it’d be 9am and therefore possibly conflicting with whatever else they had planned for then.

The topic of time and its zones has been covered ad nauseam on ToW passim, but it’s worth a quick reminder of what is ahead (and other countries / regions still do vary – see a summary of the global daylight saving time dates and regions, here), especially since the US has a habit of doing things differently to the rest of the world:

12 March 2023 – Most of the US, Canada, Carribean enters DST (if observed)
24-26 March – most of the rest of the Northern Hemisphere enters DST (if observed)
2 April – Australia, New Zealand leaves DST

Practically, that means that today, a noon meeting in Seattle would be 8pm in London and 7am (tomorrow) in Sydney, but in a little over 3 weeks that would have moved to noon/7pm/6am and eventually settled back at noon SEA and 8pm LON, but now at a refreshing 5am SYD.

Fortunately, the Clock app on Windows 11 has a “Word Clock” feature that lets you pin cities to the map and you’ll see what the current time is (and what the time zone offset is currently). You can also get a tabular view of what the relative time will be at any given date.

Windows Clock app

650 – All hands meetings

Posted on September 30, 2022 by ewand

Even though Dilbert isn’t funny any more there have been some good ones in the past, satirising corporate life. People who used to be cubicle or office based might struggle to deal with the new reality that most office workers would rather not be in the office 5-days-a week, 9 to 5, yet bosses would prefer people to not be slacking off at home in their PJs.

Zoom, Teams and other platforms adopted a metaphor in an online meeting, where attendees can figuritively raise their hand so they can be asked to speak. It works well when the people running the meeting have the discipline to check that they don’t have a forest of lifted paws before asking, “are there any questions?” to their audience.

It helps if presenters are not doing the lowest-common-denominator thing of sharing their desktop to present slides. Using Teams’ own slide sharing means you can see the chat, and who’s joined, and whether they have their hand raised.

Meeting participants also need to have the practice of raising their hand and waiting to be invited to talk, rather than blaring in to raise new topics or talk over others. Other attendees can also see who has their hand raised (look in the video gallery and you may notice those who have their hand raised are highlighted) and if you look in the People pane, you’ll see the order that attendees raised their hands as well, so if you’re the organizer then you can ask the top and most patient questioner to contribute at a point that makes sense.

A new etiquette has sprung up in hybrid meetings, though – how to balance commentary from remote attendees with chatter that’s happening in the room? Ordinarily, you’d rely on body language in a meeting room to decide it’s time to interject, nodding and perhaps making hand gestures yourself.

When some / half / most of the attendees are remote but you’re in the physical meeting room, it might be prudent to actually join the same Teams meeting on your PC – you’d only be sitting in the room looking at email on your screen anyway – and use the hand raise function before speaking, even if you’re sitting next to other contributors. This way, you’re on the same footing as all the remote attendees and it shows that you are at least giving the pretence of thinking about them too.

When joining a Teams meeting on your PC, there’s a yeah-yeah dialog box which pops up just before entering the “room”, which presents various potentially relevant audio related options. The norm would be to use comptuer audio, then select what speakers/mic you want to use.

These join options can also give you a number to dial in to (or be called by the meeting, so you can stay silent and camera-less on somebody else’s dollar).

If you’re the first to join while in a physical Teams Room, you could bring the room system into your meeting and control it from your machine.

If you are a bod in the room, though, then choose “Don’t use audio” to avoid any mic or speaker issues, causing endless echo. That way, you can enter the online meeting while being in the actual room, interact with other attendees on chat and use features like reactions and hand raising just as if you’re sitting at home.

Just remember that you are, actually, in front of other people, and also remember to change the default option back to “Computer audio” next time you enter a truly remote meeting, or you’ll spend the first few minutes saying “hello, hello? Can you hear me…?”

611 – Finding Ghost meetings

Posted on December 17, 2021 by ewand

ToW has talked before about appointments and meetings in Outlook – in summary, an appointment is something you put in your diary, a meeting is one to which you invite others (or have been invited to by someone else).

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.

Go to View | View Settings…

… 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.

You can see at a glance which ones you need to drive and which ones you can coast along with, muted and your camera off because, “oh, the WiFi’s playing up”.

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!

Virtually, obvs.

594 – One day, meetings != Teams

Posted on August 27, 2021 by ewand

Over the last 18 months, the number of Teams users has shot up – over 250M according to latest published stats, or almost 20x what they were 2 years ago. We all know why.

When you create an appointment in Outlook and decide to turn it into a Teams meeting by clicking the icon on the Meeting tab, a bunch of custom fields are added to the meeting item in your calendar to define how it should be handled by the Outlook application, allowing such functionality as right-clicking on an item in your calendar and joining the meeting from there.

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.

LinkedIn’s #1 fan, Brian Galicia, got in touch to draw attention to an option in Outlook which lets you make every meeting a Teams meeting (since the days of meeting people face to face now feel like a distant memory). Fortunately, it only adds the appendages to a calendar appointment when you start to invite people to it, so if you put stuff in your calendar to remind you to do things In Real Life, it won’t get in the way.

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.

Happily, Outlook now lets you do the removal from within its UI. You’ll find that under Settings on the Meeting tab, where you can also control some other functions, like whether external attendees need to be held in the lobby or whether you let them straight in.

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?

Posted on April 9, 2021 (Updated July 14, 2022) by ewand

Organising a meeting in Outlook means sending out requests to participate – effectively you’re creating an appointment or event in your own calendar, then converting into a meeting by inviting other people to join you. If you’re putting something in your diary and want other people to know about it, but without expecting them to join you (eg you’re going on vacation and presumably don’t want your teammates to tag along), simple tricks can reduce the annoyance you might foist onto your co-workers…

Create a separate appointment for sharing (rather than forwarding one already used to block out your own calendar)
Under Response Options, clear the default “Request Responses” option, so they don’t need to respond
Set Reminder to None so people don’t get a notification fired, unless you think you’re important enough to make sure they know at the time, that you’re away
Show As: Free, so your appointment doesn’t block out their calendar and get in the way of other people who are trying to book proper meetings with them. Think of this as an FYI for colleagues’ calendars.

Who has responded? Have most people declined?

When you open a meeting you’re organising and which you do want people to respond to, you’ve always been able to see (in the Tracking tab) how many people have accepted or declined etc. A couple of years back, Outlook added the feature of Tracking if you’re an attendee, so anyone in the same tenant as the organizer can see who else has accepted etc.

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.

It’s now easy to paste the info into a blank Excel sheet, and before even changing selection, hit the Format as Table option on the Home tab; confirm the selection area is OK, tell it you want to add a header row and choose a style that suits.

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.

If you manually look up an unresolved internal user in the Outlook address book, and find the correct alias name for that person, paste it into the first column instead of their name, and re-run the Resolve function.

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

Posted on September 11, 2020 by ewand

Popular subscriptions services which deliver on-demand content, rather than recording or otherwise acquiring it in advance, are killing off CD and DVD sales. Every generation sees a new technology upset the old – the 1980s MTV video vs the 1970s “taping from the radio” for example.

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.

Xbox Game Pass Ultimate subscribers will soon be able to start using “Project xCloud” (the code name, now simply known as “cloud gaming”) services, which basically run Xbox games in Azure, and stream the video & audio down to a mobile device, initially an Android phone or tablet, but also supporting Windows PCs in time. There was a plan to allow cloud gaming to work on iOS too, but that has been scuttled – Apple says no. Maybe something to do with the App Store revenue stream, though the company made some blah-blah about the store being all about a curated quality of applications. Of course it is.

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.

Many users will first encounter Microsoft Stream, the secure enterprise video service, if they’re using Teams and see a meeting has been recorded – usually, when the organizer hits the button, a link to the recorded video will be dropped into the chat window of the meeting.

If you miss that, or weren’t at the meeting in the first place but want to catch up, try going to microsoftstream.com and search, either by the name of the meeting, or by looking under People for the name of the organizer where you’ll see all of their content. If you’re recording a load of meetings yourself (like a training series, or a monthly team call) then it might be worth creating a channel and adding those recordings to make it easier for people to see related content.

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.

Stream is ultimately replacing the earlier Office 365 Video service, though isn’t yet fully feature compatible: see a comparison of the two, here.

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.

When you publish your video to Stream, it’s worth making sure you’re making it visible – depending on how you’re set up, it may be limited. Go into My Content and look for the coloured icon showing the permissions. Click on the pencil icon to the left, to edit the video properties, including setting the permissions or adding it to a channel. For more about managing permissions on Stream, see here.

One thing to note, is that if you have remote participants in a Teams meeting – customers, partners etc – then they won’t be able to see the recording you make; the Stream service is limited to your own organization, as defined by the Azure Active Directory that’s used to authenticate you. If you need to be able to share the video with others (making sure you’re not breaking any rules, obvs), then you may be able to download just an MP4 video file – none of the other metadata, captions, transcriptions etc that you get with Stream, it’ll just be the main video – and at least make that available separately.

Maybe record it to a VHS tape and post it to them?

540 – All Together Now

Posted on July 24, 2020 (Updated August 7, 2020) by ewand

Yet more updates have arrived for users of Teams; Jared Spataro did a good session at Inspire in July, outlining some changes that are already available for some and talked about new capabilities that are on the way. There’s a cool background noise suppression capability to remove the clamour that’s happening behind someone, and a load of transcription / captioning technology that works alongside meeting recording, to highlight who said what.

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.

While we’re still in a predominantly-remote working cycle, Together Mode introduces an intriguing way of displaying videos from a group of people – rather than the “Gallery Mode” of video boxes arranged in a grid, Together mode uses the same technology which can apply a custom background to cut out the user’s video of their person, and place that in a lecture / theatre type setting.

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)

Posted on May 13, 2020 by ewand

Last week’s tip talked of the philosophy around 22 minute meetings, and shared a way of forcing Outlook to adjust the start and duration of meetings by default, to help you enforce the discipline.

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 by using the New… option on the menu or by double-clicking on a gap in your calendar, the adjustment will be applied after the item is created (and before it’s sent, if it is a meeting).

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.