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
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
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
A court has ordered sales of Word to cease – but it won’t happen. A judge in Texas has decreed that Microsoft has to stop selling Word within 60 days, as part of losing one round in a patent dispute. If it went ahead, that means Microsoft would have to
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
From: Certiport Kankawin Kowsrihawat demonstrates unparalleled prowess to top largest field of competitors ever in annual Worldwide Competition on Microsoft Office. Certiport today named Kankawin Kowsrihawat, 17, from Thailand this year’s World Champion in Word 2007 for culmination of the most prolific competition on Microsoft® Office to date. In its
You can buy Windows 7 soon – should Office users bother? Windows 7 is now ‘RTM’ Released to Manufacturing which is Microsoft speak to say that all the programming and testing is done – now they make the DVD’s and boxes as well as fully unleashing the marketing mavens. We’ve
Don’t get your hopes up, Office 2010 is a done deal. A few weeks ago a curious campaign started, mostly via Twitter, to ask Microsoft is ‘fix‘ Outlook 2010. The complaint is about the way Outlook creates HTML formatted emails, which is the way most people send emails with ‘full’
A first in-depth look at ribbon ‘hand weaving’ in the next Office. Microsoft’s second attempt at the ribbon interface is coming in Office 2010 and this time we’ll not be stuck with Microsoft’s ribbon – you can weave your own. Office 2007 gave us the ribbon interface but no practical
Microsoft says they are ‘entering’ Technical Preview, two months after it actually happened. You have to hand it to Microsoft, if they can’t announce something new, they announce something old knowing most people won’t realize any different. We were amazed, but not really surprised, to see Microsoft announce that Office
From: Microsoft Microsoft showcases new product capabilities and announces Office Web applications will be available to nearly half a billion people at launch. Today, at its Worldwide Partner Conference 2009, Microsoft Corp. announced that Microsoft Office 2010, Microsoft SharePoint Server 2010, Microsoft Visio 2010 and Microsoft Project 2010 have reached
We’ve just heard a talk about ActionBase in Office 2010 and still don’t know what it is. UPDATE: Though it’s not at all clear from the conference video. ActionBase is a non-Microsoft product, not a part of Office 2010 or any upcoming Microsoft product, or indeed the VBA class called
A new ebook on using Microsoft Access to make great Word documents. Office Watch and Helen Feddema are delighted to announce the publication of a new Office Watch ebook especially for Microsoft Access users. Access Archon – Working with Word by Helen Feddema, editor of Access Watch. Like
What to do if you’ve lost your Microsoft Office install disks? Let’s say you’ve lost your Microsoft Office installation CD / DVD or even floppy disks from years ago – what can you do? There are two things you need to recover – the installation files and the product key.
Microsoft has been crowing mightily about a problem with Google Apps Sync. Microsoft has been crowing mightily about a problem with Google Apps Sync. Google Apps Sync is a utility to synchronize Outlook email, calendar and contacts with the Google Apps online services. According to Microsoft, when you install Google
Like many things with Outlook, even a simple thing like deletion isn’t simple at all. Microsoft has designed Outlook to give you options to recover items deleted accidently. Australian newspapers are leading with ‘UteGate’ – believe it or not. It started with an email supposedly sent from the Prime Ministers
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
Dell is now selling Office 2007 as a legal download but is it cheaper? Dell Computers is now selling Microsoft Office as a download – the first company other than Microsoft itself to do that. Until now, Dell has been able to sell MS Office pre-installed on their computers or
A look at the progress of Office 2007 SP2 – bugs fixed or not. It has been over a month since Office 2007 Service Pack 2 was released. Here’s a look Outlook 2007 won’t start We mentioned reports of Outlook 2007 not starting after SP2 was installed. Those initial reports
The SP2 updated help files have finally appeared. When Service Pack 2 was released there were also new help files for all parts of Office 2007 with the notable exception of Outlook 2007. At the time we called the Outlook 2007 help files ‘missing in action‘. In early June the
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
How to use the Outlook View Control on an Access form When Office 2000 was introduced, and the Outlook View Control first became available, I tried it out, but found it so buggy and difficult to work with that I set it aside as unusable. Recently, I decided to try
More solutions to Access AutoNumber problems. I have received several more solutions to the AutoNumber problem discussed previously with the Access Archon article “Recovering from an AutoNumber Disaster.” With these solutions, and the ones in the last AW, you should be able to find some solution that works for you,
