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.
OLE Automation, or “Automation” as it is commonly referred to, is an inter-process communication method created by Microsoft to allow scripting languages such as Visual Basic for Applications (VBA) to control automation objects. What this means in the realm of Microsoft Office and VBA is that a programmer can write code in one software application (ie. Word) that has the ability to control another (ie. Outlook). There are several reason a user might want to do this, and quite often centers around data enrichment, or reporting.
I find that people who are new to VBA have very grandiose goals. They want to take all the work they do in the course of a day, or even a week, and automate every last step of it. While in theory this would be amazing, it’s not always practical, and certainly not the best place for a beginner to start. You’d be surprised how much time you can save by automating small things like applying a custom number format to cells in Excel, or converting text into hyperlinks in a word document.
Visual Basic for Applications (VBA) is a programming language primarily found in Microsoft Office products (Excel, Word, PowerPoint, Access etc.), and serves mainly as a tool for automating workflows. It helps take repetitive and sometimes complicated tasks prone to human error, and executes them for you. A well thought out VBA script can not only save you a lot of time but can also drastically improve the accuracy for your work.