Microsoft Office

Here’s a question from a reader: Just heard of a new Business Intelligence add-in from Microsoft that ships with Excel and lets you crunch data from different data sources at the same time. That sounds interesting.Looks like Power Pivot is missing in my system, as i don’t see it in my Excel 365 installation. How … Read more

Last Updated: July 2020. Here’s a question we got from a reader: I use my Outlook calendar to manage my business meetings and appointments, tasks and contacts; but also my personal appointments, as well as reminders to call friends on their birthday. As such i keep constantly getting reminders and notifications from Outlook on overdue … Read more

Last update: October 2019. Here’s a question we just got for a reader: Hello there, i am a travel agent, and would like to define a custom email template to answer emails that my customer send me. I also would like to speed up my appointment scheduling process and have a template i can use … Read more

Here’s a question we got from a reader: I am trying to figure out macro development from going through code examples in your website. I figured out that some of the examples point out to the developer menu in Microsoft Excel, Word and Outlook. For some reason, i don’t see that menu item in the … Read more

Last update: December 2019. Here’s a question from a reader: I am using Microsoft Office 365. I have noticed that after i click on a specific email entry in the Outlook Mail tab and open it for reading, it shows as read. What’s annoying is that i have noticed that items that i view in … Read more

Here’s a question from a reader: Just finished to setup Outlook in my computer, and started to get some emails from different people. One thing i notice is that i started also to receive those small black alerts that keep popping up on my Windows 10 desktop. I don’t recall those appearing on Windows 7. … Read more

Applicable to Microsoft Office 365, 2019 and older. Windows operating Systems. Here’s a question we got from a reader: I have a need to automatically resize all images stored in a specific presentation I have to prepare for my management. As the slides are quite standard, this looks like something I could automate using a … Read more

Applicability: Office 365,2019, 2016, 2013. Sometimes, we would like to make our Word documents more interactive and even capture some user input. Enter message and input boxes . As the name suggests a message box is a piece of information that is displayed to the document users. Input boxes are instrumental to capture information from … Read more

Applicable to: Office 2019/2016/365 Here’s a question from Mike: “I know how to create Access forms and capture user input into a database table, but as i have already gathered  there a way to automatically import data from an Excel workbook into an Access database table instead”? Good question, Thanks. Yes, you can automatically import … Read more