Category: Microsoft Office
-
Set Outlook to only mark as read when you open an email
A while back, a customer complained that Outlook always marked emails as read when he clicked over to another email, and wanted to know if there was a setting that would change this behavior. As it turns out, there is. Here’s how you do it:
-
Outlook: Disable the send without location prompt
Like many others, my work days are – to some extent – made up of meetings with others. It’s not uncommon for these meetings not to have an assigned meeting room, and I find it annoying that Outlook asks me if I want to enter a meeting location:
-
Outlook: Mail merge
I have previously written about one of my many responsibilities; contacting users whose login credentials have shown up in breach lists. While the pertinent results of the breach files are delivered to me in a flat file, I use Excel’s Text to Columns feature to separate logins (usually email addresses) from the password. While this […]
-
Outlook: Offline Mode
From time to time, I need to run Outlook in Offline Mode. This is usually the case when I want to ensure that a mail merge has worked successfully. It is also a good option to reduce data usage when on mobile networks. Going to Offline Mode is straight forward. In Outlook, go to the […]
-
Excel: Text to Columns
I work a lot with text files containing data which is, to some degree or another, structured. Whether a breach file from a published breach, or the result of a powershell query such as Get-ADUser, Get-ADComputer, or Get-ADDirectReports, I need to separate the data into columns so that I can work with it. This is […]
-
MS Office: Pin items
Many companies, my employer included, uses spreadsheets on a more or less consistent basis in order to track such things as vacation planning and KPI reporting. For me, as an employee, keeping track of these spreadsheets can, from time to time, be a bit annoying. Much to my surprise, at some point in the past […]
-
Farewell Bear, hello … OneNote?
In December of 2016, I discovered Bear Writer. At the time, I had been using a number of different solutions for note-taking and organisation, none of which had really done the trick for me. That all changed with Bear. Arriving to critical acclaim, Bear is certainly a very pretty app, and its iCloud sync feature […]
-
Outlook: Not all folders are synced
Shared email boxes are a useful tool for departments needing to have a single point of contact, but whose needs do not extend so far as to need a CRM or ticket management tool. I’ve talked before about how to add them to Outlook, in which I noted that I usually uncheck the box for […]
-
Adding a shared mailbox in Outlook
A not infrequent question at work, is how to add a second mailbox in Outlook. Here’s how:
-
Word: “Track changes” shows up as “Author” instead of author name
A user called in, reporting that Word’s Track changes-function tagged her as “Author”, instead of her name. I opened a remote session, and started out by confirming that everything else was working correctly, and that her name had been set as the author in the settings for Microsoft Word. Stalling for time while I researched the issue, I […]
-
Excel freezes on 10 MB file
A few months ago, I had a user call in complaining that Excel would freeze and become completely unresponsive when she was working in a specific workbook. It was fairly large (10MB), but well within what the computer should have been able to handle. I opened a remote session to the computer, and started troubleshooting. My […]