Outlook icon

Convert multi-day appointments into multiple all-day ones

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 »

Automation iconExcel iconOutlook icon

Extract Calendar data from Outlook, Redux

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 »

Automation iconExcel iconOutlook iconVBA icon

Extract Calendar data from Outlook into Excel

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