Here's another installation of the Office Cafe. Enjoy the links!
Been There, Done That Department
In Adding all message recipients as Contacts, someone asks if message recipients can be added as Contacts. Several solutions were offered, except for VBA. I've already done so in the following article: Save money, use VBA
Formatted Emails
In Conditional Formatting: Highlight your most important mails, Outlook Program Manager Josh Meisels shows you how to add conditional formatting to emails in Outlook 2010 (I assume 2007 as well). This is a great technique for making important emails stand out, while useless emails can be (visually) pushed into the background. For example, from your boss who sends action items, or a co-worker who always sends you chain letters or jokes. (I'll let you decide which ones are important and which are useless.)
In Outlook 2003, the process is slightly different. Select the folder you want to apply the formatting to (usually the Inbox). Go to View » Arrange By &rauo; Current View » Customize Current View.
Now click Automatic Formatting.
From there, the instructions are the same as in the Outlook team blog post: click Add to create a new formatting rule, Font to change the email's font attributes in the message list, and Condition to determine the conditions for when the formatting will apply.
Sample Office 2010 Plain and Simple Chapters
At the Office website there are some chapter excerpts of this book for you to enjoy.
School's … In
Now that school has started again, Microsoft is also offering some new free templates or Office 2007 and 2010 for educators. Speaking of school, Chandoo is starting his Excel school up again, see below for links.
The MVP Award Program Blog has been featuring more Office MVP content. Skip the boring articles about Zune and ASP.NET MVPs and read Customizing the Office 2010 Ribbon. How do you become a Zune MVP anyway, listen to a lot of music? 
Didn't Know That Department
Excel Services through SharePoint has a REST API that may be used to run queries against a workbook. Read Using the Excel Services 2010 REST API for more information.
Plan Your Wedding The Excel Way
Jon Wittwer and Chandoo both have wedding planners, download them here:
- Budget Wedding Planner
- Excel Wedding Planner
My understanding is that the first one is free, while Chandoo offers both a free (limited) and paid version of his planner.
Excel Templates
Now that the World Cup has finished, many professional soccer leagues have started up again. Excel Templates has some nicely designed tracking sheets for several of the major leagues. My favorite is the La Liga schedule.
Office 2010 Object Models
The Office Client Developer Blog has a list of the Office 2010 Object Model References. If you are programming against any of the new Office object models, you'll want to visit that page.
VBA Error Handling
Wayne Phillips at Everything Access has released what looks like a useful piece of software — an error handler for your VBA programs.
Excel Training Schedule
Mike Alexander's Excel Bootcamp will be held October 18th and 19th in Dallas, TX. Visit Excel Power Analyst Bootcamp for more information.
And speaking of Mike Alexander, he's got a great tip on his blog about check variable values in Break mode. In VBA Hover ToolTip Trick we learn how to check variables with really long values.
The Trouble with Loop Counters
Tony vows to never use the letter i as a loop counter.
He says that, in Courier font, the number one looks like a lower case I. I don't see it. It looks a lot like a lower case L, however. I won't stop using i as a loop counter.
Note: The Amazon-listed book and Chandoo Excel School are affiliate links, otherwise I don't receive any commission from the other sites and am not recommending any particular product.
About JP
Follow Me