by Svetlana Cheusheva, updated on
Looking for a way to create a drop down list in your email template? What about selecting multiple items? And is it possible to populate a dropdown from a database? You will find all the answers in this tutorial.
Email templates are a great way to save time on routine correspondence. But very often, you still have to manually input some variables when preparing an email to send out. In case you are entering unique data in every message, the optimal solution would be an email template with fillable text fields. When choosing from a predefined set of values, nothing beats a dropdown menu.
Regrettably, there is no easy way to make a dropdown in an Outlook template. Perhaps, you could approach the task by creating a custom form, placing a ComboBox control onto it, and somehow plugging a selected value into a message. But even for an experienced VBA programmer, that isn't a trivial task. Wait… did I say "no easy way"? I meant no easy traditional way :) Put in a little creativity, and you will have a working solution in a moment!
Though it is not possible to create a dropdown box directly in an email message, nothing prevents you from creating it in Word, and then simply copying to Outlook. Because Word is generally used as Outlook's email editor, the copied dropdown will retain all its functionality.
Because all the controls reside on the Developer tab, you need to add it to your Word ribbon first. We have the detailed instructions for Excel: how to enable the Developer tab. In Word, it is done exactly the same way.
With the Developer tab activated, carry out these steps to create a drop-down list:
In this example, we'd rather limit the user's input to a predefined set of values, so we are inserting a drop-down control:
When done, click the arrow in the box to make sure all the items are in place.
In Word, simply select the template's text and drop-down box you've just created, and press Ctrl + C to copy it to clipboard.
In Outlook, create a new message and press Ctrl + V to paste the copied content. Verify that your list is fully-functional, and all the items are there.
And then, save the message as an email template by clicking File > Save As > Outlook Template (*.oft). If you feel like you need more detailed instructions, please see How to create email templates in Outlook.
To open the template, go to the Home tab > New Items > More Items > Choose Form, and look in User Templates in file System. More details can be found in How to use Outlook email templates.
That was an easy solution, wasn't it? However, it does have a substantial flaw. With a content control in the message body, you won't be prompted to make a selection and may simply forget to pick an item. A lot more convenient would be placing a dropdown on some kind of a form that you cannot miss, and it is exactly what we are going to do next!
In this example, a drop-down list that we create will be displayed on a small form. And the value you pick from the list will be automatically placed into the appropriate part of the message.
Please don't feel intimidated - there will be no VBA and no custom forms. All we need is Shared Email Templates. If you don't have this add-in in your Outlook, you can quickly download a free version from Microsoft Store, and then follow the below steps.
To add a dropdown to your Outlook template, this is what you need to do:
When done, click Insert.
Tip: Personalize your email templates
Shared Email Templates provides a variety of different macros to help your messages sound personal and friendly. For example, to address the recipient by name, you can use ~%InsertRecipientFirstName or ~%InsertRecipientFullName.
Additionally, you can preset any of the email fields such To, Cc, Bcc and Subject. Please see a full list of macros to find out what other things you can automate.
To insert a template into a message, click the Paste icon to the left of the template's name or double-click the template:
A mini-form will pop up asking you to pick one of the items from the list:
A moment later, your message is ready to be sent:
As you know, a classic drop-down allows selecting just one value - when you pick another item, it replaces the current selection. But what if you wish to insert several values from the same dropdown into the same message? A multi-select dropdown with checkboxes is the thing you need. And Shared Email Templates makes it possible too!
To add a multi-select dropdown to your message template, use the WhatToEnter macro as described in the previous example. And then, enable the User can select multiple items option and specify the delimiter to separate the items. That's all there is to it!
Depending on the template text, the delimiter could be a comma, space, comma and space, or some word. In our example, it's the conjunction or surrounded by spaces, i.e. " or ".
Optionally, you can also allow the user to edit the selected items.
In the image below, the What to Enter settings on the right demonstrate how to configure an editable multi-select dropdown, and the highlighted placeholder on the left shows the desired outcome:
Clicking the Insert button replaces the placeholder with the following macro:
~%WhatToEnter[Chandler;Denver;Hartford;Little Rock;Phoenix;{title:"Select one or more cities", multiselect, editable, delimiter:" or "}]
And it lets you select as many values as you like:
Also, it shows exactly how your section will appear in the email. If something is wrong, you can make corrections directly in this box, e.g. type a different delimiter for this particular message:
Clicking OK pastes the template's text with all the selected items into an email like shown below:
In many situations, "hard-coded" items work just fine. However, when your list continuously changes, such an approach would be a needless waste of time because you'll have to update your template manually with every change. In this case, a far better solution would be to dynamically populate a drop-down list with values from a database. It is especially useful when your template contains several related variables like in this example:
Depending on which city is selected in the dropdown list, the corresponding phone number and email address should be fetched from the database and inserted into a message. Is that even possible? With Shared Email Templates, yes, it is :) Here's how:
It is important that the leftmost column in the dataset is always the key column - it is these values that will appear in the dropdown (cities in our case).
Clicking the Insert button will replace the <city> placeholder with the following code:
~%WhatToEnter[{dataset:"Regional offices", column:"City", title:"Select a city"}]
Eventually, our finalized email template takes the following look:
When using this template, you are only requested to select a city:
All the related data will be pulled from the dataset and pasted into the message automatically!
The real beauty of this method is when the source data changes, you only need to make changes in one place (the dataset), without having to update every template that uses that data.
To update an existing list, there's no need to recreate the macro from scratch - you can easily edit the macro's code itself. The below visual explains what each part of the code does:
Adding dropdown menus is just one of many unique features available with Shared Email Templates. After experimenting a bit, you will discover that there is almost nothing you cannot do. If there is such a thing, please let us know here in comments :)
I thank you for reading and hope to see you on our blog next week!
Shared Email Templates presentation (.pdf file)
Table of contents