In Tip 824 Diane Poremsky shows us a bit of VBA that lets you add photos to your contacts in bulk. Let's try and improve the code.
Continue Reading: Add photos to Contacts in bulk using VBA in Outlook »
The site formerly known as Code For Excel and Outlook
In Tip 824 Diane Poremsky shows us a bit of VBA that lets you add photos to your contacts in bulk. Let's try and improve the code.
Continue Reading: Add photos to Contacts in bulk using VBA in Outlook »

I was on Outlook Code a few days ago and noticed a change in the footer:
© 2010 Add-in Express Ltd. All rights reserved.
Continue Reading: What a shame »
I was browsing the Internet recently and found a company that sells Outlook add-ins for various purposes (I won't mention the company). What a shame, because a few lines of VBA code could save dozens or hundreds of dollars that might be otherwise spent on frivolous add-ins that remind you if you forgot an attachment, or automatically BCC someone, or something similar. As long as you're OK with giving up a pretty UI (with the company's logo plastered on it, of course) and are willing to get into the trenches and debug your own code.
Continue Reading: Save money, use VBA »
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: Export Outlook Contacts to Excel »
Here is part of the add-in code that exports Outlook Tasks into Excel. It works the same as the previous code that exports Calendar items, except we set a reference to the default Tasks folder (not Calendar), and I've also incorporated some new code which makes the sub more efficient by writing the data to an array, which is then dumped to the worksheet in one pass.
Continue Reading: Export Outlook Tasks to Excel »
Follow Me