This is the Export tag.

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 »

Automation iconExcel iconOutlook iconVBA icon

Export Outlook Contacts to Excel

Here is the last of the add-in code I was working on. This piece extracts the properties from Contact Items into Excel, using early binding to speed up the code, but with GetObject/CreateObject calls to attempt to hook into an existing instance of Outlook. What, do you mean you don't leave Outlook running all day while you're in the office?

Continue Reading »

Peltier Tech Charting Utilities for Excel