The Outlook Application object has several useful purposes. In this case, the Application object represents the Excel application. In Excel, the object at the top of the hierarchy is also the Application object. This is similar to what happens with the Excel object model. In other words, the Application object represents the Outlook application. The object at the top of the Outlook hierarchy is Outlook itself or, more precisely, the Application object. If you continue going down the hierarchy, you eventually find an object that doesn't hold other objects.Įven though the components of the Excel and Outlook object models differ, the basic idea behind them is pretty much the same. In more general terms, each object (anywhere in the hierarchy) can contain other objects. Those objects may, in turn, contain other objects. Within such a hierarchy, there's an object at the top. You can think of a VBA object model as a hierarchy that contains all the objects you can work with. Let's start by reviewing: What Is The Outlook Object Model In any case, several of the more general explanations I provide in the blog post about Excel's object model to which I link to above apply (with some adjustments) to the Outlook object model. For this reason, I provide a quick introduction to the Outlook object model in this section. Therefore, you need to have a good understanding of the object model of the application(s) you're working with.
When working with Visual Basic for Applications, you're (basically) manipulating the objects from the relevant application. I've also written other blog posts that explain different object models, such as that of the Ribbon Commander.Įach application (Excel and Outlook in this particular case) has its own object model. Therefore, I've previously created a comprehensive tutorial about Excel's object model. My focus in Power Spreadsheets is Microsoft Excel.
Since the main topic of this blog post is how to manipulate Outlook from Excel, let's start by taking a look at… The Microsoft Outlook Object Model: A Quick Introduction Learn More about Sending Email from Excel using VBA.Macro Examples To Send Email From Excel Using Outlook In Practice.
VBA Code To Send Email From Excel Using Late Binding.VBA Code To Send Email From Excel Using Early Binding.VBA Code To Send Email From Excel With Workbook As Attachment.VBA Properties And Methods To Control Email Delivery, Display And Saving.VBA Properties To Draft And Format The Email.VBA Properties To Specify Email Recipients.The Microsoft Outlook Object Model: A Quick Introduction.You can use it to quickly navigate to the section that interests you the most. The following table of contents lists the main topics I cover in this Excel tutorial.
You can get immediate free access to these example workbooks by clicking the button below. This Send Email from Excel using VBA Tutorial is accompanied by Excel workbooks containing the data and macros I use in the examples below. I provide practical examples of VBA code that you can easily adjust and start using right now.