Pages Menu
Categories Menu

Posted by on Aug 24, 2013 in Tutorials | 0 comments

Introduction to VBA in Microsoft Outlook

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.



Related Articles:


Leave a Reply