Print
|
|
|
Using Intrinsic Symbols
To use an intrinsic symbol in a cell, enter the symbol name (with underscores) in the Content tab of the cell. The symbol appears in the Symbols tab with the data type Intrinsic.
If you use the Add Symbol button in the Symbols Tab, you can enter the name of an intrinsic symbol but this creates a symbol of a non-intrinsic data type. You cannot assign the data type Intrinsic to a symbol created this way. If you use the name of an intrinsic symbol with a non-intrinsic data type, you cannot use the intrinsic symbol in the cell content.
The following are intrinsic symbols:
Intrinsic symbol |
Description |
_#BASE36(<content>)__ |
BASE36 encodes the value within the (). The value may also be a merge field. |
_#BR__ |
Tag for HTML. Line feed for text. |
_#CELLNAME__ |
Cell name. |
_#DROPDATE__ |
Drop date in (SQL) format YYYYMMDDHH24MISS. |
_#LF__ |
Line feed. ASCII character 10. |
_#MAILINGNAME__ |
Mailing name. |
_#URLENCODE(<content>)__ |
URL encodes the value within the (). The value can also be a merge field. |
_#URLENCODE(<content>)__ |
URL encodes the value within the (). The value can also be a merge field. |
_#VM__ |
Virtual MIME type. A single character: t | a | h |
CELLID |
CellID. |
CID |
Unique identifier of e-mail recipient. |
CLIENTID |
ClientID |
COMPFIRSTLASTNAME |
Computed first/last name. If the value seems invalid, the default value is merged into the cell content. |
COMPFIRSTNAME |
Computed first name. If the value seems invalid, the default value is merged into the cell content. |
COMPFULLNAME |
Computed full name. If the value seems invalid, the default value is merged into the cell content. |
DATEDAYABBRNAME |
Day name abbreviated. Example: Sun |
DATEDAYFULLNAME |
Full day name. Example: Sunday |
DATEDAYFULLNUM |
Full day number. Example: 05. |
DATEDAYNUM |
Day number in date. Example: 30 |
DATEMONTHABBRNAME |
Month abbreviated. Example: Jun |
DATEMONTHFULLNAME |
Full month name. Example: June |
DATEMONTHFULLNUM |
Full month number. Example: 06. |
DATEMONTHNUM |
Month number. Example: 6. |
DATEYEARABBRNUM |
Year number abbreviated. Example: 05. |
DATEYEARFULLNUM |
Full year number. Example: 2005. |
DROPDATE |
Date when the mailing is schedule to be sent, in the format YYYYMMDDHH24MISS. |
ECELLID |
BASE36 encoded cellid. |
ECID |
BASE36 encoded cid. |
ECLIENTID |
BASE36 encoded detectexpires value. |
EDETECTEXPIRES |
BASE36 encoded detectexpires value. |
EDSECUREI |
For internal use only. |
EDUSERHASHKEY |
For internal use only. |
EEMAIL |
BASE64 encoded _EMAIL__ value. |
EFIRSTNAME |
BASE64 encodeded _FIRSTNAME__ value. |
EFULLNAME |
BASE64 encoded _FULLNAME__ value. |
EGROUPID |
For internal use only. |
EINSTANCEID |
For internal use only. |
ELASTNAME |
BASE64 encoded _LASTNAME__ value. |
ELISTID |
BASE64 encoded _LISTID__. |
Recipient's e-mail address. |
|
EMAILGROUPID |
For internal use only. |
EMIME |
For internal use only. |
EOCID |
BASE36 encoded _OCID__. |
EOEMAIL |
BASE64 encoded _OEMAIL__. |
EOLISTID |
BASE36 encoded _IRIGINALLISTID__. |
FORMAT |
Format of the current row. One of: T | A | H | M. |
FTFCELL |
Whether the cell is original or has been forwarded to a friend. |
FTFLINK |
Abbreviation of actual link. |
HOSTEDLINK |
For internal use only. |
INSTANCEID |
For internal use only. |
INVALID |
Used to abort a merger. |
ISPKEY |
For internal use only. |
LISTID |
List that the e-mail recipient is part of for reporting purposes. |
MAILACTION |
For internal use only. |
MAILINGID |
MailingID. |
MAILTAG |
For internal use only. |
OCID |
Original CID. Only different for proofs and clones. |
OECID |
Original _ECID__. |
OELISTID |
Original _ELISTID__. |
OEMAIL |
Original _EMAIL__. Only different for proofs and clones. |
ORIGINALLISTID |
Original _LISTID__. |
REDIRECTDNS |
Domain Name to use to redirect the link. |
TIME12HOUR |
Hour portion of time in 12 hour format. Example: 5. |
TIME24HOUR |
Hour portion of time in 24 hour format. Example: 17. |
TIMEAMPMLC |
am or pm value of time in lowercase. Example: pm. |
TIMEAMPMUC |
AM or PM value of time in uppercase. Example: PM. |
TIMEMINUTE |
Minute portion of time. Example: 30. |
TIMESECOND |
Second portion of time. Example: 30. |
TRANSACTIONID |
For internal use only. |
UNSUBDNS |
Domain name to use for unsub link. |
UNSUBLINK |
Abbreviation of actual unsub link. |
UNSUBVERSION |
For internal use only. |
Print