Introduction to VBA in Microsoft Outlook
Programming with VBA in Outlook allows for document manipulation that may be awkward or even impossible with standard presentation techniques. This may be accomplished by writing code directly in the Visual Basic Editor (VBE), which includes a window for writing code, debugging code, and code module organization. To find out how to access the VBE by adding the developer toolbar to your excel 2007, 2010 and 2013 versions of Outlook, please follow the appropriate link in the Related Articles section.
VBA within Outlook can be used to automate a variety of tasks from cleaning contact information to generating appointments, and can even be used to automate other Microsoft Office products through a process called OLE Automation.
When learning about VBA in Outlook it’s very important that a programmer become familiar with the Outlook Object Model. The object model is a representation of how all the different objects within Outlook (Application, AdressLists, Folders, Items etc.) interact with each other. By understanding the relationship of these objects, even if just at a high level, will make VBA much easier to develop in. Please follow this link for a high level tutorial on the Outlook Object Model.
Once you have an understanding of the Outlook Object Model I’m sure you’ll want to start writing your own code. If you are the kind of person who likes building everything from scratch, check out our code snippets section or if you’d prefer to work with some concrete and practical examples you can find them in our tutorials section.
- Turning on the Developer Ribbon Tab in Outlook 2007
- Turning on the Developer Ribbon Tab in Outlook 2010 and 2013
- Outlook Object Model
- Outlook Tutorials
- Outlook Code Snippets