Code: Option Explicit Sub Send_email() Dim OutlookApp As Outlook.Application Dim OutlookMail As Outlook.MailItem End Sub.Ĥ. We need to send an email in Outlook so define another variable as “Outlook.Mailitem” as shown in the below screenshot. Code: Option Explicit Sub Send_email() Dim OutlookApp As Outlook.Application End Sub.ģ. This is the reference to the VBA Outlook Application. Application as shown in the below screenshot. Code: Option Explicit Sub Send_email() End Sub.Ģ. We will name macro as “send_email” as shown in the below screenshot. Create a Sub Procedure by naming the macro.
VBA Outlook How to Use Excel VBA Outlook Function toĥ hours ago 1.
