With IMAP you can choose which folders on the email host to copy to Outlook. With IMAP you can choose which folders on the email host to copy to a local device. With Outlook you’ll probably want to replicate all folders so you can view anything you need when offline.
Tricks for handling more than one email account in Outlook It’s NOT a good idea to have both POP and IMAP connections running to the same email host. That’s because the POP connection will usually delete messages on the host when they are moved to Outlook, once deleted they’ll be
Speeding up the message sync between Outlook and your email host. Outlook’s default action for IMAP accounts is to download the message header only; you have to mark the message for full download. That was probably a good idea when dial-up modems ruled the earth but is more of a
Working with Gmail ‘starred’ messages in Outlook If you have used Gmail then you must be aware of the “Starred folder” (shown within the red circle in the below screenshot). In Gmail Stars are meant to give messages a special status to make them find easier when you search for
So you’d like to try IMAP? Here’s step-by-step instructions on how to setup Outlook for an IMAP connection. In this series we’ll look at how to setup IMAP. We’ll use Gmail as our host example because it’s free and well supported, however any IMAP host should work (most ISP based
How to turn on IMAP on Google’s Gmail service. In order to make your email host connect with IMAP it may need to be configured in the host settings. This isn’t always necessary, in fact usually IMAP is turned on at the email host already. However Gmail requires you to
Why you might prefer IMAP to get your email into Outlook. What are IMAP and POP? IMAP and POP are methods for retrieving email from an email host like your ISP, Hotmail, Yahoo, and Gmail so you can access it from your desktop through some of the common desktop email
Create the ultimate lookup or decision formula; a User Defined Function using Visual Basic for Applications. by David Goodmanson Following our recent theme of reference, decision and lookup functions, in this article we will go one step further and create the ultimate lookup or decision formula; a User Defined Function
Readers suggest an alternative to nested IF – the Choose() function After David Goodmanson’s features on IF and nested IF’s we’ve received many messages from readers suggesting another alternative – CHOOSE() The Choose function in Excel and VBA lets you choose from a list of options based on an integer
Excel alternatives to nested IF’s from our readers. After David Goodmanson’s features on IF and nested IF’s we’ve received many messages from readers suggesting another alternative – CHOOSE() and here even more possiblities. Tony D writes: “ Small snippet for your “IF” library next time. I’m sure there will be hundreds
A look at nested IF statements and alternatives that are easier to make and understand later. by David Goodmanson In my last article I looked at a simple Excel IF statement plus their useful cousins CountIf and SumIF. I also touched on the nested IF statement, where there are many
PPT Handouts are a special rendering of your slides to be printed out for your audience. PowerPoint Handouts are a special rendering of your slides to be printed out for your audience. It’s one of the ‘PowerPoint support materials‘ including Notes. In this article we show how to make and
Three places to save password information in MS Office. Ideally each login to a computer or web site should have its own password but it’s a given that we all use the same passwords too often. Remembering all those passwords is hard enough but you also have to remember the
Speaker notes can have images and charts as well as printing options. In PowerPoint, Notes Pages show thumbnail images of the slide along with an area below for notes which would help the presenter during the presentation or it can be given to the audience as well. In PowerPoint 2003
Printed support materials that make your presentations better PowerPoint support materials come to the rescue of both the presenter and the attendees. PowerPoint has greatly advanced from being just a tool to prepare slides and organize it. It has come up with various support materials like handouts, notes which can
A trick for quickly printing part of a document, worksheet or slides plus when it does NOT work. Sometimes you just want to print part of a document, maybe a few paragraphs or many pages. One option available is to print the current selection. The basics are simple. In Word,
IF statement and some variatons – nested IF, CountIF and SumIF. by David Goodmanson IF a picture paints a thousand words, then how many words have 5 characters or more? The answer? Use the IF function. The IF function is a simple and easy-to-use function that can be widely applied
Why can’t Office open docs made by Office itself? When Microsoft was trying to gain market share over rivals like WordPerfect, they spent a lot of time and trouble making Office import other document formats easily and correctly. Times have changed, Microsoft Office has the overwhelming share of the office
Much as the Microsoft marketing people would like you to believe that – it’s not true. Much as the Microsoft marketing people would like you to believe that – it’s not true. Plenty of individuals and companies are sticking with earlier versions of Office – Office 2003 or Office XP
You can now download Microsoft’s Sharepoint Designer free. Microsoft Office Sharepoint Designer 2010 – one of the successors to Frontpage 2003 for customising Microsoft Sharepoint web sites is now a free download. With registration you can get the 254MB or less download from Microsoft. That might be a little annoying
New threat for PPT 2003, 2002 and 2000 Microsoft has advised a new security threat involving .PPT .POT and .PPS files. It is possible for one of those file types to be infected with a new virus which takes advantage of an unpatched security hole in PowerPoint. You can get
Let’s have some INDEX() and MATCH() fun in our Lookup function series. by David Goodmanson On their own, the INDEX() and MATCH() functions are fairly straightforward but when they are combined they create a very powerful Lookup tool. Both functions have 3 parts to their arguments. INDEX(range, row_number, column_number) and
Cross-referencing is an imposing name for something we’re all familiar with in books, especially reference books. Microsoft Word makes it much easier to do. A cross-reference is simply a mention or link in the text to another part of the same document. In olden days (thirty years ago ) you
Gmail stopped working, but Outlook users didn’t have to worry. Saul Hansell at the New York Times is reporting on an outage on the popular Gmail service. The Gmail breakdown happened at the start of the working day in Europe and lasted until about lunchtime. Early risers in the USA
