![]() Finally, you can click on the macro icon in the Quick Access Toolbar.In the new dialog box, give it a new name and specify an icon for it. Subsequently, you can change its appearance.Then in the new popup window, set “Choose commands from” to “Macros”.At first, click the down arrow in Quick Access Toolbar and select “More Commands”.Now follow the steps below to add this macro to Quick Access Toolbar: After that, exit the “Visual Basic” window.Attachments.Add ("C:\Attachments\Test File.docx") " & vbCrLf & vbCrLf & "This is just a test email template with Outlook VBA" & vbCrLf & vbCrLf & vbCrLf & "Yours Truly," & vbCrLf & vbCrLf & "John Smith" To = "Dear Johnny," & vbCrLf & vbCrLf & "I'm glad to write this email to you. 'You can change the concrete info as per your needs ![]() Set NewMail = obApp.CreateItem(olMailItem) Next, copy and paste the following VBA codes in a module. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |