674 – Here’s the (co)pilot

imageUK telly viewers in the early noughties may recall the surreal comedy show, Trigger Happy TV, with recurring characters like the aggressive squirrels or the  guy with the massive phone (and that Nokia ring tone).

It was also known for some great soundtracks, like the fantastically titled Grandaddy song “He’s Simple, He’s Dumb, He’s the Pilot(also used elsewhere). Tech news over recent weeks tells us that the pilot – or Copilot – is anything but dumb, even if it can be simple.

clip_image002For Microsoft watchers, “Copilot” is a growing set of capabilities which are being built to add OpenAI functionality to other applications. With all the hoo-hah about ChatGPT and the generative AI that is now integrated into Bing (and available for everyone who wants it, not just early adopters), it’s easy to get different strands mixed up.

GPT-3 and now GPT-4 are the core language models which could underpin any number of applications’ use of what looks like artificial intelligence. ChatGPT is one web app built to hone some of the parameters of GPT-3 and put a chatbot front end to it. The new Bing and all the other stuff announced over the last few weeks is not using ChatGPT, but they do share some of the same technology underneath. Capisce?

There have been AI features aimed at making developers’ lives easier, such as Github Copilot (available since 2021), which uses another OpenAI tool called Codex, itself built to harness GPT-3. For developers on Power Platform, there have been AI functions for years too, though some capability has been recently added.

Everyday users of Dynamics 365 and Office applications will soon get Copilot capabilities to help automate boring tasks, like “work”. Do bear in mind that announcing something and making something available – in limited preview form or generally – are different activities. Copilot for Office apps like Outlook might be a few weeks or months away for most of us, but who can’t wait for AI to automatically read and reply to all their emails?

clip_image004

The future with our robot overlords never looked so appealing.

For a growing summary of Copilot announcements, see the hugely popular LinkedIn post from Jack Rowbotham.

660 – Contacts in D365 CRM

clip_image002Sales people tend to not like CRM systems very much. They are usually foisted on the poor folk who need to figure out how to get what they need out of them, while navigating a cumbersome and unhelpful set of behaviours and expectations. And that’s just the sales people – the CRM implementations can be poor too.

clip_image004If you have to use CRM, and you’re lucky enough to be using Dynamics 365 Sales (if not, you can get a free month’s trial), then there are some handy contact management tools worthy of a few minutes’ attention. First of all, the Outlook integration for the latest D365 CRM service means if you have an email from a customer or partner, you can track it and quickly add contacts on the email to the CRM system by invoking the Dynamics add-in.

clip_image006Click the Dynamics 365 icon in Outlook and you’ll see a sidebar show up on the right. The “Set Regarding” option lets you add the email to a customer record in CRM. Below that, if the contact doesn’t exist already, you’ll see the option to add it by clicking on the recipient’s name and hit the + button on the lower right.

Depending on the rules of your particular system, you’ll probably need to provide a job role and maybe some other fields, and you might not be able to associate that contact with an account yet – perhaps you’ll need to save it to Dynamics first, then make the association with the account to which the contact belongs.

clip_image008If the Account field is locked when you first add the contact, then once your contact has been saved in the sidebar, click the hamburger menu icon on the top left and look under Recent to open that contact again, then you should be able to choose the account name from that view, rather than fishing about in the main CRM UI for all the other added contacts.

clip_image010From within the same sidebar UI, you can fire up a more fully-featured view by opening it in a separate Dynamics window. From there you can more easily do stuff like matching the contact to one in LinkedIn, if you have Sales Navigator access; it’s a handy way of associating the two, though annoyingly it doesn’t automatically pick up the LinkedIn photo and associate it with the CRM contact.

clip_image012To set a picture for your contact, click on the circular initials at the top left of the name and that lets you choose a photo – ideally, you’ll have already saved the mugshot to your machine first, though if the image is online – a company website, for example  – you might be able to grab the direct clip_image014URL to the photo and paste it into the Upload Image dialog.

Getting images from LinkedIn can be a little more laborious especially if you’re doing this in batches. Here’s a fairly simple technique to make it easier.

  • clip_image016If you have LinkedIn Sales Navigator and it’s integrated to Dynamics 365, open the LinkedIn tab for your contact – assuming you’ve matched them already. Right-click on the profile picture and choose Save image as. Save it to your Downloads folder.
  • If you don’t have Sales Navigator, then try searching LinkedIn in another window, find your contact then open their profile. Right-click on their profile photo, choose Save image as, save to Downloads folder.
  • clip_image018Now back in D365, click on the initials back on the main contact page, to bring up the Choose Image pop-up. Click the Upload Image button, navigate to Downloads – change the view in the file picker dialog to “Extra Large Icons” to make it easier to find the right one – and select the pic you’ve just saved. Click the Change button and you’re done.

clip_image020clip_image022OK, so you have an image for each of your contacts – so what? Well, all the contacts you’ve just added should be visible in the Org Chart function which appears on the main toolbar of the Account. With a bit of dragging and dropping, you can quickly lay out the reporting structure for your known customer contacts.

clip_image024Handles will appear on contacts as you move them around, to help manage the way the chart is displayed and keep it simple. Save the chart layout when you’re happy, and you can show your boss how diligent you’re being at managing your customer relationship. Now, who wouldn’t want that?

543 – Dynamics CRM and Outlook

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

clip_image008clip_image010

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…

clip_image022

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