The site formerly known as Code For Excel and Outlook
October 1, 2010 by · 
At OutlookCode someone asks if it's possible to append a bunch of Excel spreadsheets attached to emails in a folder. In the end, we want all the data attached to each email to reside in one spreadsheet.
Continue Reading: Merge Outlook spreadsheet attachments »
September 7, 2010 by · Have you ever wanted to link Excel data to Outlook contacts? Here is a simple event handler that links cells on your Excel worksheet to data fields in Outlook's address book.
Continue Reading: Link Excel cells to Outlook data fields »
August 13, 2010 by · 
In Exploring the NOAA API I posted code for consuming the NOAA RSS feed for Atlantic storms.
I also posted weather-finding functions using the Geonames API, the WebserviceX.NET API and even a cheap formula for opening weather.com.
Continue Reading: State Weather Advisories available by RSS »
July 9, 2010 by · 
A friend sent me a spreadsheet with a list of dates. He wants to put them on his calendar as vacation days, but doesn't want to do it manually. Hooray, another free job.
Continue Reading: Adding vacation days to Outlook in bulk from Excel »
June 22, 2010 by · 
Kevin writes and asks if there is any procedure that will update a distribution list in Outlook using a list of names and email addresses in Excel. Let's see what we can come up with.
Continue Reading: Automatically update Outlook distribution lists from Excel »
Site last updated: February 9, 2012
Follow Me