Database fields
The Database Fields tab allows you to merge in information about your list members directly from your
members' database table. The default Aurea List Manager Member fields are always be displayed here. If you
have added additional fields to your members' table, or are using a foreign members' table, those field
names is also visible here.
The fields are divided into three types: Text fields, Number fields, and Date fields.
These fields are further explained below:
Text Fields
This drop-down box allows you to insert a text or text and numeric field into your message. The fields
available for mail merge are drawn from your Aurea List ManagerMembers table. You may have Aurea List Manager use
fields from other tables if you specify them in Content > New Content > Advanced.
Described in the table below are 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. The tag |
Comment_
|
Comments about the recipient which you have added. The tag |
Domain_
|
The domain portion of the email address (For example, |
EmailAddr_
|
A recipient's full Internet email address. The tag |
Fullname_
|
The full name of this recipient. The tag |
List_
|
The name of the list this recipient is a member of. The tag |
MailFormat_
|
The type of mail the member has opted to receive, whether |
MemberType_
|
The membership
status of this member, whether normal, confirm, private, expired, held, or unsub. The
tag |
Subtype_
|
The type of messages this recipient is set to receive, whether digest, index, nomail or mail. The tag
|
Userid_
|
The user ID information defined by you, such as a key back to another database. The tag |
Number Fields
This drop-down box allows you to insert a numeric field into your message. The fields available for mail
merge are drawn from your Aurea List ManagerMembers table. You may have Aurea List Manager use fields from other tables
if you specify them in Content > New Content > Advanced.
Described in the table below are the default Aurea List Manager member fields available; consult with your database administrator about additional fields available to you.
| Label | Description |
|---|---|
MemberID_
|
The recipient's unique Aurea List Manager member ID. The tag |
NumBounces_
|
The number of times a recipient's mail has bounced. The tag |
Date Fields
This drop-down box allows you to insert a date field into your message. The fields available for mail
merge are drawn from your Aurea List ManagerMembers table. You may have Aurea List Manager display fields from other
tables if you specify them in Content > New Content > Advanced.
Described in the table below are the default Aurea List Manager date fields available; consult with your database administrator
about additional fields available to you. If the field is blank, the date 01//70 00:00:00 is merged
in.
| Label | Description |
|---|---|
ConfirmDat_
|
The date the recipient confirmed list membership. The tag |
DateBounce_
|
The most recent date the recipient last bounced. The tag |
DateHeld_
|
The date the recipient was changed to |
DateJoined_
|
The date the recipient joined the list. The tag |
DateUnsub_
|
The date the recipient unsubscribed from the list. The tag |
ExpireDate_
|
The date the recipient unsubscribed from the list. The tag Using custom fields to personalize messages is a feature of Aurea List Manager Pro or Enterprise. Contact your account representative or contact us through our website if you want to upgrade to Aurea List Manager Pro or Enterprise. |