С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