The Database Fields tab allows you to merge in information about your list members directly from your members database table. The default ListManager member fields will always be displayed here. If you have added additional fields to your members table, or are using a foreign members table, those field names will also be visible here.
The fields are divided into three types: text fields, number fields, and date fields.
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 ListManager members table. You may have ListManager use fields from other tables if you specify them in Content: New Content. Advanced.
Described here are the default ListManager member fields available; consult with your database administrator about additional fields available to you.
Additional_
Additional information about the recipient which you've added. The tag %%additional_%% will be inserted into your content.
Comment_
Comments about the recipient which you've added. The tag %%comment_%% will be inserted into your content.
Domain_
The domain portion of the email address (e.g., lyris.com). The tag %%domain_%% will be inserted into your content.
EmailAddr_
A recipient's full Internet email address. The tag %%emailaddr_%% will be inserted into your content.
Fullname_
The full name of this recipient . The tag %%fullname_%% will be inserted into your content. If no name is available, the email address will be inserted.
List_
The name of the list this recipient is a member of. The tag %%list.name%% will be inserted into your content.
MailFormat_
The type of mail the member has opted to received, whether 'M' (multipart-alternative, the default), 'T' (text) or 'H' (HTML). The tag %%mailformat_%% will be inserted into your content.
MemberType_
The membership status of this member, whether 'normal', 'confirm', 'private', 'expired', 'held', or 'unsub'. The tag %%membertype_%% will be inserted into your content.
Subtype_
The type of messages this recipient is set to receive, whether digest, index, nomail, or mail. The tag %%subtype_%% will be inserted into your content.
Userid_
The user ID information defined by you, such as a key back to another database. The tag %%userid_%% will be inserted into your content.
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 ListManager members table. You may have ListManager use fields from other tables if you specify them in Content: New Content. Advanced.
Described here are the default ListManager member fields available; consult with your database administrator about additional fields available to you.
MemberID_
The recipient's unique ListManager member ID. The tag %%memberid_%% will be inserted into your content.
NumBounces_
The number of times a recipient's mail has bounced. The tag %%numbounces_%% will be inserted into your content.
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 ListManager members table. You may have ListManager display fields from other tables if you specify them in Content: New Content. Advanced.
Described here are the default ListManager 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 will be merged in.
ConfirmDat_
The date the recipient confirmed list membership. The tag %%confirmdat_%% will be inserted.
DateBounce_
The most recent date the recipient last bounced. The tag %%datebounce_%% will be inserted.
DateHeld_
The date the recipient was changed to "held" status because of bouncing too much email. The tag %%dateheld_%% will be inserted.
DateJoined_
The date the recipient joined the list. The tag %%datejoined_%% will be inserted.
DateUnsub_
The date the recipient unsubscribed from the list. The tag %%dateunsub_%% will be inserted.
ExpireDate_
The date the recipient's list membership will expire. The tag %%expiredate_%% will be inserted.
Using custom fields to personalize messages is a feature of ListManager Pro or Enterprise. Contact your account representative at sales@lyris.comif you'd like to upgrade to ListManager Pro or Enterprise.