The site formerly known as Code For Excel and Outlook
April 5, 2010 by · 
In the comments for Extract Calendar data from Outlook into Excel, Keith asks if he can convert multiple-day appointments into single all-day ones. These are all-day appointments that span multiple days, and he needs them to be single day appointments for viewing on the iPhone. Here's how to do it.
Continue Reading: Convert multi-day appointments into multiple all-day ones »
March 31, 2009 by · In Extract Calendar Data from Outlook into Excel, I posted a method for writing Outlook appointments to an Excel worksheet.
Here is an updated function that uses a bit less code, with one disadvantage: it doesn't extract recurring appointments. Use the original code if you have recurring appointments. Or use both; the original to get all appointments, and this one to get only originals (not the recurrences).
Continue Reading: Extract Calendar data from Outlook, Redux »
August 10, 2008 by · I completed some VBA code that will allow you to export appointment information (meetings, appointments) from Outlook into Excel. It requires a reference to the Outlook object library (unless you care to reengineer it), but it works even with Outlook closed. I think you'll find it very useful for when you need to examine or manipulate Outlook Calendar data, and want something a bit faster (and more flexible) than Outlook's built-in exporter.
Continue Reading: Extract Calendar data from Outlook into Excel »
Site last updated: February 9, 2012
Follow Me