Private Sub m_Inspectors_NewInspector(ByVal Inspector As Outlook.Inspector) Set m_Inspectors = Application.Inspectors Private WithEvents m_Inspector As Outlook.Inspector Private WithEvents m_Inspectors As Outlook.Inspectors Īnd here is the VBA code that will ask for the values to fill in based on the subject of the email: To keep things simple, I've created this small template with two fields to enter in a message body, and. This example shows how to insert variable information in an email template using a macro. Make Outlook email template with variables using VBA Create email template with fillable fields.Make Outlook email template with variables using VBA.So, the question is - how do I create a template that will prompt me to enter the information and automatically insert it into the appropriate place in a message? The get the answer, please continue reading :)

Editing data manually is not the best way, as there is always a chance you may forget to update some important details. But what if your template contains some variables that you need to change before an email goes off. If replying to repetitive emails is part of your daily routine, then most likely you are using Outlook templates to automate this part of your work. Three ways to create an email template with variables, text field or dropdown list that will ask for the values to fill in before sending out an email.