Time Zones have featured lots on ToW; in an epoch when everyone was holed up WFH, the relative time people were at became especially important when trying to meet with them. Sometimes, it’s unavoidable that meeting times are unpalatable to some attendees if they’re in a far-flung time zone, but it’s worth reminding yourself how distant they are when trying to find the best time slot to speak with them. There are whole genres of mechanical watches which can display multiple time zones (check out GMT or World Time if horology is your thing), or you could rely on phone or computer-based aides-memoire, such as displaying multiple time zones alongside your calendar in Outlook, using the Windows Clock app with its world clock view, or even showing several clocks on the Windows task bar. A new addition to the arsenal of time zone tooling is a neat feature that’s appeared in the contact card in Teams and Outlook, showing you what the time is for the person you’re looking at. The time displayed is set by the device they’re using, so if on Windows, that’s the Time Zone setting. When travelling, rather than just manually winding the clock back or forward, it makes sense to set the correct time zone on your machine – either by allowing Windows to change it automatically or by specifically choosing it from the list. If you have multiple time zones displayed in Outlook, you can switch between them from the settings page – just right-click on the timeline to the side of the calendar and choose Change Time Zone, or go to File | Options | Calendar and look for the settings in there. When you swap them around inside Outlook, it will change the time zone on your PC. In some parts of the world, there’s pressure to prevent “work” from creeping into personal time, meaning emails and other messages should be held back and not sent during what’s supposedly down-time. Ireland has published a “right to disconnect” code of practice, and Portugal even made it illegal for an employer to contact their workers outside of working hours. If you’re using the right kind of Microsoft 365 subscription, Outlook can offer to delay emails you’re sending to people who are in different time zones – part of the Viva Insights package. Choosing this action has a similar effect to the Delay Delivery option which is visible on the Outlook toolbar, except that it won’t need Outlook to be running; the regular Delay feature leaves a message in your Outbox folder, and that normally means the Outlook client needs to be running at the time you want it to be sent. The Viva-powered delay option holds the message on the server until the allotted hour, and then delivers it to the recipients – handy if the sender is already outside their working hours by that point… |
Tag: Outlook
612 – New Year, New You (someday/maybe)
“The years go by so fast, let’s hope the next beats the last”– a sentiment that rings so true over the last couple of new year celebrations. Whether setting resolutions to do new things, read more, lose weight, be a better human etc, we all tend to reflect, even if just trying to do the same things as before but a bit better. Steve Clayton’s Friday Thing for the end of December had some great tips on things to do and try in the coming year. If we can’t reduce volume of professional communications (be that emails, Teams messages, whatever – just look at Steve cleaning his mailbox and removing >100,000 Sent Items from a single year), then maybe we could do a better job of managing the stuff that we have to deal with. Much ink has been spilled on how to be more effective and how to get things done, but one useful time/focus management principle to revisit is sometimes known as Eisenhower’s Matrix, of which a variety of depictions exist:
The premise is that any task has separate degrees of importance and urgency; we tend to prioritize urgent and overdue things versus things that are actually important. Discipline in task management can give us the clarity to not worry about seemingly urgent yet non-important tasks, and to stay focussed on things which are important, regardless of their urgency. Carve out 75 minutes if you can – because this stuff is important – to watch Randy Pausch’s lecture on Time Management, with the context that when it was recorded, he knew he only had weeks left to live: talk about prioritizing important vs urgent. How you put time and focus management into practice will differ depending on your own style and what tools you want to use. For the Windows / Microsoft 365 user, there are a few quick wins to consider:
|
611 – Finding Ghost meetings
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. … 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! |
605 – Snooze la differénce
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 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. |
599 – Time for a short survey?
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. |
594 – One day, meetings != Teams
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. |
579 – Archive that email
There was a time when archiving email meant taking a few Megabytes of data away from the restricted space within your mailbox, and possibly storing it for posterity in an a PST file on your PC, where the mail would stay until eventually the file is either corrupted or deleted with no backup being taken first, whichever inevitable event happened first. Thanks to Moore’s Law, mailbox capacity is now less of a constraint. Having too much clutter and the distraction that it causes is a more pressing issue than not having enough space. There are tools – some mythical and magical – to reduce volumes of unnecessary emails, and automatic processing via features like the Focused Inbox or Clutter can help to filter out stuff that is getting in the way, but fundamentally the decision on whether to delete, defer, delegate or just leave it lying about, rests with the user. There is still an AutoArchive function in Outlook, but you probably don’t want to use that. Instead, look at the simpler “Archive” feature, which is available for Microsoft 365 users and appeared first in the web client before making it into desktop Outlook. If you haven’t used the Outlook Web App for a while, it’s worth having a look since it has evolved massively over the years, and often leads the way for new functionality and integration, compared to its desk-bound precursor. There is a view that eventually, the web client will replace Outlook on the PC. If the Archive option shows up in the web UI (with suitable icon), the folder should also be visible in desktop Outlook in the main folder tree. Just like you have an Inbox, Drafts, Sent Items and so on, it will have been created for you but you may need to expand the view to locate it. And no, you can’t rename it… Check out the Archive folder properties, and you can see its size on your own machine or on the server (assuming that you’re not storing everything in your mailbox within your Outlook cache). To fire an email into the Archive folder from the desktop Outlook client, just press backspace if you’re currently viewing the message in the preview window. The default shortcut key to archive a message in Outlook Web App is E though you can reconfigure the app to use different shortcut schemes, in case you’re more familiar with other web clients. To see the shortcuts in Outlook web app at any time, just press the ? key. |
575 – Who’s meeting?
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…
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. |
573 – Searching in Outlook
A reader recently got in touch to ask for help in finding stuff in Outlook. The search capability within the application most of us use most of the time has evolved considerably throughout its life, with a prominently placed search bar now adorning the top of the main window. When you click into it, lots of helpful filtering and searching capabilities are offered in the ribbon below. It’s worth getting to grips with a few simple text search terms, though, so when you’re typing some search term you can direct Outlook to particular items. Helpfully, using the options in the menu will actually build the query that is fed to search, so you can type them in future. Simple quick wins include things like using from:name to show only emails that originated from a particular sender. Or has:attachment, which will only show you mails that have other files attached. Combined with a few other criteria, you can filter the results of your search pretty hard, rather than sifting through them. Adding some other smarts like received:”last month” can streamline some more. For more info on search terms, see here. The scenarios our reader posed, though, were specifically around searching in the calendar – eg, do I have a meeting in my calendar with a particular person? Or what recurring appointments are due to expire this month? If you navigate to your Calendar and click the down-pointing arrow to the right of the Search box, it will display a small form with series of other fields you can complete, in this case relevant to appointments rather than messages. Click + Add more options to bring up a picker that lets you add even more – such as whether the meeting is a recurring one, or if it shows in calendar as Busy or not. Selecting the options builds the query as before, so you can see a variety of defined names – like organizer | organiser (depending on your locale) or requiredattendee:. Coming back to the original question; if you want to find all future meetings in your calendar with anyone called Tony, you could type something like requiredattendee:tony start:>today. And if you want to find out which recurring meetings are expiring soon, start by searching is:recurring start:>today. That will show you a list of future recurring appointments, but not give all the info we’re looking for since the default results view doesn’t show anything about the pattern of recurrence – so right-click on one of the column headings of the search results and select Field Chooser, where we can add some extra columns to the view. Now, in the pop out window, change the filter from Frequently-used fields to All Appointment fields, and scroll down to find Recurrence Range End. Now drag and drop that field into the column list, then click on it to sort descending so you’ll now see all the meetings that are set up with a recurring pattern, ordered by when that pattern is due to end. For added context, you could put Recurrence and Recurrence Pattern on there too. Don’t be alarmed if some of them are due to keep happening until a very long way into the future. We’ll probably have stopped using email by then. History Lesson Before Outlook arrived as part of Office 97, users of Exchange Server had an email client and a separate calendar app (Schedule+; that’s why some diehards still say things like “send me an S+”, meaning send a meeting request). Both would maintain a connection to the server and would chat back and forth, only downloading data when a message or attachment was opened. Although this put something of a penalty on the network, it meant there was no need to cache large amounts of data on a PC hard disk. Outlook replaced both the mail and S+ clients, but maintained the same synchronous connection to the server. Outlook 2003 and Exchange 2003 changed the default model, since PC hard disks were getting much bigger and cheaper, so it made sense to have Outlook deal primarily with a cached copy of the user’s mailbox, bringing all kinds of performance benefits to both end user and to the operators of the server back-end. One really notable improvement was the ability to run fast searches against mailbox data that’s in the cache, rather than having to execute searches on the server. Prior to the cached mode, the best-case scenario for running a search was the server returned messages that fit a particular query asked by the client – mails received this week, mails with FOO in the subject line etc. If the server had indexed the relevant properties (received date, subject etc), it was pretty quick at sending back the results. If the user wanted something more in-depth, it was a punishingly slow process as each message would need to be picked up and inspected to see if it met the query – so searching for every email with a particular word in the message body text would be laborious. Three cheers for cached mode and client-side indexing. If you look at Advanced Find in Outlook today, though, you’re staring into a time vortex that transports you right back to the late 1990s, as it hasn’t really changed, even if the speed of getting results back will be noticeably better since you’re almost certainly pulling them out of a local copy of your mailbox. The first couple of tabs on the Advanced Find dialog let you search for mailbox items that fit some common criteria – but the third tab is a window into how Exchange stores and categorises messages, appointments, tasks etc. You can start Advanced Find from the Search Tools menu option as above. Or press CTRL+SHIFT+F. Aside: most apps use CTRL+F to invoke Find – try it in Word, Excel etc – but in the mail client, CTRL+F forwards a message instead. Find out why, here. The idea here is that you can build a query based on properties of messages – and when you select the Field from the extensive drop-down list, it would let you choose appropriate filters (some, like Flag Status or Receipt Requested would only have a couple of possible values, but others would let the user enter text, date or numeric filters). Not all of the fields are used for much these days – eg InfoPath Form Type harks back to the days when the now-defunct InfoPath could be used to create mailable forms – but having a poke around in Advanced Find can give a curious user some insight into how Exchange and Outlook organises their data. |
#571 – Save the Daylight
In the Northern Hemisphere, spring feels finally underway – and following a long locked-down winter, it can’t come soon enough. For many of us, even if meteorological spring started nearly 2 weeks ago, the promise of summer starts when the clocks go forward to daylight saving – or summer – time. If the country or state you’re in observes summer time, then you’re either about to enter (if in the northern half of the marble) or leave it (if southern). To keep us on our toes, this movement back or forth often happens around the world on different dates. To keep us on our toes, some countries have less-than-hour gaps between time zones, and in the past, others have decided to change time zone permanently. In olden days, some people wore GMT or World Time watches, which allowed the user to tell what the time was in different locations. With the World Time example here, the red arrow hand points (on a 24hr scale) to the current time; when the user rotates the outer bezel so that the nearest location is pointed to by that hand, the other locations listed on the bezel will be aligned with the 24hr number of the current time in those places… – eg if it’s 2:30am in Iran, then lining Tehran up with the red hand would put both London and Paris at midnight, since they’re both at GMT+1. eh? In October 1968, the UK decided to move to British Standard Time – GMT+1 – all year round. This particular wristwatch was produced between 1968 and the end of 1971, when the practice was reversed – so for a while, it was correct that London would be in the same time zone as Paris and Rome. Except the watch wouldn’t know when Paris and Rome went into summer time, thus putting them an hour further ahead… oh well, never mind. In a global working environment, especially one where everything is done online rather than having people in the same location, the friction of time zones changing has never been more obvious. Usually, you’ll only move through time zones relative to everyone else when you travel – flying across large distances, or maybe just driving across a bridge or dam. But now, a digitally-oriented meeting can shift its time for some of its attendees, relative to the others – depending on where the originator is based. The excellent Alarms & Clock app, which is part of Windows 10, lets you pin cities around the world to a map, showing their approximate location (bet you didn’t know Brissie was south east of Sydney?) and what the time is currently, and if you click the Compare icon to the left of Add new city, you’ll see a grid indicating the relative time in all of your pinned cities. You can jump to a specific date, so if you’re planning a meeting with people in different time zones, it might be a good idea to check what the impact of Daylight Saving Time (DST) changes might be. Those parts of the US which observe DST, are due to move an hour forward this coming Sunday (ie March 14th). In common with doing things differently to everywhere else, that brings the US (and Canada) one hour nearer most of Europe for the next two weeks, until the end of March. Much of the southern hemisphere comes out of DST the week after that, so by then Sydney will be two hours nearer London than currently. The impact of this can be seen in peoples’ calendars, when regular meetings somewhat inexplicably start to clash with each other – if a UK organiser set a recurring meeting for 4pm GMT, that would normally compel Seattleites to be there at 8am, but since they’ll be only 7 hours behind for a couple of weeks, that shifts to 9am in their calendar, potentially clashing with some existing 9am Pacific Daylight Time meeting. Conversely, a 9am PST / 5pm GMT meeting as created by the person in the US a few weeks ago, would now start at 4pm in the afternoon in London. Great news if that meeting is a Friday afternoon, as it brings beer o’clock one hour forward. Although Outlook does a pretty decent job of juggling the differences between time zones, there is no obvious way to show what time zone a meeting had been created in (eg show me all meetings that are going to be affected by this shift for the next 2 weeks). A simple trick if you want to check on a specific meeting, is to start a Reply to a meeting you’ve been invited to, whereupon you’ll see the time zone of its creator…
While It won’t help you identify the meetings that are causing the clashes, it might help restrain you from firing angry missives at the organiser of the meeting, if you know what’s causing it. |