Macro Instructions | Outlook Reply with Email Template [Macro #32] | Macro Monday 08.24.20
If you find yourself emailing the same response over and over you could create an Email Template. Email templates are a great way to save that perfectly drafted email and recall it again at a later date. One shortcoming in Outlook is that there isn’t an easy way to reply to an email directly with an email template. This is why we created the macro Reply with Email Template. This is an Outlook macro that will allow you to reply to an email with all the contents of a specific email template. You can run this macro for the current email selected in your inbox or from an open email. By Default, this macro will reply to all recipients. You can update the VBA code to only reply to the sender instead. Once running this Outlook macro will access your default email template file path and display an InputBox with all the available email templates to select from. Simply type the leading number of the email template you want to reply with and click Ok. This macro will finish by pulling in the selected email template’s contents to the active Outlook email body. By Default, the active email’s subject will remain but with an update to the VBA code you can replace it with the template’s subject. If the template you selected has attachments these will also be attached to the email.
First time using VBA? You just need to complete 3 easy steps that only take a couple minutes to complete: Activate the Developer Tab, Update Macro Security, Setup References for Leverage & Lean macros. I'll show you how to do all of this in this Macro Monday video!
Want to make this macro your own? These lines of code can be customized to personalize this macro.
30. ‘Set EmailCurrent = EmailCurrent.Reply ‘If you want to Reply with an Email Template This is the code line to update if you want to only Reply to the Sender and not all email recipients
31. Set EmailCurrent = EmailCurrent.ReplyAll ‘If you want to ReplyAll with an Email Template By Default the selected email will Reply to all email recipients. Remove this code line and update code line #30 to only reply to sender
37. FolderPath = “C:\Users\” & User & “\AppData\Roaming\Microsoft\Templates\” ‘Default Outlook Email Template path. You can update the FolderPath to somewhere else. The Folder Path will look to Outlook’s default file path where email templates are saved. You can update this to a different path if you save your email templates elsewhere
76. ‘EmailCurrent.Subject = EmailTemplate.Subject ‘Set Subject If you want to replace the active email’s subject with the selected email template’s subject
77. EmailCurrent.HTMLBody = EmailTemplate.HTMLBody & CurrentBody ‘Set Body Set the active email body with the email template’s contents and past email body content
91. ‘EmailCurrent.Send By Default the email will display for review before sending. If you are confident that the email can send immediately after finishing this macro update this code line
#LeverageLean #LessClicksMoreResults #MacroMonday #VBA #Macros
Checkout this Outlook Macro page: https://leveragelean.com/macros/outlo...
Find more content on our website: https://leveragelean.com
Watch all of our Macro Monday Videos on our YouTube playlist: • Macro Instructions | Macro Mondays
Subscribe to our YouTube Channel to stay up to date on all of the videos we are posting.
/ @leveragelean
Stay Awesome,
Brent Schneider
Leverage & Lean
Est. 2017