![]() We also need to create a new instance for a new mail by referring this variable to the previous variable (outlook object variable) as CreateItem. To write a mail message, we need to use the MailItem object ( outlook ) by declaring a new variable named emailItemObj. Step 05: Declare Variable for Email Sending Property To create one put the following line of code. The line of code is- Dim emailExcel As Outlook.ApplicationĪs we’ve declared an object variable earlier, we need to create an instance of a new object. In this step, we’ll declare a variable named emailExcel to refer to the outlook object. Step 03: Declare a Variable Referring to Outlook Object In the visual basic editor, write the subprocedure.Go to the Insert tab in the Visual Basic for Applications window.Let’s open a new module with the following step. ![]() Now we need to start a subprocedure in the visual basic editor.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |