Tip o’ the Week 484 – Saving Office 365 profile pics

Posted on June 30, 2019 by ewand

Office 365 users will be familiar with the Profile Picture that appears in multiple places, most visibly in Outlook and Teams. Just like their picture on LinkedIn, many users will help people understand what they look like by posting an actual photo of themselves, whereas some will insist on posting a photo of their dog, or their kids, or themselves wearing a hat and shades while standing very far away.

There’s supposedly a lot that your choice of profile picture says about you. There’s a tabloid version (akin to the “What Your Horoscope Says About Your Pet” style nonsense more often to be found on the Edge browser homepage). There are some more scientific resources with views on what people think when they see your picture, and some hints on how to choose the right one. Some fun examples of what not to do could be illuminating.

Facing left-to-right is supposedly best – maybe it makes you look more powerful, or simply, when your photo is on the left side of a load of content (like the details of your LinkedIn profile), then it’s better to be looking toward it rather than away to the left… Similarly, good advice is to stick to a head-and-shoulders shot, or at least waist-up – if your profile pic is your visible brand on LinkedIn and Office 365, then there’s no point in using a photo that shows your face as too small for anyone to recognise you.

How to save photos from Office 365

This tip will probably become obsolete at some future update on O365, such is the march of innovation, but it deals with how you can get to the profile photo that someone else in your organisation has published. The inspiration came from a departmental admin who was trying to build a nice org chart, and had to repeatedly nag members of the team to share a photo of themselves. It can also prove handy when someone has posted a photo of themselves that’s too small to see – if you can open the photo up in a browser, it can show you the original full-resolution image, and you can always use the browser to zoom in, too.

Start by going to the Office home page and sign in; you can then search for someone’s name and click on the People tab for the detailed results.

An even quicker way might be to go to https://www.office.com/search/people?auth=2&q=<name> and follow the q= with the name you want to search for.

When you have the results of the search, hover over the thumbnail of the person’s profile pic, and in the pop-up that appears, right-click on the slightly larger image.

If you’re using classic Edge, then you’ll be able to save the image locally, but if you’re on Chrome or the new Edge Dev browser, then you’ll easily be able to copy a link to it – paste that into a new browser tab, and you’ll get the full-size version of the profile pic so you can zoom in, save it, draw moustaches on it with your Surface Pen and so on.

Tip o’ the Week 483 – mobile OCR and Office

Posted on June 7, 2019 by ewand

Optical Character Recognition is one of those technologies which has gone from being just-about-possible at great expense and hassle, to so mainstream that people just assume it will work flawlessly, all in a relatively few years. Numerous companies offer OCR services or addins to line-of-business systems which help to prepare printed data for easier consumption – scanning invoices for example.

Consumers tend to use OCR in other ways; combined with language translation, you can point your phone at a foreign menu or sign and it may be able to help you understand. In OneNote, if you have captured an image (maybe through the clipper addin from your browser), then it can extract the text from that picture – not always perfectly, and not necessarily well-formatted, but it’s probably quicker than re-typing everything.

Near OCR functionality is also pervading the slew of freely available Office apps for Android tablets, phones and even Chromebooks, and similar versions for iPad and iPhone.

A recent addition to the iOS version of Excel is the ability to scan a table of printed data and use OCR plus a bit of tweaking, to import the data into the spreadsheet. See more here. The same functionality was first made available on Android a couple of months earlier …

Start with the grid capture icon on the toolbar of a new spreadsheet, and then use the camera to highlight the area of a document that you’re interested in – the UI will be familiar to anyone who uses Office Lens, as the same anti-skewing technology is used to prepare the “document” for importing.

Then the OCR goes to work and tries to lay out the data as closely as possible to its source – obviously, your accuracy will be improved by having a well-lit and clear original document, and you’ll get to tweak the contents in context of seeing the OCR’d data and the scan at the same time, before committing to insert it.

Tip o’ the Week 481 – Lost in Translation

Posted on May 31, 2019 by ewand

Bill Gates had a vision of the future, set out in his 1995 tome, “The Road Ahead” (and later in “Business @ The Speed of Thought”) which included computers performing seamless speech and handwriting recognition, and language understanding (even to the extent of lip reading). Many of his predictions have come true yet it’s easy to forget what the world was like before the advent of technology we now take for granted.

In the not-too distant future, we may have the ability, babel fish-like, to automatically hear in our own language, regardless of what is spoken. Institutions like the EU have thousands of translators and interpreters, who provide written, spoken and signed interpretation between different languages. There are rigorous checks in place when trying to get work in these areas (though not everywhere), as we all know what can happen when wrong grammar is used, the words are unsuitable, or punctuation is in the incorrect place.

Computerised language translation has come a long way, and though it may still a way off replacing real translators, it’s good enough for most people to get the gist of a foreign document or website – so while you might not rely on it to turn a contract from French to English, it’s fine to figure out what’s on a menu or read some instructions.

There are plenty of mobile apps and websites like Bing Translator, and the cloud-powered translation service is built-into Word (just right-click and Translate on any text).

Microsoft Research Asia recently won a competition for the best machine translation between a host of languages, and the growing fidelity of AI models is helping to improve the quality – a year previously, the Chinese-English translation was adjudged to be at human conversation level already, so it might not be too long before machine translation gets good enough that it’s hard to tell the difference between that and humans.

A practical tip for users of the new Chromium-based “Edge Dev” browser; you can enable on-the-fly webpage translation by going to edge://flags/, search for trans to find the translation flag, then switch it on and restart the browser. It is an experimental feature, technically, so YMMV for now.

Now, when you browse to a foreign-language site, you’ll be prompted if you’d like to translate (or you can invoke the function using the Bing Translator icon to the right of the address in the toolbar).

Legacy Edge users can install the Translator extension.

As they say in translation circles, Yandelvayasna grldenwi stravenka!

Tip o’ the Week 478 – O365 and Windows’ Mail and Calendar

Posted on May 8, 2019 by ewand

On the mobile platforms that still survive, the highly-regarded and rightly popular “Outlook” mobile apps have no relation to the Outlook desktop Windows app which first appeared with Office 97, before smartphones were a glint in anyone’s eye. Mobile Outlook has hundreds of millions of downloads on both iOS and Android; quite a feat, as later this year Windows Mobile sinks quietly beneath the waves.

The genesis of Outlook on the phone as we know it today, is perhaps the acquisition of a company called Accompli 5 years ago, and a great deal of refinement and effort since.

Somewhat interestingly, traces of the same app have come to Windows as well – namely the Mail and Calendar app(s) that are in the box on Windows 10. Look back to ToW 445, and you’ll see that the names for the apps are outlookcal, outlookmail and outlookaccounts. Stick a “:” on the end and you can run them from a prompt.

e.g. Hit WindowsKey+R then enter outlookcal: and you’ll jump straight into the Calendar app.

Both have come a very long way – at first release, they were pretty basic, but they’re now so well featured that most people could use them as their primary email and calendar apps, most of the time.

The Calendar app is functionally pretty similar to the Outlook desktop app, except when it comes to working with other people – there’s no way to view someone else’s calendar, for example, but for a personal diary of appointments it’s really very good. And if you want the best of both worlds, you can connect your Office 365 account to both Outlook – as might be your primary way of working – and to the Mail and Calendar apps, for some side benefits and quicker ways of getting some things done.

Go into the settings on the Calendar app, then Manage accounts, then + Add account… or just Win+R then outlookaccounts: and you’ll be able to add your Office 365 account onto both Mail and Calendar.

If you have multiple calendars connected – like home Office 365, Gmail or Outllook.com accounts as well as your corporate one – you could selectively enable them for display in the app, and the set of calendars that are shown will also appear in the agenda if you click on the clock / date on your taskbar. You can also see your upcoming appointments in a live tile on the Start menu, if you still use such things.

You’ll also see your next appointment on the Windows Lock Screen if you have it enabled under Lock screen settings.

You may want to go into the Notifications & actions settings page (just press Start and begin typing notif…) and turning off Calendar notifications, or you’ll get a blizzard of reminders from desktop Outlook and the Calendar app.

Tip o’ the Week 474 – Parse and Flow

Posted on April 5, 2019 by ewand

Microsoft Flow was introduced a couple of years ago, and covered in ToW #401; it’s basically a glue between different online applications, allowing the exchange of data between them and being driven by events and actions.

Sign up, sign in, and when you go to create a new Flow, you can start with a blank canvas, or by customising a pre-built template, of which there are many.

Learn how to build Flows here.

Many of the templates for Flow are quite esoteric – when a tweet on a particular topic appears, write a log to a Sharepoint site and send a notification to a Teams channel, that kind of thing. But there are plenty of really useful connectors that can be combined in time-saving ways; here’s a really handy way of bringing traditional data sources into the modern era: an email parser, called Parserr.

After signing up with Parserr – free if you only need a few uses per month – you can then crack open mail that is consistent in format and contains some information you’d like to extract and use elsewhere, such as confirmation of an appointment or maybe a travel booking. In practice, you get given an inbox with a unique email address within Parserr and you’d set up a rule in Office365 or Outlook.com to send mails that meet some inbox rule to that address, where it would be parsed for you and key data fields then sent back to Flow.

e.g. if email comes from a specific source address or it has a subject that indicates it’s a particular type of reservation, then forward to your nnnnn@mg.parserr.com inbox address, extract the details of the booking then do something with them within Flow.

Start by sending an example mail to your Parserr inbox, then you can define rules to identify content within it (by looking for set keywords, going to specific line numbers and so on).

Create a rule for each piece of information you want to extract, and it will effectively create a field:

Once set up, you create the Flow by choosing the connectors for Parserr and whatever other applications you need to work on the information.

In this example, we’re using Office 365 to create an appointment that matches a reservation – the arrival and departure dates are provided by the source email, and converted to YYYY-MM-DD format within Parserr, then dragged across in Flow to match the Start & End times of an “event”. We’ll tack on T16:00 to the arrival time and T10:00 to the departure as that’s the check in and check out times, and thus create an ISO8601-compliant date/time such as 2019-04-05T08:00, which Office365 will use as the start or end time of an appointment.

“Advanced options” gives you further control (such as adding body text that might contain static text and other fields provided by Parserr, other addresses to forward the invite to, setting if you want it to be free/busy/tentative, reminder duration, time zones etc).

And that’s it: you can test the logic is working within each system – in Parserr, you can continually re-run the processing of your initial sample mail until you know the data is being extracted as you’d like, and within Flow you can keep testing your formatting etc by either triggering a new input or by working with the last set of data that came over from the source.

Once you’re happy just save the Flow, and it will automatically create an appointment in your calendar every time you get a matching email forwarded to the Parserr system – all in a few seconds.

See more on using Parserr with Flow and here’s a worked example.

Tip o’ the Week 473 – Teams Shortcuts

Posted on April 5, 2019 by ewand

Many people who rely on the same applications to do repetitive tasks, will want to learn quicker ways of doing them – and use shortcut keys to good effect. Shortcuts have been covered in ToW previously – eg. how to start modern apps quickly, or navigating between running apps.

As world+dog moves from internal corporate email to Teams, Slack etc, it’s handy to know how to get the best out of the new messaging environment. Before abandoning Outlook already, here’s a reminder of some especially useful shortcut keys:

CTRL-2 – jumps to Calendar; useful if you’re in mail and want to quickly check something in the diary.
CTRL-1 – sets focus to “mail” – whatever folder you were looking at before moving away to check your calendar etc. CTRL-SHIFT-i will jump to your Inbox regardless of where you are in the UI (eg you might be in another mail folder, or looking at Calendar/Tasks etc)
CTRL-3 – jumps to Contacts (or “People” as Outlook now calls it)
CTRL-4 – jump to Tasks.
CTRL-5, -6, -7 and -8 will take you to long-dead Outlook features. Try them. Take a teary trip down memory lane.

And there are lots and lots more.

When it comes to using Teams, one of the most useful shortcut tips is essentially the same as the Outlook set above – CTRL-number takes you to one of the nodes on the side-bar that corresponds to the number from the top – eg CTRL-4 will jump to Meetings, which is handy if you have Teams calls in you calendar and want to join the calls from there rather than Outlook.

Incidentally, if you normally go into an appointment in Outlook and click the “Join Teams Meeting” link in the text body, you may tire of continually telling Outlook that yes, you did mean to switch applications, and it’s OK, you already have the desktop app…

Click the “Join Teams Meeting” icon on the Ribbon in Outlook instead, and you’ll skip this. If you’re super-skilful then you can jump straight to that command without lifting your fingers from the keyboard – just press the ALT key and you’ll see shortcut letters appear under each of the sections of the Ribbon; press the corresponding one (“H” if you’ve opened the meeting up in Outlook already), and you’ll then see a letter combo that will activate the Ribbon commands – Y1 in this case will jump straight into the meeting.

There are many other shortcuts in Teams, with varying degrees of usefulness. Customising the UI is still a bit clunky (eg you can’t add shortcuts straight to the sidebar or move items on it up and down) but you may be able to find a quick way of doing the things you need most. To see a summary of shortcut keys whilst in teams, just press CTRL-. (ie CTRL and full stop/period ‘.’).

Tip o’ the Week 469 – To-Do Files and Accounts

Posted on March 22, 2019 by ewand

ToW has featured Wunderlist and To-Do on a number of occasions; it’s good to see new functionality being added to the To-Do app & service, and the hits just keep on coming. If you haven’t tried it out yet, get To-Do from the Store, or just play with it online. Install it on your phone, too – fruit | robot.

Recently, the Windows To-Do app was updated with a couple of key features, including the ability to add files (up to 25Mb in size) to items – though not yet if your list is shared.

It’s also now possible to add multiple accounts to the Windows To-Do app; so you can have several Office 365 or personal Microsoft Accounts – and switch between them without needing to sign out and in again. Maybe something that Teams could aspire to…

To keep up with further news, check out the To-Do blog, or the Twitter account.

Tip o’ the Week 467 – Gardyloo, It’s the News!

Posted on February 15, 2019 by ewand

Edinburghers will know of the term, “Gardyloo” – perhaps a corruption of a French warning that “water” was about to need avoiding, like dodging the gutters in Blackadder. As well as regarding the loos, it’s in everyone’s interest to make sure your source of news is clean and fresh. Not fake.

A startup called NewsGuard hit the, er, news recently, after launching a service that uses real journalists to assesses sources of news, and scores them on various criteria on how they source, handle and attribute the stories they report.

The Mobile version of Edge browser was updated in January 2019, to include the NewsGuard plugin (though it wasn’t enabled by default), and at the time it was widely reported that their vetting had decided the UK’s Daily Mail, a popular newspaper and at one time the largest newspaper website in the world, was not to be trusted. (Screenshots above & right were taken on 24 Jan 2019).

More people probably read about the warning that was gleefully propagated by the Mail’s competitors, than there are actual users of the Edge mobile browser itself (if you use Edge on your PC, give it a try on your phone – it’s really rather good).

If you’d like to add the NewsGuard addin to the Edge browser on your PC, go to the Settings menu (…) on the top right of the Edge toolbar, and look under Extensions – then find NewsGuard in the Store to add it to the browser from there.

NewsGuard has since worked with the Daily Mail and decided that it’s not quite as bad as all that, so has backtracked and removed the klaxon warning.

It’s still not giving a completely clean bill of health – see the “nutrition label” – but the feedback NewsGuard has shared with some other news websites may well help to improve the quality of their output.

The same extension is available on other browsers too.

Tip o’ the Week 466 – Mobile Teams Tips

Posted on February 15, 2019 by ewand

Teams is more than just a replacement for Skype for Business on your PC, it’s also a consummate mobile app that functionally eclipses its predecessor in many ways, and even its desktop sibling in some. If you haven’t installed the Teams mobile app on your phone, go and get it (and other Office apps) for Googly Devices or Fruity Phones. The remaining Windows Phone users can follow the setup link here, though be prepared for disappointment.

The “Calls” tab on the mobile version on the app is more usable in some senses than Calls on the PC version of Teams is, since it exposes phone numbers more easily. On the desktop Teams app, if you want to use the service to call an existing contact via the POTS, the actual phone number you use can at times be somewhat obscured.

On the PC app, for example, if you look at History, you’ll often seen a list of people but it’s not clear which number they called from (or you called them on), and you’ll need to use the Contacts list within Calls to be able to direct a new call to a specific number.

In the Teams mobile app, if you look at the Calls tab, under History, tap on a line and then the card to the right side of the list of icons, you’ll get a contact card and the ability to respond back – using Teams – to any one of the listed phone numbers.

Under Settings, you also get a bit more direct control over do not disturb functionality with quiet hours and days.

Finally, one of the great new functions in Teams mobile is the building-in of Org Chart functions, so you can browse the global address list hierarchy while on the move (assuming such info is populated in the directory).

Just search for a contact’s name, and their organisational tree is only a tap away.

For more tips on using Teams Mobile, see here.

Tip o’ the Week 465 – Cortana, remind me To-Do sync

Posted on February 4, 2019 by ewand

The ongoing post-Wunderlist improvements to To-Do, continue apace. The app has been updated again recently, to include a bunch of additional functionality, like Cortana integration.

In fact, the Store listing name for To-Do is now appended with some additional context of what it can now do, at least if your language is English and you’re in US, UK, India or Australia.

By asking Cortana to remind you of something, she’ll add it to your Outlook Tasks and To-Do reminders – if you’re set up that way – and you can manage lists within the To-Do app itself, or access the same To-Do Lists or Reminders from within the Cortana Notebook.

You don’t even need to go into the Cortana UI (or say “Hey Cortana”) to add things to be reminded – any app that implements Share functionality, like the Edge browser’s Share page toolbar command – will let you target Cortana Reminders.

You can set a reminder time, which will then sync to Outlook Tasks and on to To-Do, if you’ve set up Office 365 or Outlook.com integration, and will trigger a reminder using those mechanisms (get ready for toast overload…) Alternatively, get Cortana to ping you when you arrive at a place or next talk with a known contact.

Cortana’s past tells a good story, and her future is changing somewhat – after deciding to stop positioning her as a potential competitor to Amazon Alexa or Google assistants, a forthcoming release of Windows 10 will break the bond between Windows Search & Cortana, and the voice prompts from Cortana during Windows Setup will be silenced when installing a non-Home version of Windows too.