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.

610 – Windows 11 Hokey Cokey

Posted on December 10, 2021 by ewand

The Hokey Cokey / Hokey Pokey is a childhood party tradition many of us will recall, where you put something in and take it out again, or a step forward then a step back. The transition from Windows 10 to Windows 11 aims to simplify the user interface to a large extent, hiding things that some people think just get in the way, while beautifying the stuff that remains.

Power users might grind their teeth at some choices – like the context menu when you right-click on a file; it’s more spaced out (in terms of screen size) but designed to be clearer and more relevant, hiding some of the chaff that 3^rd party applications might install.

It even adds some hitherto hidden features, like Copy as path, which puts the full path & name of the selected file into the clipboard, ready to be pasted into a file selection dialog, for example. Some common commands – like cut or copy – have been replaced with icons at either the top or bottom of the dialog. If you want to use the old-style menu with the full set of options, you can do that too by selecting Show more… or pressing SHIFT+F10.

You can disable the new menu if you prefer the old style – just run a single command from an elevated command prompt then use Task Manager to restart the Windows Explorer application (or reboot).

Another piece of Windows that’s had a refresh is the notification function – first appearing in Windows 8 and having redesigns with every variant of Windows since, this is an attempt to summarize alerts from multiple apps in a similar way to how smartphones do it.

Windows 10 shows a little callout in the corner of the screen with the number of notifications to read; click on that or press WindowsKey+A and you’ll see a pane slide in showing notifications on the top, and a load of Quick Actions icons below.

Windows 11 has cleaned the UI up somewhat, with notifications and Quick Actions being separated out – look for a simple bubble with a number in the corner of the screen. Clicking on that or the date/time in the system tray (or press WindowsKey+N) displays notifications.

Pressing WindowsKey+A or just clicking on one of the network / sound / battery icons on the system tray will display the Quick Settings pop up, which can be tweaked by clicking on the pen icon. You can easily remove settings you don’t use – like Battery Saver, maybe – and swap in others from a fairly short list. Perhaps that list will grow in time.

Also worth a note is that WindowsKey+W brings in widgets from the other side, showing news, weather, calendar etc.

605 – Snooze la differénce

Posted on November 5, 2021 by ewand

Microsoft has always been good at having several ways of doing the same thing. Internal competition was encouraged with the idea that if several teams built solutions for the same problem, it would spur them all on and the best would win out. The Best Laid Plans don’t always work, and sometimes politics and machination gets in the way.

One modern incarnation of the multiple-ways principle is electronic mail; despite many attempts to replace email with other means of messaging, persistent chat etc, it’s still a huge deal (especially in business) and it’s still growing.

In the days when companies ran their own IT on-premises, there was Exchange, and the companion mail client Outlook arrived shortly after. Web-based consumer services like Hotmail, Yahoo! and Gmail changed the expectations of many users. Home and work email services have been getting closer in form and function since.

Microsoft’s current email clients are quite diverged: you can use the full-fat Outlook application to connect to your business email as well as your private ~~Hotmail~~ ~~MSN~~ ~~Live~~ Outlook.com / Gmail etc account. Then there’s the Windows Mail app, which is linked to the Outlook mobile apps so much so, that you can launch the Mail app by pressing WindowsKey+R then entering outlookmail: to start it (see more here).

The Mail app is pretty good – it can connect to a variety of sources including Office 365, so while it might not be an ideal primary business email application, it can be a good way of connecting to multiple personal email services.

One feature which appeared in different ways across multiple services and apps is the idea of Snoozing your email; initially pioneered by Gmail, others followed suit. It’s a different concept to flags and reminders, rather if you select an email and say snooze until 10am tomorrow, it will literally disappear from your inbox and it would reappear at the top of the pile the following morning.

Well, that’s how it works on some combinations. In the browser versions of both Hotmail / Outlook.com and Exchange/Office365, it works as you’d expect – you Snooze an email and it is actually moved into the Scheduled email folder (and you’ll see when it is later due to reappear in Inbox if you look in there). At the elected time, it shows up again on at the top of the mailbox. Let’s compare to some other Microsoft clients & services…

Outlook client and Office 365 – there is no snooze feature. Sorry. Just be more organised. If you snooze an email from another client, it will disappear from Inbox, but when it reappears, it’ll be in the same place as it was before – eg. if you Snooze a 9am email from the web app until 1pm, it will move into the Scheduled folder – but when it moves back into the Inbox, the Outlook and Windows Mail clients will show it down at 9am again so you might as well flag it and be done.

Windows Mail client with Outlook.com or Office 365 – Zip. Too bad.

Mobile Outlook and Web clients on Outlook.com or Office 365– Mail disappears and shows up again at the allotted time, right at the top of the mailbox. In the web clients, you’ll see the time stamp of the message as if it has literally just arrived; in the mobile version, though the message is ordered correctly (eg a 9am snooze to reappear at 1pm will show up between 12:30 and 1:15 mails), the displayed time is correct but a little clock icon is shown alongside. Clever.

At some point, there is a plan to deliver a single, unified, email client. An Ignite 2020 session talked about the roadmap and further commentary speculated that the One Outlook client may be coming, but isn’t going to be with us for some time yet.

In the meantime, maybe now’s the time to try the switch full time to Outlook Web App? You can even install it like a regular app, pin it to Start and so on.

602 – re-drawing Whiteboard

Posted on October 22, 2021 by ewand

One thing we all miss about having physical team meetings, is the delight of trying to read an enthusiastic participant’s attempt at getting their thought process across by scribbling on a whiteboard. Often with pens that have too little ink left to be legible. Charts with arrows always point up and left and bullet-point, capitalized text that may just be readable, but can anyone remember what it meant by the end of the meeting? At least you can take a picture to decipher later.

Fortunately, there are digital equivalences – you could be in a Teams meeting and co-authoring a document, where multiple people are editing at the same time and marking up comments. You could be watching someone share their 4K screen so they can walk through only a few dozen PowerPoint slides, or you might even have had a play with the shared Whiteboard app that’s been around and been part of Teams for a while now.

Well, the Whiteboard has had some pretty major updates recently.

The whole UI has been given an overhaul in line with the latest colourful design ethos, and there are lots of neat new features like the automatic shape recognition for mouse-driven drawing. Hold the Shift key down while you’re drawing with a mouse pointer or a Surface pen, and it’ll straighten lines for you.

It’s available in a variety of guises; there’s a web UI (app.whiteboard.microsoft.com) and it shows up in the menu on the top left of Office 365 web applications, such as subscribers would find by going to office.com and signing in with your ID. It’s on iOS and Android, though updates may flow through at different rates to other platforms.

Of course, it’s as a Microsoft Store app too; if you’re already a Windows 11 user, you may want to check out the new Store and look for the Library icon on the lower left, showing you what you’ve installed previously and also which apps have been most recently updated (and am Update button to kick off that process). Sadly, looking at an app’s page in the Store (still) doesn’t tell you what the current version is or when it was last updated.

To start Whiteboard in a Teams meeting, just go to the Share menu and look for the Whiteboard option, just under the part where you’d share your whole screen or individual window.

You can pin whiteboards to Teams channels or chats too; just add a Tab, select Whiteboard from the app list, and the content will persist within that context rather than a point-in-time meeting.

601 – Time and Focus

Posted on October 8, 2021 by ewand

Twice a year, it seems, there’s a ToW article (passim) about the shocking time zone change that is about to hit us. Or may have already – some parts of Australia (NSW) have just moved into summer time while neighbouring areas (QLD) stayed on year-round time. Much of Europe is about to head back into winter time on the last day of October. One week later, most of the US will return to standard time, meaning that the US and Europe will be one hour closer for those 7 days. Arizona will revert to having a single time zone for the whole state.

Many Windows 10 users may have escaped knowing about the app known as Alarms & Clock, and the groovy World Clock which shows a map with pinned locations of your choice, detailing the current time in each.

The cartographically obsessed may note that when compressed into a small window, the exact locations of some pins might look awry, but expand it properly and they’ll move around as you would expect. In the example above, London looks to be in Bordeaux, Budapest has swapped with Bangui while NYC has inexplicably relocated to eastern Peru.

Especially useful when figuring out relativity of time zones and future dates, is the Compare feature which lets you see what the time will be at a chosen point for each of your pinned cities, on a particular date. Take for example, Monday 1^st November, when in the space of one month, Sydney has moved two hours further away from London, yet the Atlantic is temporarily one hour shorter.

Well, the Clock app, as it’s now known – even though it doesn’t actually feature a clock per se, but let’s not split hairs – has been given a UI polish as part of Windows 11, and one additional new feature pane – Focus Sessions. It was shared with Windows Insiders a couple of months back, but is now mainstream for Windows 11 users.

Long-time ToW readers may recall an internal-to-Microsoft app called FocusTime, which let the user run a timer to focus on a given task, while putting Outlook into Offline mode so you didn’t get any new emails, and setting Office Communicator/Lync status to Do Not Disturb so you didn’t get annoying IMs. Well, Focus Sessions in Clock is doing a similar job though without (yet, at least) the integration to Outlook and Teams.

As well as tracking the number of Focus Sessions you have, the app can also let you create and pin tasks with Microsoft To-Do to achieve at a later focus time. One slight grind at the moment is that the app only allows you to sign in with a Microsoft Account, not your ~~Office~~ Microsoft 365 / work identity, so you won’t be able to seamlessly integrate with other task management tools you might already be using, like Outlook Tasks or an M365 To-Do list.

The Focus Sessions feature is newly released and the team behind it is looking into how to integrate with other tools and services, such as the Focus Assist feature in Windows (which quietens notifications, formerly known as Quiet Hours). If you’d like to see improvements or new features in the Focus Sessions section of the Clock App, make sure you go to the Feedback Hub and either upvote existing suggestions or add your own (instructions here). For some more tips on using Focus Sessions, see here.

599 – Time for a short survey?

Posted on October 3, 2021 by ewand

There was a time when visiting a website gave you a 1/10 chance of being offered a user survey, asking why you’re visiting today and how you feel about the company. Presumably, response rates were low enough that such surveys are largely replaced with annoying cookies and tracker software so the company can see what you’re doing without needing to ask you why.

Surveys in email can be a lot more useful, though, when trying to garner feedback about a particular topic. Outlook has had Voting Buttons since it first appeared in Office 97. They provide a simple way of asking a single question and getting recipients of the email to respond so that the sender can see what the votes cast are. You can take the defaults or add your own custom options, separated by semicolons.

Recipients get prompted in Outlook and can vote with a single click, rather than having to type a response, and the sender can see a Tracking tab on the message in their Sent Items folder to get the results.

One downside of voting buttons, though, is that they only work in Outlook – there’s no Web App or mobile support, so it does restrict the usability somewhat. Great news, though – a more modern approach is available; not only does it work using the Outlook mobile apps and the browser but it’s a bit more in-your-face for most Outlook users too, with a simple and quick way of responding.

The Poll feature in Outlook appeared in March 2020 but may have been easy to miss, given all the other stuff that was happening then. It’s accessible from the Insert menu on a new message, or if you look at the bottom of the Use Voting Buttons drop-down menu, it’s been added there too.

Clicking on the icon gives you a single question with two or more options; it’s powered by Microsoft Forms, but there’s no fancy branching or data validation – it’s a straight “choose one of these short text responses” feature and all the better for it.

If using Outlook (desktop or mobile) or OWA, when a recipient in your organization receives an email with a Poll included, it’s shown right at the top and is super simple to reply to. If the recipient is using a mail client that doesn’t understand the Poll, there’s also a link to the web-based version too.

Since it’s delivered as part of a Microsoft 365 / Office 365 subscription, it’s a little less slick when dealing with users outside of the organization / tenant (the inline previews don’t show up, so outsiders will need to click the link and use the web UI, and will need to type their email address into the response too), so think of it as a friendly and visible way of collecting simple internal votes.

595 – Emoji reboot

Posted on August 27, 2021 by ewand

Emojis can trace their roots back to the first 🙂 from September 1982. Originally knows as emoticons or simply smileys, many of us have adopted these icons like a form of punctuation, especially in social media / Yammer / Teams type comments. This topic was last visited 4 years ago in ToW 391.

Emojis are mostly agreed and defined by the Unicode Consortium, which controls the Universal Coded Character Set, adopted by many systems to maintain compatibility between each other. When a user sends a symbol in a text message, the phone of its recipient needs to know which character was being sent or confusion may occur. Interpreting what the actual emoji symbol means is still down to the end user, and there are many pitfalls to avoid.

Once both sender and recipient of a message or comment agree which emoji to display, the application or platform they’re each using still has to decide what it will look like, and sometimes the iconography – and therefore the subtext – will have changed over time; see the Pistol Emoji (emojipedia.org) as just one example.

Microsoft decided to adopt a “flat” emoji look in the Windows 10 timeframe, but that is starting to change again with the upcoming release of Windows 11 and the evolution of Microsoft 365 – as Art Director and “Emojiologist” Claire Anderson previewed, we’re going 3D and Fluent, due late this year. Oh, one more thing…

ToW reader Paul Robinson draws attention to the shortcut way of inserting emojis in Windows – it’s been a feature for a while now – just press WindowsKey + . and it will allow you to insert emojis into pretty much anywhere that accepts text.

The UI for the emoji panel is changing in Windows 11 too, with GIFs and other types of symbol being included and the whole thing is easier to search. A useful tooltip shows you what the symbol represents, though as said before, be careful with the potential interpretation of some of them. Peachy.

In Windows 10, the same keystroke brings up a simpler yet slightly more confusing UI. Both old and new (under the Symbols grouping) provide a neat way of finding and inserting other special characters; arguably quicker than fishing about in the Office menu, and certainly better than faffing around with typing in ANSI codes.

Paul likes to start Teams channel names with an emoji, and if you want to illustrate one difference between old world and new, try using them in email subject lines and see just how they appear in Outlook versus Outlook Web App…

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.

593 – It’s a Date

Posted on August 27, 2021 by ewand

Following last week’s missive on Notepad, including the obscure tip on how to create a log file, the topic of inserting and handling dates in other applications is worth a (re-)visit. Each individual app may choose to offer different methods and formats, but for common Office applications there are a handful of memorable tricks and shortcuts.

In Word, there are plenty of ways to insert and manage dates – perhaps the most useful way to remind the reader when the document was last updated (manually showing when a document was last reviewed or published). On the Insert tab, you’ll find Date & Time on the right-hand side, letting you add appropriate info in the format of your choice. You can also tick a box to update the field automatically, though that simply means every time the document is opened, it will show today’s date… which feels a bit pointless.

More useful could be to tell the reader when the document was created or last saved, by referencing the actual properties of the document (though be careful; auto-save might mean someone opened an old document, realised it was irrelevant, but had inadvertently saved it back).

On the Insert tab / Quick Parts, look under Field, then pick the doc property and format you’d like to show.

It is worth pointing out that showing a date as 10/1/21 (or similar) is ambiguous given that a few hundred million people will expect it be month-day-year while many of the remaining 7 billion will assume the day comes first, with a couple of billion presuming the format should normally start with the year, such as yyyy-mm-dd (which is arguably the most sensible of all; and it sorts properly, too).

A more daily usable short format like dd-mmm-yy (ie 13-Aug-21) should perhaps be the norm, especially when the date is appearing as text in a document. Pressing SHIFT+ALT+D in Word will insert the current Date as a field (so you can edit the format to remove ambiguity) and SHIFT+ALT+T inserts the current time too. In PowerPoint, both of these combos bring up the “Date & Time” dialogue to add the chosen content and format as plain text.

When formatting dates, incidentally, the convention is that two letters refer to the short number (eg dd = 13), whereas 3 d’s or m’s will use the short form of spelling the day or month, with 4 meaning the whole thing (ie Friday, August). Try formatting a cell in Excel as Custom, and you can preview what the format would be, by typing in a variety of letters.

While in Excel, it’s worth learning the short cut key to insert the date and time – CTRL+; and SHIFT+CTRL+; respectively (no doubt there’s a reason why Excel has a different shortcut to other Office apps – some legacy of Lotus 1-2-3 perhaps?).

OneNote fans will want to remember that SHIFT+ALT+D / T combo as it inserts the date/time into the notebook; really handy when taking notes of a phone call or similar. SHIFT+ALT+F puts both day and time, something that Word doesn’t offer. In both Desktop OneNote and users of the Windows Store version, it’s just plain text that gets added, so you’re on your own when it comes to formatting.

OneNote pages will typically have a date & time showing under their title – on the Desktop version, it’s possible to change that so as to mark a page as having been recently updated. No such luck on the lame duck Store version.

At least when stalwarts insist on writing – or worse, saying – a short-form date as something like “ten one”, there’s more than half of each month where one number in the date could only mean “day” – starting with the thirteenth (as in, 8/13 can never by the 8^th of a month, but 8/12 could be a few days before Christmas to Europeans, or the date when tweedy Americans start looking for grouse in the Yorkshire moors and Scottish Highlands).

585 – Heading to Viva

Posted on June 18, 2021 by ewand

Back in the mid/late 20^th century, the mainstream car market in developed countries was quite localized, where certain brands were seen as the default. Italians drove Fiats and Lancias; even until fairly recently, pretty much all you’d see in French towns were Citroëns and Renaults. The biggest blue-collar rivalry for Brits, Aussies and many Americans was undoubtedly… are you a Ford family, or a GM family?

In the UK’s 1970s, Ford had the Fiesta (small), Escort (mid), Cortina (large), Capri (sporty) and Granada (executive). GM operated in mainland Europe as Opel (Kadett/Rekord/Monza/Senator etc) and in the UK, as Vauxhall (Chevette/Cavalier/Carlton etc). Brits of a certain age may fondly? remember the Escort-sized, everyman family car: the Vauxhall Viva. The announcement of the employee wellbeing platform, Microsoft Viva thus brought a misty-eyed moment of reflection for some…

Since the unveiling in February 2021, Viva functionality has been gradually added to a variety of Office 365 experiences from Topics (based on what was called Project Cortex), Learning (highlighting online learning materials from a selection of company-curated sources, including stuff from LinkedIn Learning), Connections (a modern take on the company intranet) and the first module which was available, Insights, which is accessed via an app in Teams.

The Insights-defined “Virtual Commute” and calendar-blocking Focus Time has been mentioned previously in ToW #577, but it’s had a new shot in the arm as well as announcements about forthcoming improvements, such as the ability for Teams to quieten notifications when you’re in a focus period, and quiet time when Teams and Outlook will shush pinging you outside of working hours.

Now rolling out to Viva Insights is a set of mindfulness and meditation exercises curated from Headspace, who produce a load of online video as well as Netflix series and in-flight channels. See more about Headspace in Viva Insights, here.