Enable the Hidden Microsoft Outlook QueryBuilder

After discussing Search Folders in a recent episode of ProdCast, Joel pinged me after the episode asking me about some more advanced search options. Specifically, he wanted to create a search folder with a little more complex logic behind it (like using AND or OR for several potential criteria).

Microsoft does support this without any extra add-ins, it’s a feature called Outlook QueryBuilder, but it’s not very obvious how to turn it on. In fact, it’s hidden and is enabled by adding a key to the Windows registry. I wasn’t able to find a video on creating this key, so in an attempt to give back I present the following brief how-to.

As a word of caution, editing the registry does carry some risk with it. In case you’re not familiar, the registry is where a lot of critical details are stored that makes Windows (and your installed software) work as you would expect it to. Making edits can have unintended consequences. That said, the update in this video is pretty safe, but always be careful whenever you go into the registry 🙂

1

Create an Outlook Search Folder (and only search one folder)

On the most recent episode of the ProdCast: The Personal Productivity Podcast, Joel Lindstrom and I talked about Search Folders as part of a strategy for dealing with the deluge of email.

In case you haven’t already listened to the episode, I was talking about setting up special folders inside of Outlook 2016 (or 2013) that look through your whole mailbox for a match (even if it’s in a sub-folder, or sent items, or wherever). In simple terms: a search folder is a saved search that saves you time by storing several search terms, allowing you to find matching emails in just one-click.

Joel asked me if the Search Folder could focus that search to look inside of just one specific folder (e.g. “only mail in your inbox” and not any other folders). The answer is yes…but after recording the episode, I felt like I made it sound over-complicated to set up a search folder that only searches through a certain set of folders. I whipped up the following video to show just how easy it is!

If you’re not familiar with ProdCast, it is a podcast about personal productivity, getting more done with the time you have, avoiding procrastination, and being more efficient. We separate the hype from productivity tools and talk about ways to use your email and task list to become more productive. If you’re interested you can subscribe on iTunes.

Don’t Let Automation Destroy Your Authenticity

One of the most effective ways to become more productive and manage your time is by automating low-value, repetitive tasks. Every week new apps are released that will connect to your online accounts and do some work for you. I’m a huge fan of this progress, however, I get concerned about these services having an unintended effect of trading some of your authenticity away just to save a little time.

There is a growing popularity of automation tools like Zapier, If This Then That (IFTTT), and Microsoft Flow, and it’s becoming easier and easier for average people to build their own personalized automations.

Even easier are tools like dlvr.it which will monitor sites and automatically post to social networks on your behalf. I’ll admit that I’ve tried dlvr.it for a couple of months and it has saved me time because I don’t need to remember a laundry list of sites that I want to further discuss on Twitter (it does the posting for me). Unfortunately, things got weird for me when people re-tweeted and responded to my tweets about articles I hadn’t actually read yet.

That crossed a line for me. As informal as social media can be, people do react to tweets, posts, and shares in a very personal way. As a result, I recently stopped using this automation and decided to find a middle ground I am comfortable with.

This made me reflect on the ways automation can impact the perception of your authenticity. As I weighed the arguments, I expected that my opinion would change if I considered it from the perspective of an individual (e.g. my personal Twitter account) vs. an organization (e.g. my company’s Twitter account). To my surprise, the answer stays pretty similar for both situations.

Be careful which kinds of human interaction you automate

Every year around the holiday season I get greeting cards from friends and family. I also get them from companies that I do business with. I’m never impressed with the generic holiday greeting cards from my insurance agent. It’s a great concept, but I can see that they were printed in bulk (with a mail-merge), include a laser-printed message and signature, and were sent from another state. How many people receive this kind of card and feel warm-fuzzies?

I like my agent, and I don’t think he’s even directly responsible for the cards (it’s the parent company that sends them out). Sadly, the card that’s being sent out on his behalf actually serves as a reminder that I’m not getting a personal card/call/email to wish me happy holidays.

I get plenty of other impersonal mailings from the insurance company, ones that I don’t mind at all. Who in their right mind would expect their billing statement to have a personal touch? The non-personal, but personalized, holiday greeting card is a perfect example of the wrong kind of interaction to automate.

Set appropriate expectations to maintain your authenticity

Take a moment and think about something as simple as an order acknowledgment email for a purchase you make online. Few people today would expect this to be personally crafted and sent by a live person. In fact, for me, and many others I know, that email should be in my inbox right away. It’s a tangible thing that makes me feel satisfied that the order I just placed is real.

However, 10-15 years ago (or maybe even less than that) most people wanted to know that there was a human being looking after their order. Why is this?

Expectations changed.

They may have changed for something like an email that confirms an order, however, the prevailing expectation I see on social media is that people expect (and believe) that posts are coming from real people hitting the Post button. Make sure your authenticity is not compromised by over-automating this kind of interaction.

Setting these expectations grows increasingly important “bots” become more mainstream. Bots (a.k.a. chatbots) are growing in their ability to handle requests for information (through a request from somebody) and automatically respond with an answer (or with a request for additional details or context).

In my experience I’ve seen bots with very wide differences in how successful they are–but little irks me more than a website offering me a live chat with an agent…but then it turns out that the agent is actually a bot.

Final Thoughts

I’d like to reiterate that I am by no means speaking ill of the services provided by dlvr.it, IFTTT, Microsoft Flow, or others. These are very exciting tools that can improve the productivity of individuals and organizations alike. There’s a line when it comes to communication, though, where automating for productivity could compromise your authenticity–and I highly encourage that you take the time to ask yourself where that balance is for you.

Do you automate communication tools like email or social media? Do you think I’m overreacting? Sound off in the comments below.

Secrets to Getting Stuff Done – Prove Your Competence by Saying No

If you’re like me, when someone starts talking about a new project, you get excited and might want to get involved. This is a great quality, which has served me well both personally and professionally, and something that I never want to lose.

Unfortunately, this tendency can have some unexpected side effects, like overextending yourself. About five and a half years ago, I had put entirely too much on my plate at work and it was really difficult to deal with.

One of the contributing factors was that I worried that if I said no to a project, I felt like the person asking (usually my boss or someone senior to me in the organization) might think I declined because I lacked the skill or ability to do the work. In other words, I was worried they might think I was incompetent.

In hindsight the exact opposite was true.

Getting stuff done (the important stuff) means something else probably won’t happen

How many times have you found yourself saying something like:

  • There aren’t enough hours in the day…
  • I wish I had time to learn that…
  • If only I could find the time to…

Nobody wants to be in that kind of situation because it means that there’s something you really want to be doing, but you can’t. I focus a lot of effort on using my time on the things that are most important. After all, there are only 24 hours in a day (and only 168 hours in a week).

I can hear you saying “OK, sure Matt, only spend time on what’s important. But that’s easier said than done. Especially when my boss might think I’m not carrying my load if I can’t take on this new project or task.”

That’s a fair point, however, test my logic in the following scenarios.

Which situation actually makes you look incompetent?

Let’s consider two different people, Mark and Sara, who are each asked by their boss to help out with a project.

  • Mark says yes to everything. He knows he is capable and wants to prove that to his boss. He was already overloaded with projects, so what’s one more project in the queue. He misses commitments because he has too many. People think he must be competent because he said he’ll do everything, but proves to be incompetent because he’s not delivering
  • Sara often says yes, but also sometimes says no. She is capable but wants to make sure she can focus and follow through. She delivers on commitments because she’s not getting crossed up in too many things. People might think she is incompetent because she said no, but her track record of getting stuff done proves otherwise.

Who do you think looks incompetent, Mark or Sara?

Whether you say yes or no, there’s always a risk that someone might think that you’re incapable or even incompetent. Let them think whatever they want to but prove yourself and your personal brand by meeting the commitments you make. Your track record is an objective scorecard that you can reference back to.

Careful! I’m not suggesting that “no” is a get out of jail free card

Quite the contrary.

Doing work. Doing good work. Taking on projects that are new and challenging, or that will take learning on your part. These are all part of growing your career. Saying no, and especially saying no “the wrong way” can make you seem difficult to work with or unwilling to cooperate. This is potentially dangerous territory to wander into.

I say this because there’s a temptation when you’re learning to say no to misuse this developing skill. It may not even be a conscious thing. It’s an easy trap–in fact, it’s natural. If you’ve ever talked with a two-year-old who learned to use the word no, you know how they tend to go overboard.

What I am saying is that saying no in the right situations will help make sure you’re able to focus on getting stuff done. In the long run, this will lead to people seeing your competence because you do the stuff you say you’re going to do and they also don’t mistakenly assume you’re going to do everything that comes your way.

Final thoughts

As I mentioned earlier, I’ve actually been quite guilty of saying yes to too many things. I rather enjoy the challenge of completing a lot of stuff that I’ve committed to. However, I’ve seen the dark side that can include late nights, exhaustion, and stress that doesn’t need to be there. In those times I realized how much additional risk of seeming incompetent came because I committed to a project that I didn’t have the bandwidth to take on.

I’ve worked hard to develop the skill of managing this particular risk and I highly encourage you to do the same. One of the first places I recommend starting is in situations like the ones above, where you’re saying yes for the wrong reasons.

Do you agree that saying no can prove your competence? Let me know in the comments below.

Announcing ProdCast – the Personal Productivity Podcast

I’ve teamed up with my co-worker and friend Joel Lindstrom to create a bi-weekly podcast on personal productivity, called ProdCast (Productivity Cast). The topics we’re planning to cover are very much in line with the topics of many blog posts here at Connecting the Data–the apps, systems, and strategies that help with personal productivity and time management.

In the first episode, we discuss the format and direction of the show. Along the way, we cover a couple of tips from my recent Skype for Business e-book release.

You can subscribe on iTunes right now or listen to the latest episodes on the web at prodcast.show. We’re joining up with the crm.audio podcast network–so if you’re already subscribed to the CRM Audio podcast you’ll see ProdCast in your feed automatically as well.

 

via ProdCast 1: What is productivity

 

 

The AppSource Experience for Dynamics 365

Last year, Microsoft introduced a new app store for Dynamics 365: AppSource. In fact, AppSource also boasted apps for AX and other Dynamics products, and has since added Power BI, Office 365, and Azure into the catalog.
I’ve tried installing apps into trial Dynamics organizations as a way to get familiar with the store, search, installation, and the overall experience. I was pleasantly surprised by how usable it is even with how fresh it is.

AppSource as a great end-user experience

I had a chance at the CRMUG Summit conference last fall to chat with a program manager involved with the AppSource program. Specifically, I asked about some of the important considerations for what is a good fit for AppSource as a partner who is considering submissions of industry-specific apps.
The suggestion that stood out the most to me was the end user experience (when they install the app and start trying to use it). This is definitely an area that has been tough for the previous “app stores” for Dynamics. With AppSource, it should be a small solution file (so it installs quickly), include any required sample data, and give some direction for how they can start trying it out right away (e.g. don’t send someone off to a separate website to figure it out or, worse yet, don’t leave them having to simply guess what is important).
It’s such a straightforward concept, however, it wasn’t a requirement when submitting solutions to previous Dynamics app stores.

Taking some user experience cues from the Xbox Marketplace

It wasn’t long ago that buying a new video game meant you either had to read the manual to understand what you could do (or start button-mashing and hope you pick things up quickly). For some people, this approach is/was fine, but it has the potential to turn many people off who may otherwise really enjoy the game.
Nowadays we’re able to download a game and as soon as it’s finished installing you can start playing. The first 5-10 minutes includes a very guided experience that shows the basics of playing without having to study, guess, or flounder.
I imagine a future where starting to use a Dynamics app (or a Power BI, Office 365, or Azure app) is this simple to get started with.
That’s not a bad thing either, even for those who could figure it out on their own. After all, the beginning of Skyrim is filled with hand-holding to get acquainted…but it sets a solid foundation for all players from casual or the most hardcore gamers.

1

8 Essential Skype for Business Hacks free e-book

I would never have guessed that I’d be announcing the release of my new e-book about Skype for Business. Don’t get me wrong, I’ve used it as my primary workplace communication platform and online meeting service for the last 5+ years (dating back before Lync was rebranded as Skype for Business). Still, I’m surprised and excited to share my e-book with you. You can get your free downloadable copy by clicking here.

The early days of Skype for Business were pretty painful. There were compatibility, connectivity, and general usability issues that I’d run into for even the simplest of meetings. I also quickly learned that I wasn’t the only person with these problems (and also that it wasn’t just limited to my company’s use of Skype for Business). Over time, though, something happened.

Skype for Business became a viable option that competes with the other online meeting and voice over IP options

In my line of work, I find myself having to use different screen share/online meeting services. GoToMeeting, WebEx, Join.me, and others (even one called Blue Jeans). For a long time, Skype for Business was simply not on par with the other options. On paper it could check the boxes–sure–but there were lots of little nuances that “you need to get used to.”

Behind the scenes, though, so many Skype for Business users would grumble about features not working how you expect, compatibility issues, and a lack of trust.

In 2015 and 2016 there were many improvements made to the platform, the desktop client, and the phone apps, which have resulted in positive improvements in stability and usability.

These improvement in the Skype for Business platform, in concert with it being included with most Office 365 subscriptions, more and more organizations are using it as their online meeting solution.

With great knowledge comes great responsibility

As a long-time user, I’ve seen and helped people with the most common issues they run into when they start with Skype for Business. Several co-workers of mine have asked me for the last year or so when my “Skype book” would come out. I can finally tell them that the wait is over!

In this e-book, I’m sharing a collection of these Skype for Business essential tips, which fall into four categories:

  • Joining meetings from the desktop app – for internal team members
  • Joining meetings from a web browser – for external parties who don’t use Skype
  • Leading meetings – for scheduling and starting meetings
  • Recording meetings – for capturing meeting audio & shared content

You can get your free downloadable copy by clicking here.

Do you use Skype for Business? Are there any tips or tricks that you’d be willing to share with others? If so, sound off in the comments below!

Server Side Sync in Dynamics 365 isn’t required for Relationship Assistant

With the Dynamics 365 update late last year, I’ve seen some clients who are making timing and priority decisions for the visual update as well as what new functionality to test out. One (preview) feature that has been the center of attention for several of those conversations is the Relationship Assistant.
If you’re not already familiar, the Relationship Assistant basically provides reminders, suggestions, and insights about your relationships–based on information that you have in Dynamics 365 and Office 365. The feature uses Microsoft Azure to analyze activities and other record types to:
  • Remind you about upcoming due dates / close dates
  • Suggest activity if you haven’t been active with a customer or prospect
  • Offer external information like stock prices or recent news (without having to go look for it)
When I first started chatting with folks about the Relationship Assistant, there was a common misconception that came up again and again: people seem to think that relationship assistant requires Server Side Sync to be enabled. While this is true for some of the relationship cards, some can be used regardless of the Server Side Sync feature. These cards fall into several categories, but only two of them (Email Cards from Exchange and Email Engagement Cards).

There is real value if you use Server Side Sync

All of that said, I’m certainly not recommending against some of the cool stuff that comes with Server Side Sync. What’s most significant here is that emails in your personal inbox can be displayed in Dynamics without the user having to physically click a “track” button. Literally, email that they may not have even seen in their inbox could be displayed in the context of an Opportunity record with that same contact.
This is the kind of feature that provides value back to users without them having to put a bunch of up-front effort in.
I’m hoping to gain a deeper understanding of how to train some of these email cards from exchange, though. Some of the cards like “Stakeholder Recommendation” that will suggest (or automatically add) a stakeholder into Dynamics if they aren’t already in the system. Being able to train this model for industry-specific keywords will make it more versatile. Maybe this is something we’ll see when it’s out of preview (I can dream, right?)

Final thoughts

I know this isn’t a hidden feature or anything fancy like that, but it’s important for Dynamics administrators to know the tools that are available to them and their user community. While it’s not hidden, it is a Preview feature, which you’ll want to keep in mind as it doesn’t come with any official support.
Are you considering the Relationship Assistant or have you already enabled this in your organization? Share your thoughts in the comments below.