Content: Insert Field: Database fields

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.