573 – Searching in Outlook

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

clip_image004It’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 clip_image006emails 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 clip_image008small 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 clip_image010recurring 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.

clip_image012Now, 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.

clip_image013

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.

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

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

572 – simple OneNote tricks

clip_image001OneNote has been part of the Office suite since 2003, and has been freely downloadable for much of that time; it’s an invaluable tool for note taking or just capturing information that you’ll want to recall at some point. There have been a few sideways turns in the roadmap, though – as well as the Office application (on Windows and Mac), there is OneNote for mobile devices, OneNote the web experience and OneNote the “Modern” Windows app.

To try to simplify the roadmap somewhat, the app formerly known as OneNote 2016 is now just “OneNote”, and the Store app that shares more of its UX with the mobile and web versions, is OneNote for Windows 10. For more detail on the differences between all the versions, see here.

At one point, the plan was to discontinue the more functional desktop app, and shift development to the simpler Store version, however that plan was rowed back and OneNote (the Office app) will continue to be part of Office, even though it wasn’t installed by default in 2019. The perpetual version of Office (as opposed to the subscription service that is Microsoft 365) will be updated later this year, and OneNote will still be part of that. Probably.

clip_image002There’s not a lot being published on the Roadmap for OneNote, though, so it may not be getting hosts of new features… See here for a list of some recent updates to OneNote for Windows 10. You can jump to the latest What’s New from the Help menu in the Store version.

As has been covered on ToW passim (here, here), you can start OneNote from the Run command, by pressing WindowsKey+R then onenote <enter> for the desktop version, or onenote: for the modern Windows 10 version. In the latter, you can also pin particular pages to the Start menu, handy if you want to jump to a particular page of quick notes or ideas.

clip_image003Any version of OneNote is just great at noting down lists – perhaps by using your pen (though if you’re a big inker, you might want to also check out Journal by Microsoft Garage – it’s a notebook intended for “ink first”).

Or maybe by typing a quick few lines at first, and formatting as a list once you’ve got some text. There are some shortcuts to help that formatting; in both OneNote and OneNote for Windows 10, to quickly select what you’ve just typed, hold the shift key and press the up arrow to grab a row at a time.

clip_image004If you press CTRL+ . on selected text, it will turn into a bulleted list, or press CTRL+ / to make it numbered, and the same combination will remove the list formatting.

To create a table, just press TAB to turn whatever you’ve just typed into the first column, and keep pressing TAB to create new columns, or CTRL+ENTER to accept the column layout and start adding extra rows, or to insert a new row into an existing table. Once have content in your table, you can easily move rows around by simply putting your cursor in the row you want to shift, and hold ALT+SHIFT then use the up / down arrow keys to move that row. Much simpler than faffing about with copy & paste.

clip_image005On the full-fat version of OneNote, you could also select your list and clip_image006by using the somewhat obscure-sounding menu option “Link to Pages”, OneNote will create a new page for each item in your list and then make a hot-link to it. Hover the mouse over to see the link. clip_image007

You can manually create links to any page by selecting the text you want to hot-link from, and press CTRL+K; then either select the destination in the dialog box, or paste the link to the page (or paragraph) if you’ve already copied that link to the clipboard.

clip_image008If you’re going to be doing much with tables, it’s probably better to use the OneNote app rather than the Store one; the older tool has much richer table formatting capabilities, and it also has an Addin architecture which is completely absent from the OneNote for Windows 10 version.

clip_image009The fantastic OneCalendar addin shows you all the notebook pages you’ve worked on by date, so if you spread your note-taking across a variety of sections or even shared notebooks, then it can be invaluable to jump right to the notes in question.

Its big brother, OneTastic, also allows using pre-written Macros to automate tasks like custom sorting of sections and loads more.

#571 – Save the Daylight

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

clip_image004In 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 TimeGMT+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.

clip_image006There may be trouble ahead

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.

clip_image008The 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.
More info.

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…

—–Original Appointment—–
From: originator

Sent: 14 February 2021 08:03
To: people

Cc: more people

Subject: meeting that could have been an email
When: 12 March 2021 08:30-09:00 (UTC-08:00) Pacific Time (US & Canada).
Where: Microsoft Teams Meeting

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.

570 – Automation for all

clip_image002Before The Event, if you were an IT professional in the Microsoft ecosystem for any amount of time, you may have marked your calendar by conferences you were going to attend – PDC, WPC, maybe TechEd? The big ones always happened in the US, but some were followed up with regional replays.

All were replaced in time with rebranded but otherwise similarly targeted variants:

  • Build (in the spring, initially in SFO to appeal to the cool cats writing apps, then moved to Seattle with a focus on cloud),
  • Inspire (in the summer, with thousands of partners, latterly held in Las Vegas) and
  • Ignite (in the autumn, home to lots of IT pros, often in Orlando).

2020 saw a fast move to hosting everything digitally and for the most part got away with it. 2021 was always going to be different, and the first big do of the year took place this past week – a spring Ignite. When you don’t need to book a conference centre 12 months in advance and get thousands of people to fly in to attend, why not do some of the big events more often or a different time of year?

For a summary of what was being announced at Ignite 2021, check out the excellent Ignite Book of News.

Charles Lamanna’s keynote on Power Platform highlighted some news around Power Automate – one of the key components of the Power Platform and formerly known as Microsoft Flow, Power Automate began as an online service that could make workflows to stitch together actions that happened across multiple online applications –a new booking alert email to a hotel mailbox could add an appointment to a Google Calendar and send a notification to someone on Microsoft Teams, and so on.

Just announced is that the fairly new Power Automate Desktop will be included in Windows 10 and is free to download and use now.

clip_image004

This tool brings automation concepts right down to the desktop, allowing any end user to create flows that span multiple apps and services; it’s not unlike an advanced Macro Recorder, where the user can perform a task that is regularly repeated, and the software will keep track of the steps they’re making.

With PAD, however, it’s more than just repetition – they can go back and inject data into those steps, like take the email addresses from column B of this spreadsheet and send a specific email to each one, with logic determining what should be different for each message (so a lot more granular than a simple mail merge).

clip_image006As well as some pretty advanced integration into all kinds of apps on Windows and services on the web, there are lots of tools to guide the flow of logic; while it might seem a bit scary to some, anyone who’s ever done some basic programming will be able to quickly figure out how to describe the logic without needing to break out a line of code.

This capability has come about through Microsoft acquiring Robotic Process Automation specialist company Softomotive in early 2020.

The impact of RPA is explored when looking at how this technology could remove boring, repetitive tasks thus freeing up clever and creative people to do something better with their time and attention. On one hand, automating processes could be a threat as we’ll need fewer people to do the same things, but a more optimistic view is that it will increase productivity and satisfaction. If you have 17 minutes free, then check out a great TEDx talk on “White Collar Robots”.

There’s a great demo of Power Automate technology being used in real-world scenarios, on Microsoft Mechanics. See more videos from the makers on Microsoft Mechanics – YouTube

569 – Password migration

clip_image002One of the problems with free software and particularly free services, is that at some point, they might stop being free. The path of freely-provided online services is littered with companies who gave their service away to get the users, then grappled with the reality that more users means more costs to deliver the service – and if they don’t get enough income from whatever sources they can, the free ride will come to an end. Just look at Photobucket. And every web site that makes you whitelist them in your ad-blocker before you can continue.

The latest in a line of what-used-to-be-free but is now tightening its belt is LastPass, an excellent password manager that has a lot of users but may end up with a good few fewer. The day after the Ides of March, LastPass Free will only allow use on a single device type, so if you currently use it to sync passwords across desktops and tablets or mobiles, then you need to start paying (and maybe you should) or stick to either mobile or desktop.

As soon as the company announced its plans, the web sprung up many articles offering “what is the best alternative to…” type advice. Only a few weeks ago, ToW#561 espoused the virtues of cleaning up your passwords, featuring LastPass and also trailing some features that were coming to an alternative that you might already be using to provide 2 factor authentication on your phone – Microsoft Authenticator.

It’s fairly easy to switch to using Authenticator on your device to also sync passwords and to provide the Auto-Fill function which plugs in usernames/passwords not only to sites on your mobile browser but to other apps too. If you already have a load of passwords set up in LastPass or other locations, there are methods to export them and then import the data into Authenticator.

clip_image004

In the case of LastPass, you sign into the Vault (either through the browser plugin or directly on their website) and under Advanced Options, select the Export function. It will immediately drop a lastpass_export.csv file into your Downloads folder; be very careful with this file as it contains all your usernames & passwords in clear text.

clip_image006You can get these passwords into Authenticator either by copying the file to your phone (Not a Good Idea) and importing from there, or by installing the Microsoft Autofill extension for Chrome into Edge (remember, Edge is a Chromium browser under the hood), then click on Settings and choose the Import data feature.

Now navigate to your Downloads folder and choose the lastpass_export file. It might take a little while to complete, but when it’s done, make sure you go back to the Downloads folder and clip_image008hard-delete that CSV file (ie select the file, hold the SHIFT key down and press the Delete key – this makes sure it doesn’t go to the recycle bin). You definitely don’t want that file being left behind, or copied or synced anywhere that is not encrypted.

The LastPass browser extension (like other password managers) remains potentially useful on the desktop as it can help to sync passwords between profiles (eg the Work and Personal profile of Edge, if both have the extension installed and logged in using the same LastPass account), or even between browsers – in the cases you might want to use Chrome for some things and Edge for others.

Edge on the PC does have password sync capabilities, though not quite with the same level of flexibility –

clip_image012clip_image014

clip_image010

Edge will let you sync passwords, favourites etc if you’re using a Microsoft Account (eg outlook.com) for your Personal profile, and it may do if you have a Microsoft 365 account for your Work Profile.

In a twist of fate, if you pay for a Microsoft 365 Family or a small business environment rather than using the free Microsoft Account, your subscription lacks the Azure Information Protection feature that is required to allow syncing. In which case, a 3rd party password sync feature may be your best option, even if you choose to use Authenticator on your mobile device, and perhaps do a periodic export/import from LastPass to keep your mobile passwords in sync.

Or best of all, just install the Autofill extension into multiple profiles (or Edge & Chrome), signing into the extension using the same Microsoft Account, to keep the passwords in sync. Tidy.

568 – The Race for Space

clip_image001Nearly 60 years ago, JFK announced the intention to go to the moon, and the huge effort – at one point employing over 400,000 people – had to invent a load of technology to make it happen. The guidance computer on the Eagle module, for example, was the first digital portable computer, without which it would have been impossible for the landing to take place. Then there’s the old myth about how the Americans spent millions inventing a zero-gravity pen, whereas the Russians used a pencil…

The “space race” continued for some years afterwards (the US had Skylab in the 1970s and built the Shuttle, while the USSR built Mir, the first proper space station), before numerous countries decided to pool resources and build the International Space Station.

After unveiling Azure Space in late 2020, the 20th February 2021 – 35 years to the day after the first Mir mission – saw the launch of the ultimate in Edge devices, ensuring Azure reaches the ISS with HPE’s Spaceborne Computer-2. That will be furthest Cloud-Edge computing node until we finally become an interplanetary species, and once again leave the confines of low-Earth orbit.

Edge back on Earth

If you want to make the most of the space on your screen, you should try moving your Windows taskbar to the side rather than the bottom of the screen – follow the science – as it makes more efficient use of the screen real estate, especially if you have a big widescreen monitor. Open Taskbar settings here and choose Taskbar location.

If you’re a vertical taskbar fan, then you’ll like a new feature in the Edge browser, also designed to maximise the use of space – vertical tabs.

clip_image003If you’re the kind of user who has lots of tabs open at any one time, you’ll notice that the title of each tab is quickly lost when they are arrayed horizontally.

By enabling the vertical tabs feature, a single click will show them to the side of the browser window. Click the < caret to the top right of the tab list and they’ll collapse to icons only until you mouse over again, and the full width will be shown.

clip_image005The clip_image007 icon to the left of the horizontal tabs switches the display to vertical, and the icon at the top of the vertical list reverts to horizontal.

If you’re using the beta or dev version of Edge, you’ll be able to show the Vertical Tabs button in the Appearance section of the clip_image009settings:

To enable vertical tabs on the current public release, enter edge://flags/#edge-vertical-tabs into the address bar of the browser and switch on the “experimental” feature; you’ll have to restart the browser for it to take effect, but after that point you’re free to try switching the arrangement.

567 – Power Teams Apps

clip_image002The Power Platform – an umbrella term that encompasses a load of technology most often associated with business applications like Microsoft Dynamics – has some capabilities that are being increasingly surfaced to more end users, and which could see new ways of interacting with data and functionality that have traditionally been siloed in monolithic back-end applications.

The artist formerly known as Common Data Service was given a jazzy new name at Inspire 2020, before a sudden realisation that somebody else already owned that trademark, whereupon it was swiftly rebranded Dataverse. In essence, this makes it easy to provide access to a centralised, well-managed, secure data store for pretty much any kind of data, accessible to pretty much any type of app.

If you used Power Apps and Dataverse to build line-of-business applications, accessible via browser or mobile clients, there are licensing requirements you’d need to fulfil – but if you want to make a more simplified application that uses Teams as its front-end, then you could use Dataverse for Teams (briefly known as Project Oakdale, using Power Apps under the covers). Licensing for Dataverse for Teams is included in many Microsoft 365 subscriptions – for more details on licensing and what some of the limitations of its use are compared to a full-blown Dataverse environment, see here.

clip_image004As discussed in last week’s ToW, there is already a Viva Insights Teams app available and there will be more coming soon – in fact, there’s a dogfood Viva Connections app already, which shows the MSW homepage within Teams, under the app name “Microsoft”. If you’re in the “Microsoft” app and click again on its logo, a shortcut menu of supposedly commonly-accessed information services appears.

Thankfully, when you need to perform your weekly check on which policies have been updated – or which ones you may have breached this time – they’re only a couple of clicks away.

clip_image006There are hundreds of apps written for Teams – you can browse and search within the Teams client, or take a look on AppSource from a browser.

clip_image008It’s also possible to pin your favourite apps to the Teams sidebar, either by opening from the Apps function and then right-click the icon when it shows underneath the others on your side bar, or by simply dragging the icon to be higher on the bar – the assumption being that if you want to move that icon up the list, you’re probably looking to Pin it for the future.

clip_image010There are a couple of new “template” apps that have been released by Microsoft, using Dataverse for Teams, and customisable using the simplified Power Apps editor within.

The Bulletin and Milestones apps are available now.