Macros are designed to reduce keystrokes and mouse clicks. Here is a perfect example. It takes seven separate mouse clicks to use an Outlook email template as a new email. Here is a macro that does it in one.
The macro below is placed in the ThisOutlookSession module in the Outlook VBA screen – see image below.
Dim NewEmail As Outlook.MailItem
Set NewEmail = Application.CreateItemFromTemplate(“C:\Users\Neale Blackwood\AppData\Roaming\Microsoft\Templates\Webinar Pass Added Bonus.oft”)
Set NewEmail = Nothing
You need to replace the folder and file within the quotation marks with the folder and file on your system.
Don’t have a line break in the folder as above. The code was too long to fit in a single line and wrapped.
Once you have entered it you can use an icon on the Quick Access Toolbar to run it.
You need to click the save icon in the VBA window after copying it in.