EmailTemplate
Manages email templates used for standardizing outbound email communication.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier of the email template. | |
| Name | String | False |
The display name of the email template. | |
| DeveloperName | String | False |
Unique developer-assigned name of the email template. | |
| NamespacePrefix | String | True |
Namespace prefix associated with the template, used in managed packages. | |
| OwnerId | String | False |
User.Id |
ID of the user or queue that owns the email template. |
| FolderId | String | False |
ID of the folder where the email template is stored. | |
| FolderName | String | True |
Field containing FolderName information. | |
| BrandTemplateId | String | False |
ID of the associated letterhead (brand template) used in the email template. | |
| EnhancedLetterheadId | String | False |
ID of the EnhancedLetterhead associated with this record. | |
| TemplateStyle | String | False |
Specifies the style format used in the template, such as custom or standard. | |
| IsActive | Bool | False |
Indicates whether the email template is available for use. | |
| TemplateType | String | False |
Type of the email template, such as text, HTML, custom, or Visualforce. | |
| Encoding | String | False |
Character encoding used for the email template. | |
| Description | String | False |
Text description providing details about the email template. | |
| Subject | String | False |
The default subject line used when sending the email. | |
| HtmlValue | String | False |
HTML-formatted content of the email template. | |
| Body | String | False |
Plain text content of the email template. | |
| TimesUsed | Int | True |
The number of times this template has been used to send emails. | |
| LastUsedDate | Datetime | True |
The date and time when the email template was last used. | |
| CreatedDate | Datetime | True |
The date and time when the email template was created. | |
| CreatedById | String | True |
User.Id |
ID of the user who created the email template. |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the email template. |
| ApiVersion | Double | False |
API version associated with the template if it uses Visualforce markup. | |
| Markup | String | False |
Visualforce markup or additional template markup content. | |
| UiType | String | False |
Type classification for Ui. | |
| RelatedEntityType | String | False |
Type classification for RelatedEntity. | |
| IsBuilderContent | Bool | True |
Indicates whether the record has the BuilderContent characteristic. | |
| HasSalesforceFiles | Bool | True |
Indicates whether the record has SalesforceFiles. | |
| SOQL | String | False |
Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. | |
| ExternalIdColumn | String | False |
Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. | |
| FilterScope | String | False |
Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. | |
| SystemModstamp | Datetime | True |
System-generated timestamp indicating the last time the record was modified. | |
| LastModifiedDate | Datetime | True |
The date and time when the email template was last modified. |