543 – Dynamics CRM and Outlook

Customer Relationship Management or Customer Engagement, whatever you call it, is a huge part of the IT industry, powering repeated companies to multi-billion dollar valuations. CRM gives companies a way of tracking customer touch points and connecting people together, powering sales teams to track their opportunities and leads, as well as a way of managing GDPR compliance with respect to contact information.

clip_image003Evolving from personal and then group contact management software in the 1980s, CRM came of age in 1995, with Oracle refugee Tom Siebel establishing Siebel Systems as the early market leader, and eventually acquired by Oracle.

clip_image004 Microsoft deployed Siebel in the late 1990s, initially requiring a “fat client” installation complete with a local Sybase SQL Server on everyone’s PC, so they could sync data from the central Siebel system, then eventually moving to be browser-based. One MS sales manager coined the moniker “IIIInSIDE” – If It Isn’t In Siebel, It Doesn’t Exist – giving sales people nowhere to hide when it came to reporting pipeline of opportunities they were tracking.

Mark Benioff, another ex-Oracle exec, set up Salesforce.com in 1999 to not only establish SaaS as a viable way to deliver “line of business” systems (as part of the first Application Service Provider boom, which was largely wiped out by Dot Bomb), but to ultimately eclipse his former employer in terms of market value. Time also moves on – now that Salesforce is the big dog in the CRM world, there are lots of competitors snapping at its heels… Pega, Zoho and many more.

Not least, Microsoft – the Dynamics CRM business (now part of Dynamics 365 Customer Engagement) is growing fast, and even courted the “Father of CRM” to choose D365 for his new enterprise. If you use Microsoft’s Dynamics 365 CRM as part of your job, and use Outlook on your PC for mail, calendaring and contacts, there’s a handy way of connecting the two.

Dynamics Connector for Outlook

There have been several versions of a way to link Outlook and Dynamics together; the latest, Dynamics 365 App for Outlook, will fully supplant earlier versions in October 2020. See the admin guide for more on what the connector does and how it works. The installation can be a little clunky first time, though – you’ll need to install the connector software from here, which starts by downloading and extracting the setup files to a folder on your PC.

Make sure you’re getting the right version for your copy of Office – to check, in Outlook, go to File | Office Account | About Outlook and look to see if you have 32 or 64 bit version installed.

clip_image006If the latter, download the amd64 version of the client and the first major update package, otherwise download the i386 one.


Once you have the base version installed (a process which takes a good few minutes: you also have the option to enable offline usage, which means setting up a local database to hold the content), don’t bother starting it yet – go straight ahead and run the update to the current version (strangely, a larger download than the original install). Once that’s downloaded and installed, you’ll need to restart Outlook if it’s running.

clip_image012On first run, enter the normal URL you’d use to access CRM – after a few minutes of configuring the addin you should be good to go.

You’ll see a new Dynamics 365 tab on the main menu, offering a variety of CRM-specific activities.

clip_image014Arguably, one of the most useful and obvious (given that you use this data all the time in mail) is managing contacts for your customers – Outlook is a great way of pushing them into CRM.

clip_image016clip_image018Start with an email – the Dynamics 365 app adds context-sensitive commands to the Outlook UI, so with a couple of clicks you can track an email in CRM – copying its contents into the Account record, so others can see that you sent or received it.

clip_image020If you right-click on an email address in a message, calendar appointment etc, and Add to Contacts, you can then sync that with Dynamics in a couple of clicks…


… meaning there’s no excuse to not have your important contacts listed in CRM.

You can even match the contacts’ LinkedIn profiles, and create an org chart of all the listed contacts.

542 –Excel Special Paste

Anyone who spends an amount of time preparing spreadsheets in Excel, will be familiar with the frustrations that can come from cut, copy & paste. You need to know what the source of a cell is before you know how it will behave if you copy and paste it somewhere else, even to another sheet.

As an example, if you took the small table below and wanted to copy and paste the calculated values on row 4, you’d need to deal with the fact that the formula will change – offsetting the D and the 2 reference to wherever you paste it (eg if you pasted the copy into E4, the formula would be =E2-E3) – normally, a powerful and useful function, but a potential nuisance.

clip_image004You could decide to paste just the value itself (which means that if the values in D2 and D3 changed, cell D4 would be recalculated but your copy would not), or you could copy the cell, then copy original cell’s formula and paste that into the formula of the destination cell.

clip_image006There are lots of “Paste Special” options, which will vary depending on what kind of data is in the clipboard. Right-click in a destination cell and the Paste Options menu will surface the commonly used variants, or click the arrow by Paste clip_image008Special to see all the others. Move the mouse over that pop-up menu and the rest will fade away.

An older UI for selecting the options is available if you click on the Paste Special… command at the bottom of the pop-out, or by pressing CTRL+ALT+V to pop out the Special dialog.


One of the more particularly useful features of Paste Special in Excel is the Transpose option – if you select and Copy a row of data then Paste / Transpose it, the data is rearranged as a column (and vice versa). Great news in many cases, but if you want to paste cells and keep the original formulae (without resorting to using absolute references formula references using $ in the formula itself, eg setting =$D$2-$D$3), there are no default options to transpose the orientation of the cells but not change the  formulae.


One trick if you ever find yourself in this position, is to bulk change the formulas so they won’t get modified when you paste the cells; do a Find & Replace to change = to something like #=.

After pasting and transposing, reverse the process to restore the formulaclip_image014.

clip_image016NB: this can be a little hit and miss depending on how you’re using cell names or references – you may find that it’s more reliable if the reference is made to a cell on a different worksheet.

It’s an edge case but could save you lots of time if you need to do it.

For most of us, getting to grips with shortcut keys in Excel would make things more productive – as well as numerous combos of CTRL-something, there are simple keys (like pressing F4, which repeats the very last command … so if you’ve just coloured a cell yellow, move the cursor to another cell and hit F4 to make that one yellow too… if you’re doing very repetitive things, this can save so much time).

There are also more complex sequences; press the ALT key in Excel (and other Office apps, too) to see the key combos that clip_image018invoke each command group on menus or the Ribbon – if you can’t remember the shortcut, just press ALT then the key for the menu you want, then the key on the menu that equates to the command you’re looking for.


A little bit of legacy/history – press ALT-E then S to jump to the Paste Special menu – why E? Even though it’s long gone, really old versions of Excel had an Edit menu, and the commands on any menu – in any application – that have an underscore under a letter (like Paste Special) are highlighting the key you can press to jump to that command.

So ALT E / S used to be the combo to get Paste Special circa Excel 2003, and it still exists today.

541 – shrtn ur url

clip_image002We’ve all been in the position when sharing a web link with someone reveals a URL that is several lines long and full of hexadecimal IDs and so on. There are a few ways to make the long URL more acceptable – a simple one being to hot-link the URL under a piece of text.

In most email programs, in Word, and even in the new Yammer experience and some other web forum software, selecting some text and pressing CTRL-K lets you insert a URL under that text – so rather than saying “Flight Simulator – https://www.xbox.com/en-US/games/microsoft-flight-simulator”, you could just write Flight Simulator”.

When it comes to sharing URLs with other people, though, you might still need the native URL clip_image004rather than copying the text that has been hyperlinked, so in many apps and websites you could right-click a hyperlink and grab the URL (or in Office apps, again, put your cursor on the text and press CTRL-K to get the edit UI which would also let you put it on the clipboard).

clip_image006It’s both easier to share and also to remember shorter URLs with simple names, but URLs for linking directly to a web forum discussion or Yammer post (in the new Yammer, click on the 3-dot icon to the side of a post to get the link directly) tend to be cumbersome and with lots of references within.

The first URL Shortening service was launched in 2002, tinyurl.com (and doesn’t the website look like a 2002 site?). The basic idea was that instead of having a 200-character URL, you could generate something that would have the form of the tinyurl domain and a random series of characters, such as https://tinyurl.com/yxtj4gft.

When the user clicks the link, their browser goes to the TinyURL website and is then provided the full link to follow, and redirects to that. The primary benefit was to make it easier to share the URL, even if it’s not so memorable, however the developers later added the ability to provide a custom redirect name and, as long as nobody else has nabbed it first, you can use it – eg https://tinyurl.com/yammerofficespace.

TinyURL has been overtaken by others, notably bit.ly, which Twitter switched to from having previously used TinyURL, and before later launching its own t.co. There are many others too, some connected with existing services – like the onedrive.com shortener (eg https://1drv.ms/u/s!AgMogCiKiWDFraIfifRzFKdjw4F1uQ?e=Yepjwh) which isn’t really very short, and which causes Bit.ly to get its Alans in a twist, as it seems it doesn’t like to shorten another shortener’s link.

There are some downsides to using this kind of service, potentially. What happens if the provider goes bust, or decides to start charging users where it was once free? Sites like Photobucket which started free but began charging users a “ransom” get internet warriors hot under the collar, but so far, sites like TinyURL and it’s progeny are mostly still free to use, with the operators selling aggregate data about the referrals being followed to fund their operations costs.

Some shorteners decide to close down – like goo.gl – meaning there’s a risk that previously-shared short URLs won’t work in future (though in the case of Google’s shortener, they are keeping old links alive, just not allowing any new ones to be created). Similarly, if a shortener has a technical problem or security breach, it could affect the way it works – TinyURL reportedly having problems just this week.

clip_image008Finally, a web shortener that is unlikely to disappear overnight is operated by Microsoft, called aka.ms. Anyone from Microsoft can create an aka.ms shortlink – subject to some rules – as long as they share responsibility with someone else. Like the other public shortener services, can generate a random series of characters or can provide the “target” part of the link if they like.

All aka.ms links are by definition publicly accessible, but many are used to get access to sites that are for internal use, even though they exist beyond the firewall – Sharepoint sites, for example, or the intranet homepage, aka.ms/msw. Anyone could resolve the destination URL – even en masse as one enterprise developer has done, using Azure functions – but you still need to provide appropriate credentials to access the destination site.

540 – All Together Now

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

Jared also announced Team Room services (more on rooms.microsoft.com), providing a management and monitoring service for physical rooms that are equipped with Teams kit, as well as the performance of the meeting space. The intent is to make the meeting experience better when we have a mix of in-person and remote people, as the world transitions to some kind of normality.

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


It takes some getting used to, especially if the meeting is one where there’s a predominant speaker – like a teacher – who appears in one of the chairs in the room rather than separate from it. Also, you might have some people who sit relatively close to their camera and will appear huge, while others look like they’d be sitting with feet dangling in the air.

To learn more about how to use Together Mode, and for some info on what is planned for the future, see here.

539 – Outlook calendaring fun

clip_image002Pretty much everyone who uses the Office productivity suite probably relies on Outlook for not just the daily splurge of email, but for organising their activity either by tasks, flags or just putting stuff in their calendar.

Here are a few simple tricks to remember when working with your calendar:

  • You can move to Calendar in Outlook by pressing CTRL+2 anywhere in Outlook – if you’re trying to organise meetings for lots of people and need to keep flicking between mail and calendar views, this can save you so much time (CTRL+1 for mail, CTRL+3 for contacts etc – try the rest of the numbers out for a trip down memory lane). Even the clunky old Notes function in Outlook now synchronises with Sticky Notes.

  • CTRL+T always takes you to Today, or if you have the Ribbon showing, you can click Today there clip_image006– though an update to Calendar’s UI which was shipped to M365 subscribers in March, also added a Today button at the top left of the main calendar view, as well as a few other tweaks.
  • CTRL+G launches an old-school dialog that lets you jump to a specific day – and lets you choose from a date picker, or type the date in if you prefer. Like lots of other old-school date dialogs in Office apps, you can enter certain natural language clip_image008phrases too – some like next month, 3 weeks, will be relative from today’s date, others like June will take you to today’s day in that month (try it out; it’s easier to see than to explain) and there are certain special days like Christmas where it will jump to the next occurrence. See ToW #291 from nearly 5 years ago for more date tips. For multi-lingual dates and other stuff, see here.
  • clip_image010Manage Time Zones – at this time of year, some of us would ordinarily be planning holidays involving travel to foreign climes, but not so much in 2020. There’s every likelihood of planning online meetings in other time zones while you’re sitting in your own office in the middle of the night – so it’s worth adding multiple time zones to your Outlook Calendar view and labelling them. Right-click on the time bar to the left of your calendar view, and choose Change Time Zone to manage the display of time zones, or even switch your whole PC between them quickly.
    The rather nice Windows 10 Alarms & Clock application (WinKey+R then ms-clock: if you don’t like to click) has a nifty display of multiple time zones if you like to see at a glance where and when everyone is.
  • Colour-coding appointments is another favourite tip the super-organised use. You can right-click on any clip_image013appointment to colour it by setting a Category, or you can use Conditional Formatting on a view to colour appointments based on category – like who sent it, or what location it’s in, etc. See more here.
    If you’re feeling extra-brave, you could install a special form that lets you differentiate mail – and therefore, appointments – which originated from an external source, by exposing a hidden property. This allows you to automatically colour them differently.
    Delve into ToW #275 to install the form, then set up a Condition under the Calendar view in much the same way.

538 – OneDrive updates

clip_image002If you’ve been a PC user and part of Microsoft ecosystem for any amount of time, you’ll have been exposed to a variety of services and products which have come and gone, or at least changed names on occasion. OneDrive is a great example – initially unveiled as Windows Live Folders in 2007, the consumer cloud storage service spent a while under the brand name SkyDrive until an agreement was reached with satellite TV broadcaster Sky, to change the name – and so, OneDrive it has been since 2014.

Along the way quite a few associated names and services have bitten the dust – Microsofties celebrate/commemorate old products on the Next of Kin Yammer group: raise a glass to OneCare (an unfortunate name choice if you’re a Cockney, ain’t that Irish Stew), and all manner of other products that turned out to be Red Shirt / Non-speaking parts, like MSN Music/Zune Music/Xbox Music/Groove, and now Mixer.

If you still have a “SkyDrive Camera Roll” folder in your OneDrive storage, that’s probably a legacy of having synced photos from a Windows Phone and then later having installed OneDrive on your modern mobile. You can rename the folder to something else now – at one point, it was not supported but that’s no longer the case.

Using OneDrive on the move makes a lot of sense – even if only to back-up photos from your phone. The web UI lets you see the pictures in a variety of interesting ways, showing the places you’ve been or the things you’ve photographed.

In OneDrive for consumers, you get 5GB of free storage on signing upnot bad, but Google Drive gives you 3 clip_image004times as much for free – though you can add lots more online storage to both services by either coughing up the readies to buy a TB or two, or in the case of OneDrive, signing up for an Office 365 a Microsoft 365 subscription, such as 365 Personal, which gives you 1TB, or 365 Family which gives 1TB each, for up to 6 people.

The pricing is such that unless you wanted to buy only a few extra GB, it makes sense to go for the M365 option – £60 a year for a personal subscription that gives a 1TB (ie 1000Gb) storage capacity, or pay £24/year per 100GB block if you want to buy storage on its own and forego the other stuff you get with M365, notably the Office apps.

Despite a bit of confusion over what the differences are between OneDrive for Business and OneDrive (not described as for business, so presumably for home/personal use), it continues to evolve with additional capabilities – as covered in ToW passim. The OneDrive for Business / Sharepoint and OneDrive for clip_image006consumer technologies are blending together to the point where they look and feel very similar.

Now, the OneDrive team has unveiled a slew of new features for both ODfB and OneDrive personal – like Dark Mode on the web client, or the ability to share files and folders more easily with colleagues, or share with family and friends by creating groups of people who will be sent an invitation to view and contribute.

And the upload file size limit has been raised from 15GB to a whopping 100GB.

537 – Teams Mute shortcut

clip_image002We’ve all been there. Either as the source of background distraction on a Teams call, or one of the participants perhaps wondering how best to handle it. Sometimes it’s better to intervene if you can see who’s doing the heavy breathing or who’s sitting in a noisy environment, rather than making a fuss about it.

clip_image004If you show the participant list during a team call, you’ll see who is muted, and depending on your own role in the meeting, you can mute others who might be unwittingly generating noise (identifiable by the “halo” surrounding their profile picture or initials, which flickers as they talk or as their mic picks up other sounds). The Organiser or any Presenter in the meeting can mute anyone else.

Muting a participant displays a notification in their Teams client to the effect that they have been shushed and can unmute themselves, and if they’re dialled in, they’ll be told by an announcer that they’ve been muted and told how to unmute themselves.

The person who’s been quietened doesn’t know who did the deed (one feature request is to log who’s doing it, as there have been reports of miscreants randomly muting and booting out participants from virtual classrooms during lockdown). If you’ve already muted a participant (or even all participants), it’s not possible to unmute anyone – only they can control that process, since an organiser unmuting someone could put them in an awkward position (#poorJennifer again?).

There are requests to allow finer control of muting in some circs, though – preventing people from unmuting unless given permission, for example – in a large meeting, it could be better to police Q&A by asking people to “raise their hand”, and only allow them to unmute when the presenter virtually gives them the mic.

If you’re going to do a load of noisy typing whilst on a call, one trick to memorise is to flick the focus from OneNote/Outlook/whatever to Teams by quickly tapping ALT+TAB, then tap CTRL+SHIFT+M to mute and unmute yourself – this is probably a lot quicker than trying to click the microphone icon within the Teams app.

Anyway, enough about muting – time to go make some noise. Have a great weekend!

536 – Spreading to friends and family

clip_image002There have been plenty of ToW missives over the last few months on the subject of remote working, video conferencing and the like. Businesses who have Microsoft 365 – the new umbrella name that includes Office 365 – already have access to Teams, though personal users and non-subscribers could still set up a free version.

Other chat, video and collaboration tools have clearly been finding many new users during the COVID-19 lockdown…

Slack, which established itself as a texty business collaboration tool (especially in the technology industry), has been overtaken somewhat by the rush to video calling and meeting. Slack’s partner AWS, who also have a video/audio/chat service called Chime, announced plans to integrate under the covers. Meanwhile, Slack thinks it’s finally time to ditch email and their CEO also has an interesting take on how remote working will evolve – will this be the end of the real estate bubble in the Bay Area, for example?

Salesforce has launched a new offering called Anywhere, which aims to take back collaboration and comms tasks from Slack or Teams. And in the “you can tell any story you like by using the right set of numbers” file, Teams has been reported as outgrowing the media’s darling, Zoom, as the feature battles between the two have intensified. Skype and Google’s Hangouts Meet have also added multi-party video among other new capabilities.

Teams will soon have the ability to show up to 49 people at once (having rolled out a 3×3 grid of video windows recently)…


… and has also released an updated free offer, aimed at friends and family communications.

Initially available in the mobile apps, the focus is on providing free collaborative functionality for groups you can set up, as well as being able to schedule video calls and meetings.

If you don’t already have the Teams mobileclip_image004 app on your phone, then go to iOS App Store or Google Play to install it. If you’re already using Teams through your work account, you can add a personal account by going to the settings icon in the top left, and at the very bottom of the list is “Add Account”.

This will guide you through the process of associating with an existing Microsoft Account, including signing up for free Teams service if you haven’t already.

At the moment, the service is in Preview, and it does involve switching between profiles when you need to, but offers a load more than just WhatsApp-style text chat and the odd call.

As well as file sharing, there’s even a “Safe” feature on its way, which will let you share WiFi Passwords or other more sensitive information that requires 2-factor authentication.

So, for once in the last 3+ months, now’s a good time to spread something to the rest of your family and your wider circle of friends…

535 – Switching monitors

clip_image002Now that monitors are relatively cheap, having more than one display on a PC – and the productivity benefits that can bring – should be a normal situation for everything other than using a laptop on the hoof. Improve your windowing arrangements without anarchy, configuring your displays by right-clicking on your desktop and selecting Display settings.

clip_image004clip_image006This will let you move your monitors around to mirror your physical environment, so you can move a mouse or window easily from one screen to the other, and the desktop will span the monitors appropriately.

If you have a big monitor in front of you, and your laptop to the side, you’ll probably want to select the monitor in the Display Settings dialog and select to “Make this my main display”, which is where the Start menu will appear, along with other system related things like the place where the UI for ALT+TAB or WindowsKey+TAB shows.

You can move windows around by dragging them, or learn to use the shortcut keys SHIFT+WindowsKey+left or right arrow which cycles windows between your monitors (and using the WindowsKey and the arrow keys without SHIFT, will snap the active window to the sides, or to max/minimize the window on whatever screen it’s on).

If you ever share a monitor between several machines, XBOXes etc, you might get to a point where you want to stop Windows displaying stuff on a screen that it still sees as connected, even if that monitor is displaying a different source. You could use WindowsKey+P to cycle through the Projection options, of PC only, Duplicate, Extend or Second Screen. If you knew you were on Extend but your primary screen was now showing something else, you could press Wnd+P twice to switch through the options to be back at PC-Only so you can use the machine as normal, and move any windows that were on the 2nd display back to the laptop screen.


If you like a more definite way, you can use WindowsKey+R then enter displayswitch with /internal (for PC only), /clone, /extend or /external for the other options.

clip_image010Right-click your desktop to go New > Shortcut, and you can add a shortcut, to which you can also assign a shortcut keystroke if you like – then a single keypress sequence will jump to a specific monitor configuration.

As a parting shot, should you want to change which screen is the primary one – rather than forcing a particular display scheme – then you can do that with an open source tool called nircmd, that lets you fire a command (like nircmd setprimarydisplay 2) to switch the primary display to that numbered screen.

534 – May Update maybe


As discussed a couple of weeks back, the May 2020 Update to Windows 10 is making its way to users via Windows Update, though not yet all users.

A few incompatible hardware problems have blocked the installation on a series of machines, including the latest Surface models like Surface Book 3, Surface Pro 7 and Surface Laptop 3.

As part of Patch Tuesday this week (9th June), a fix was rolled out (along with lots of other security updates) which should unblock these machines in time. It’s worth proactively going to Updates in your PC’s settings and make sure it has downloaded and installed any and all updates, firmware upgrades and so on. If you have a Surface machine, you can see – and manually download – a list of all the applicable updates, here.

clip_image004There’s still a compatibility hold which may be active for a few weeks as the Update makes it way to all affected devices. If you’ve applied all the pending changes via Settings -> Update & Security, you can manually kick-off the 2004 upgrade, by going to the Update Assistant page and hitting the Update Now button.

clip_image006This will download an installer program that will check the PC has the minimum spec, has enough disk space and so on, then it’ll begin the download and install process, which will take a good few minutes to complete, with plenty of downloading / checking / applying etc cycles to complete.

You might be disappointed at the end, though – if the compatibility hold still applies to your machine, the process will run all the way through then tell you …



[if you’re not offended by foul language, go to YouTube and search Fred MacAulay etiquette

It’s most appropriate, if a little colourful for some, so you’ll need to find it yourself]