Insert Condition fields
The fields available for making comparisons are drawn from your Aurea List Manager Members table. You may have
Aurea List Manager use fields from other tables if you specify them in Content > New Content > Advanced.
Note
For those upgrading from Aurea List Manager 5.0: If you are using the Aurea List Manager mailings menu to create mailings for your list, Aurea List Manager automatically set Enable Scripting to Admins Only if previously disabled, and change the Scripting Level to Full. For more information about these settings, see Utilities > List Settings > For Programmers > Email Scripting.
The table below describes the default Aurea List Manager member fields available; consult with your database administrator about additional fields available to you.
| Field Name | Description |
|---|---|
Additional_
|
Additional information about the recipient which you have added. |
Comment_
|
Comments about the recipient which you have added. |
ConfirmDat_
|
The date the recipient confirmed list membership. |
|
|
The most recent date the recipient last bounced. |
DateHeld_
|
The date the recipient was changed to |
DateJoined_
|
The date the recipient joined the list. |
DateUnsub_
|
The date the recipient unsubscribed from the list. |
Domain_
|
The domain portion of the email address For example lyris.com |
ExpireDate_
|
The date the recipient's list membership expires. |
EmailAddr_
|
A recipient's full Internet email address. |
FullName_
|
The full name of this recipient. |
List_
|
The name of the list this recipient is a member of. |
MailFormat_
|
The type of mail the member has opted to receive, whether
|
MemberID_
|
The recipient's unique Aurea List Manager |
MemberType_
|
The membership type of this member, whether |
NumBounces_
|
The number of times a recipient's mail has bounced |
Password_
|
The recipient's password. If the recipient has no password, the field is left blank. |
ReadsHtml_
|
Whether or not Aurea List Manager has detected if this recipient can read HTML. The default is F
or False. If you have set Aurea List Manager to detect HTML reading capability, and the recipient
reads a message with HTML, the value is "T for True. |
SubType_
|
The type of content this recipient is set to receive, whether digest, index, nomail, or mail. |
UserID_
|
The User ID information defined by you, such as a key back to another database.
|
More information about personalizing messages in Aurea List Manager
Inserting a condition in your content is an easy way to personalize your message. If you want to learn more about message personalization and scripting, see Message Personalization and Scripting.