Сomplete list of macros for templates

In Shared Email Templates for Outlook

The Shared Email Templates macros are created to help you avoid repetitive actions in your routine correspondence. For example, you can once insert a macro instead of attaching the same file over and over again, pasting certain email address into the To, Cc, Bcc fields, adding text to the Subject field, and much more. For the detailed guide on how to use macros, please refer to the How to use macros page.

In the list below, click on the macro of interest to see its description, syntax, and examples of use.

Tip. Many of the macros let you not only enter values but also select them from a drop-down list. For this, you need to embed the ~%WhatToEnter macro into square brackets.
Macro Description
FillTo
Inserts the specified email address(es) into the To field of a message or the Required Attendees field of a meeting. Any previously added addresses are deleted.

Syntax:
~%FillTo[email address 1; email address 2]

Examples:
~%FillTo[john@mydomain.com]

~%FillTo[john@mydomain.com; jim@anotherdomain.com]

~%FillTo[~%WhatToEnter[john@mydomain.com;​{title:"Email address"}]]

~%FillTo[~%WhatToEnter[john@mydomain.com;​​jim@anotherdomain.com;{title:"Email address",​multiselect,editable}]]

~%FillTo[~%WhatToEnter[{dataset:"Contact list",column:"Email",title:"Email address"}]]

More information

FillCc
Inserts the specified email address(es) into the Cc field of a message or the Optional Attendees field of a meeting. Any previously added addresses are deleted.

Syntax:
~%FillCc[email address 1; email address 2]

Examples:
~%FillCc[john@mydomain.com]

~%FillCc[john@mydomain.com; jim@anotherdomain.com]

~%FillCc[~%WhatToEnter[john@mydomain.com;​{title:"Email address"}]]

~%FillCc[~%WhatToEnter[john@mydomain.com;​jim@anotherdomain.com;{title:"Email address",multiselect,editable}]]

~%FillCc[~%WhatToEnter[{dataset:"Contact list",​column:"Email",title:"Email address"}]]

More information

FillBcc
Inserts the specified email address(es) into the Bcc field. Any previously added addresses are deleted.

Syntax:
~%FillBcc[email address 1; email address 2]

Examples:
~%FillBcc[john@mydomain.com]

~%FillBcc[john@mydomain.com; jim@anotherdomain.com]

~%FillBcc[~%WhatToEnter[john@mydomain.com;​{title:"Email address"}]]

~%FillBcc[~%WhatToEnter[john@mydomain.com;​jim@anotherdomain.com;​{title:"Email address",multiselect,editable}]]

~%FillBcc[~%WhatToEnter[{dataset:"Contact list",​column:"Email",title:"Email address"}]]

More information

FillSubject
Inserts the specified text into the Subject field of a message or the Title field of an appointment or meeting. Any previously added text is deleted.

Syntax:
~%FillSubject[Subject text]

Example:
~%FillSubject[Price list 2021]

~%FillSubject[~%WhatToEnter[Price list 2021;​{title:"Enter subject"}]]

~%FillSubject[~%WhatToEnter[Price January;Price February;​{title:"Enter subject",multiselect,editable}]]

~%FillSubject[~%WhatToEnter[{dataset:"Price lists",​column:"Price name",title:"Enter subject"}]]

More information

AddTo
Adds the specified email address(es) to the To field of a message or the Required Attendees field of a meeting. All the previously added addresses are kept.

Syntax:
~%AddTo[email address 1; email address 2]

Examples:
~%AddTo[john@mydomain.com]

~%AddTo[john@mydomain.com; jim@anotherdomain.com]

~%AddTo[~%WhatToEnter[john@mydomain.com;​{title:"Email address"}]]

~%AddTo[~%WhatToEnter[john@mydomain.com;​jim@anotherdomain.com;​{title:"Email address",multiselect,editable}]]

~%AddTo[~%WhatToEnter[{dataset:"Contact list",​column:"Email",title:"Email address"}]]

More information

AddCc
Adds the specified email address(es) to the Cc field of a message or the Optional Attendees field of a meeting. All the previously added addresses are kept.

Syntax:
~%AddCc[email address 1; email address 2]

Examples:
~%AddCc[john@mydomain.com]

~%AddCc[john@mydomain.com; jim@anotherdomain.com]

~%AddCc[~%WhatToEnter[john@mydomain.com;​{title:"Email address"}]]

~%AddCc[~%WhatToEnter[john@mydomain.com;​jim@anotherdomain.com;​{title:"Email address",multiselect,editable}]]

~%AddCc[~%WhatToEnter[{dataset:"Contact list",​column:"Email",title:"Email address"}]]

More information

AddBcc
Adds the specified email address(es) to the Bcc field. All the previously added addresses are kept.

Syntax:
~%AddBcc[email address 1; email address 2]

Examples:
~%AddBcc[john@mydomain.com]

~%AddBcc[john@mydomain.com; jim@anotherdomain.com]

~%AddBcc[~%WhatToEnter[john@mydomain.com;​{title:"Email address"}]]

~%AddBcc[~%WhatToEnter[john@mydomain.com;​jim@anotherdomain.com;​{title:"Email address",multiselect,editable}]]

~%AddBcc[~%WhatToEnter[{dataset:"Contact list",​column:"Email",title:"Email address"}]]

More information

AddSubject
Adds the specified text to Subject field of a message or the Title field of an appointment or meeting. Previously added text is kept.

Syntax:
~%AddSubject[Subject text]

Example:
~%AddSubject[Price list 2021]

~%AddSubject[~%WhatToEnter[Price list 2021;​{title:"Enter subject"}]]

~%AddSubject[~%WhatToEnter[Price January;Price February;​{title:"Enter subject",multiselect,editable}]]

~%AddSubject[~%WhatToEnter[{dataset:"Price lists",​column:"Price name",title:"Enter subject"}]]

More information

AttachFromURL
Attaches a file from the URL you specify.

Syntax:
~%AttachFromURL[a url of a file to attach]

Example:
~%AttachFromURL[https://email-templates.app/assets/attachment.txt]

More information

AttachFromOneDrive
Attaches a file from your OneDrive.

Syntax:
~%AttachFromOneDrive[a link to a file to attach]

Note. Do not copy/paste links from your browser or Teams; use only the links you get through the Open file dialog box when inserting the macro.

Example:
~%AttachFromOneDrive[Price List.xlsx;b!H0xYb9pCJ]

More information

AttachFromSharePoint
Attaches a file from your SharePoint.

Syntax:
~%AttachFromSharePoint[a link to a file to attach]

Note. Do not copy/paste links from your browser or Teams; use only the links you get through the Open file dialog box when inserting the macro.

Example:
~%AttachFromSharePoint[Document.docx;b!1fDQXB7eC0m]

More information

WhatToAttach
Reminds you to attach a file from your hard drive or SSD.

Syntax:
~%WhatToAttach[{title:"Window title"}]

Example:
~%WhatToAttach[{title:"Updated price list"}]

More information

InsertPictureFromURL
Inserts a picture from the URL you specify.

Syntax:
~%InsertPictureFromURL[a url of an image to insert]

~%InsertPictureFromURL[a url of an image to insert;width;height]

~%InsertPictureFromURL[a url of an image to insert;width;height;hidden=false]

Example:
~%InsertPictureFromURL[https://cdn.ablebits.com/_img-docs/outlook-plugins/shared-templates/desktop-intro-2.png;458;692]

More info

InsertPictureFromOneDrive
Inserts a picture from your OneDrive.

Syntax:
~%InsertPictureFromOneDrive[a link to an image file;width;height]

Note. Do not copy/paste links from your browser or Teams; use only the links you get through the Open file dialog box when inserting the macro.

Example:
~%InsertPictureFromOneDrive[Scheme.png;b!H0xYb9pCJ;234;12]

More information

InsertPictureFromSharePoint
Inserts an image from your SharePoint.

Syntax:
~%InsertPictureFromSharePoint[a link to an image file;width;height]

Note. Do not copy/paste links from your browser or Teams; use only the links you get through the Open file dialog box when inserting the macro.

Example:
~%InsertPictureFromSharePoint[Scheme.png;b!H0xYb9p;300;200]

More information

ClearBody
Clears the message body before inserting a template into your message.

Syntax:
~%ClearBody

More information

FromAccount
Checks if the email address in the From field is the same as the email address in the square brackets. If they differ, the template is not inserted.

Syntax:
~%FromAccount[email address from which the message should be sent]

Examples:
~%FromAccount[jessica@company.com]

More information

Note
Adds an inner note to a template.

Syntax:
~%Note[Text of a note]

Example:
~%Note[Only for corporate customers]

More information

Subject
Inserts the content of the Subject field into a message or the content of the Title field into the appointment/meeting body.

Syntax:
~%Subject

More information

Date
Inserts the current date into a message or to the appointment/meeting body.

Syntax:
~%Date

More information

Time
Inserts the current time into a message or to the appointment/meeting body.

Syntax:
~%Time

More information

WhatToEnter
Prompts you to enter some text every time you insert a template into a message. Offers four options: text field, dropdown list, date, dataset. Can be used as a value in square brackets in other macros.

Text field

Syntax:
~%WhatToEnter[Default value;{title:"Window title"}]

Example:
~%WhatToEnter[10%;{title:"Discount"}]

Dropdown list

Syntax:
~%WhatToEnter[Item 1;Item 2;Item 3;{title:"Window title"}]

~%WhatToEnter[Item 1;Item 2;Item 3;{title:"Window title",editable}]

~%WhatToEnter[Item 1;Item 2;Item 3;​{title:"Window title",multiselect,delimiter:"selected delimiter"}]

~%WhatToEnter[Item 1;Item 2;Item 3;​{title:"Window title",multiselect,editable,delimiter:"selected delimiter"}]

Example:
~%WhatToEnter[10%;20%;30%;{title:"Discount",multiselect,editable,delimiter:", "}]

Date

Syntax:
~%WhatToEnter[{date,title:"Window title"}]

Example:
~%WhatToEnter[{date,title:"Contract date"}]

Dataset

Syntax:
~%WhatToEnter[{dataset:"Dataset name",​column:"Target column",title:"Window title"}]

Example:
~%WhatToEnter[{dataset:"Promo",​column:"Discount",title:"Discount"}]

More information

MailboxProperties
Inserts the specified property of your Outlook mailbox.

Syntax:
~%MailboxProperties[Name of a mailbox property]

Examples:
~%MailboxProperties[EmailAddress]

~%MailboxProperties[~%WhatToEnter[EmailAddress;TimeZone;​{title:"Select mailbox property"}]]

More information

DatasetValue
Inserts a value from the specified dataset.

Syntax:
~%DatasetValue[{dataset:"Name of a dataset",column:"Name of a column",keyvalue:"Name of a value in a key column"}]

Example:
~%DatasetValue[{dataset:"Timetable",column:"Course C",keyvalue:"6/11/2021"}].

More information

ProfileProperties
Inserts the specified property of your Shared Email Templates profile (account).

The default properties are user name, first name, last name, full name, birthday, and email address that are associated with your Shared Email Templates profile (account). You can create additional properties and get them inserted as well.

Syntax:
~%ProfileProperties[Name of a profile property]

Examples:
~%ProfileProperties[UserName]

~%ProfileProperties[~%WhatToEnter[UserName;FirstName;​{title:"Select profile property"}]]

More information

TeamProperties
Inserts the specified property of the current team.

The default team properties are the display name, description, or Team Password. You can create additional properties and get them inserted as well.

Syntax:
~%TeamProperties[Name of a team property]

Examples:
~%TeamProperties[TeamPassword]

~%TeamProperties[~%WhatToEnter[TeamPassword;Description;​{title:"Select team property"}]]

More information

To
Inserts the content of the To field into a message or of the Required Attendees field to the appointment/meeting body.

Syntax:
~%To

More information

Cc
Inserts the content of the Cc field into a message or of the Optional Attendees field to the appointment/meeting body.

Syntax:
~%Cc

More information

Bcc
Inserts the content of the Bcc field into a message.

Syntax:
~%Bcc

More information

InsertRecipientFirstName
Inserts the first name of the recipient into a message or the meeting body if the name is displayed in the To/Required field. Otherwise, the email address is inserted.

Syntax:
~%InsertRecipientFirstName

Note. The macro may not work in some cases because of Outlook bugs.

More information

InsertRecipientFullName
Inserts the full name of the recipient into a message or the meeting body if the name is displayed in the To/Required field. Otherwise, the email address is inserted.

Syntax:
~%InsertRecipientFullName

Note. The macro may not work in some cases because of Outlook bugs.

More information

InsertRecipientLastName
Inserts the last name of the recipient into a message or the meeting body if the name is displayed in the To/Required field. Otherwise, the email address is inserted.

Syntax:
~%InsertRecipientLastName

Note. The macro may not work in some cases because of Outlook bugs.

More information

InsertSenderFirstName
Inserts the first name of the sender into a message.

Syntax:
~%InsertSenderFirstName

More information

InsertSenderFullName
Inserts the full name of the sender into a message.

Syntax:
~%InsertSenderFullName

More information

InsertSenderLastName
Inserts the last name of the sender into a message.

Syntax:
~%InsertSenderLastName

More information

FillLocation
Inserts the specified text into the Location field of an appointment or meeting. If Location is not empty, its content will be deleted.

Syntax:
~%FillLocation[Location text]

Examples:
~%FillLocation[Room 1]

~%FillLocation[~%WhatToEnter[Room 1;​{title:"Enter location"}]]

~%FillLocation[~%WhatToEnter[Room 1;​Room 2;{title:"Select location",multiselect,editable}]]

More information

AddLocation
Adds the specified text to the Location field of an appointment or meeting keeping the current information.

Syntax:
~%AddLocation[Location text]

Examples:
~%AddLocation[Room 1]

~%AddLocation[~%WhatToEnter[Room 1;​{title:"Enter location"}]]

~%AddLocation[~%WhatToEnter[Room 1;​Room 2;{title:"Select location",multiselect,editable}]]

More information

Location
Inserts the content of the Location field into the appointment or meeting body.

Syntax:
~%Location

More information

Responses

Andrew Howell says:
April 11, 2021 at 5:58 pm

Is it possible to make a macro that uses the attachment name in the body of an email.

Example:
Please see the attached (input name of attachment) estimate.

Reply

Hello Andrew,

Thank you for sharing your idea with us.

I've forwarded it to our development team. Thank you once again.

Reply

Is it possible to make a macro to start a new message with a user template? So many steps to dig through for an often used template.

Reply

Hello Jo,

Thank you for your question.

Unfortunately, Microsoft Mail API doesn't provide a possibility to implement this functionality in the add-in.

To quickly get access to your templates, we recommend to pin the add-in pane on one side of your Outlook window, add the templates you use most often to your Favorites and use shortcuts for them. Also, you can select some text in the message body and instantly search for templates that contain this text in names or content.

Please let us know if you have any other questions.

Reply

I am using the What to Enter macro and setting it to enter a date. When I enter the date, the template is populated with the day before.

Reply

Hello Sandra,

Thank you for reporting the problem. Our development team will try to reproduce it and find the cause.

Reply

Hi

Are you going to add the ~%FROM_ACCOUNT into Shared Email Templates? We use Shared Mailboxes to send the vast majority of our emails so the templates are a great way to ensure that they are being sent from the correct account and users do not need to change anything themselves.

Thanks

Reply

Hi Justin,

Thank you for sharing your idea with us. I will forward it to our development team and let you know via email. Have a nice day!

Reply

Are there any plans to add this macro to Share Email Templates yet? I would really like to move to the new product as it has several advantages over Template Phrases however we use this macro extensively so don't want to switch over until this has been added.
Thanks

Hello Justin,

Thank you for your question. Please note that the ~%FROM_ACCOUNT macro is already available in Shared Email Templates. For more details, please visit this help page.

Hi!,

Is there a way I can include a future date in the message body? I send out meeting reminder emails a few days in advance and want to be able to have that day pre-typed for me (e.g. have a date that displays the month and day of the next Wednesday). Is the there a way I can do this?

Thank you!

Reply

Hi Ted,

Thank you for your comment. Unfortunately, the functionality you've described is not available in the current version of the add-in. However, your idea sounds interesting and I have forwarded it to our development team. They will discuss this feature and we’ll be sure to let you know if/when it is available. Thank you!

Reply

Hello,
First of all, thanks for you tool.

I would like to insert the same text in several templates. This text doesn't often evolve but instead of copying the same text in many templates and have to change it manually everywhere from time to time, i would prefer to insert it as a template in templates where it has to appear, in order to only have to change it in one place when necessary.
Is it yet possible ? Could you implement that soon as a macro ?
Thanks.

Reply

It is not possible with the current version but will be available with the upcoming one. Within a week or two. The complete information about all releases you can find here: https://www.ablebits.com/docs/outlook-shared-templates-release-notes/

Reply

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.