An interactive fillable field is a field in your template that is replaced with the data you either enter or select via a dialog when inserting the template into an email message. You can create interactive fillable fields for text values, dropdown lists, date and time pickers, or values from datasets by using the WhatToEnter macro.
Here is a quick Interactive fillable fields cheat sheet:
This video explains how to create fields for entering a text value, selecting from a dropdown, picking a date or time, and selecting a value from a dataset.
If you want to have an interactive field for a text value in your template, use the Text field option of the WhatToEnter macro.
Tip. With the Insert nested macro button, you can open a list of macros that can be nested and select the one you need.
Tip. The HTML icon means that HTML is supported, so you can enter a piece of HTML code.
If you switch to the Advanced tab, you can specify:
When you're done, click OK.
When you insert a template containing a text-entry field into an email message, a dialog will appear making it possible for you to enter some new text or keep the default one.
To add an interactive field for a list item, use the Dropdown list option of the WhatToEnter macro.
Tip. With the Insert nested macro button, you can open a list of macros that can be nested and select the one you need.
Tip. The HTML icon means that HTML is supported, so you can enter a piece of HTML code.
If you switch to the Advanced tab, you can specify:
When you're done, click OK.
When you insert a template containing a field for selecting from a dropdown into an email message, a dialog will appear making it possible for you to select any list item.
If you want to have a field for picking a date from a calendar in your template, use the Date option of the WhatToEnter macro.
Tip. With the Insert nested macro button, you can open a list of macros that can be nested and select the one you need.
Tip. If you need a language tag that isn't listed under Language tag (locale), you can find the necessary language and country on the Supported locale codes page on the Microsoft Learn website, and then enter the corresponding tag from the "Code" column into the Language tag (locale) box. For example, to get the date spelled in Spanish that is spoken in the Dominican Republic, you'll need to enter "es-do".
If you switch to the Advanced tab, you can specify:
When you're done, click OK.
When you insert a template containing a date picker into an email message, a dialog will appear making it possible for you to select the necessary date from a calendar.
Tip. On clicking Format, you can change your date format preference if necessary.
Tip. You can also set the default format and language for dates by creating custom team, profile, or company account properties. To learn more, visit these help pages:
To create a field for a time picker, use the Time option of the WhatToEnter macro.
Tip. With the Insert nested macro button, you can open a list of macros that can be nested and select the one you need.
If you switch to the Advanced tab, you can specify:
When you're done, click OK.
When you insert a template that has a time picker into an email message, you'll see a dialog prompting you to select the necessary time.
If you'd like to create an interactive fillable field that will make it possible for you to select a value from a dataset, use the Dataset option of the WhatToEnter macro.
Tip. With the Insert nested macro button, you can open a list of macros that can be nested and select the one you need.
Tip. The HTML icon means that HTML is supported, so you can enter a piece of HTML code.
If you switch to the Advanced tab, you can specify:
When you're done, click OK.
When you insert a template that contains a field for selecting from a dataset into an email message, a dialog will appear, and you'll be able to select a value from the key column of the specified dataset.
You can use regular expressions to allow entering or selecting only specific values via the WhatToEnter dialog.
When you or your teammates insert such a template into an email message, the values entered or selected via the macro dialog will be validated against the specified regular expression. Non-matching values won't be inserted.
When inserting the WhatToEnter macro into your template, you can specify what text string to use in an email message depending on whether the result returned by the macro is empty or not.
You can also right-click a WhatToEnter macro placeholder in a template that you're creating or editing, select Copy on the menu that will appear, and then paste the macro.
Responses
I should've tried that! Thanks :)
You're most welcome, Leroy.
Good to know that our solution works for you.
If it's not too much trouble for you, I would appreciate it if you rate our app and write a few words on Microsoft Office Store. This motivates us and our developers in particular, to continue providing the best experience possible for you and helps others understand how our product can make their life easier. Thank you in advance.
Is there a way to insert the value of a What To Enter macro into multiple parts of the message? For example if it prompts for someone's name, we don't have to prompt multiple times?
Hello Leroy,
Thank you for the question.
Sure, it is possible to insert the same value to several places of your template with the What to Enter macro. Simply create the macro once, copy it using the key combination Ctrl+C and then paste it in the desired places in your template using the key combination Ctrl+V.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!