#Api vba excel how to

Step 8:Р’В Since we want to send an attachment to the receiver we need to declare one variable as String which will hold the path for the attachment. Step 7:Р’В Like FSO, this variable is an object variable, so to access any other application we need to create some instances, create an instance as shown below using the SET keyword.Р”В¬ode: Set Email = New Outlook.Application Now let us declare a variable as an outlook application. Step 6:Р’В By giving reference to the outlook above, we can now access the properties of outlook in VBA. Step 5:Р’В Define a subprocedure as shown below. Step 4:Р’В Click on insert tab and insert a module in the VBA project.

#Api vba excel how to

Let us learn how to send emails through outlook from excel in VBA by an example.Р’В In this example, we will also send an attachment to the receiver, the same excel file we will be writing the code. In laymanРІР‚в„ўs term, what is the process and what is the requirement to send an email? An Email consists of an email address of the sender if there is a CC (Carbon Copy ) or a BCC and a subject line with an email body. Now the mailing feature is offered by Microsoft in Outlook, we will use methods and properties of outlook in excel to send emails.Р’В To send an email we need to know the basic of email also. This type of automation means accessing a feature of another application using any other application. It requires considerable knowledge of VBA and its methods to write the code to send emails from excel.Р’В Before we move to write and sending emails from excel let us know what this automation means. We can send emails through VBA and this is what we will learn in this article. VBA is not only limited to data in excel.