Real World Questions, Real World Answers
Never forget to attach an important file again.
Attachment Forget-Me-Not
Discount code: BH93RF24

Excel: Stop turning email addresses into clickable Mailto links

I’m working with Excel sheets that contain a lot of email addresses as well.

When updating a field, it turns the email address in a clickable “mailto” link and when I’m not careful when clicking, it opens up a new email in Outlook.

As I have no intention to email anyone directly from these lists, but do work a lot with these sheets, this is getting annoying quite fast.

Is there any way to disable this behavior in Excel?

► Continue to the answer

Categorize Sent Items while composing a message

I know how to Categorize a message that I have received or once I have sent it; There is a big Categorize button for that on the Ribbon.

However, when I compose a message, this command is not available on the Ribbon. It is available when creating a new Appointment, Meeting or Contact.

Why is this button not available and how can I Categorize a message before sending it?

► Continue to the answer

Remove my name from the top header when printing an email as a delegate

Upon printing an email from Outlook, my name is printed in large bold letters at the top of the message.

While this is OK for my own messages, sadly Outlook also prints my name when I print a message from my manager’s mailbox for which I am a delegate.

Is there a way to print it with the name of my manager instead or to remove the name altogether?

► Continue to the answer

Business Contact Manager (BCM) for Outlook 2016

I just upgraded to Outlook 2016 and found that Business Contact Manager (BCM) is no longer working.

Where can I download BCM for Outlook 2016?

► Continue to the answer account with a personal address or custom domain can’t be added to Outlook

My mailbox just got migrated to the new Outlook Mail infrastructure but I still can’t add my mailbox as an Exchange account in Outlook.

I’m not using an address but an address from my own domain. I also have an address connected to my account but that fails too.

This used to work with the Outlook Hotmail Connector and as an Exchange ActiveSync (EAS) account but not as an Exchange account. How can I make it work as an Exchange account as well?

► Continue to the answer

Prevent changing a Task’s Due Date when changing the Start Date

I’m an avid Tasks user in Outlook and I usually initially build my Task List by only assigning a Due Date. Then at a later stage I go back to review all open tasks and assign Start Dates to the Tasks.

Here is where things go wrong; When I assign a Start Date, it also modifies the Due Date which I absolutely do not want.

How can I tell Outlook to maintain the Due Date when modifying the Start Date?

► Continue to the answer

Find or Select a folder by typing its name

I’ve got quite a large list of folders (with names of customers) in which I sort my emails. Usually, to find a folder to which I want to move an email to, I need to scroll in the Navigation Pane and look for it.

As I already know the name of the folder, is there an easier way to select it? Perhaps similar to selecting a file or folder in Explorer by typing its name?

► Continue to the answer

Use RE: and FW: instead of localized subject prefix

We are an international company with international clients but in various countries we offer localized versions of Office and Outlook to our employees.

A downside of this is that when replying or forwarding, Outlook also adds localized prefixes to the subjects such as “AW” and “WG” (for the German version) which causes confusion with the recipient as they may not be German themselves.

Is there a way to force Outlook to always use the more standard English “RE” and FW” prefixes?

► Continue to the answer

Automatically turn specific words into hyperlinks

In my emails, I often need to refer to documentation and products on the Internet for which I also supply the URL within the message.

For readability, I turn these words into clickable hyperlinks.

Unfortunately, this is quite a bit of work and the documentation and product links are the same ones I use over and over.

Would it be possible to automatically turn these key words into hyperlinks pointing to the correct URL?

► Continue to the answer

Printing a day with appointments after midnight on a single page

This tip to print late evening appointments almost matches my requirement. However, in my case I’m hosting a Halloween party (and soon a New Year’s party as well) with a schedule that also passes midnight.

Is there a way to print such a schedule on a single page too?

► Continue to the answer

Sperry Software
Use "BH93RF24" to get a discount when ordering!