Exporting Appointments from Outlook to Excel

I put this solution together for Allen, who had seen my post demonstrating how to export Outlook messages to Excel and asked if I could create a similar macro to export appointments. Allen went on to explain that his organization uses a shared calendar and that periodically he would like to export its contents to Excel. For each appointment, Allen wants to export the organizer (i.e. the person that added the appointment to the calendar), when the appointment was added, the appointment’s subject, when it starts, and who was invited. To make it a little easier for Allen, I broke “who was invited” down into two groups: required and optional attendees. The solution itself is nearly identical to the one I used to export messages.
Continue reading


Send Messages with Zip File Attachments to Junk Mail

One of the things I do each morning is check Twitter for questions about Outlook. This morning I found this one from Meester Neek.

Someone else had already replied to the tweet suggesting that Meester Neek create a rule to handle this. Unfortunately, Outlook’s only rule condition for attachments is which has an attachment. There is no option for specifying an attachment name or type. We can still use a rule and that rule can use the which has an attachment condition, but the rule is going to have to run a script in order to determine if any of the attachments are zip files and act accordingly. The script itself is extremely simple. All it has to do is check the file name of each attachment to see if it ends with .zip. If it does, then the script will move the message to the Junk E-mail folder. Otherwise, the script does nothing. This solution should work for any version of Outlook on a PC. Note that it will not work for Outlook on a Mac, OWA, or mobile devices.
Continue reading

Outlook Category Checker


I’ve found several interesting Outlook questions on Twitter recently, including this one from Carl Knecht.

In short, Carl wants a way to discover which Outlook categories he’s not using (i.e. no items assigned to the category) so he can delete them. Outlook isn’t able to do this natively, so once again we have to turn to scripting. To do this, the script first reads the categories from the master category list into an array that will keep track of how many times each category has been used. It then reads through every folder (mailbox and PST files alike) and sub-folder. For each item in each folder, the script checks to see if the item is assigned to one or more categories and updates the counts in the array accordingly. The result is a sorted list of category names and the number of items assigned to each. Continue reading