Field summary for mail-merge renewals and blanket renewals

The following is a summary of the fields included in mail-merge renewal and blanket renewal files. Depending on the definitions in your database as well as the customer records, some of the fields listed may be blank. Click here for a list with detailed descriptions of the field contents for mail-merge renewal notices.

MMERG1 format:

Description	Field name	Maximum field length
Record number	RECNUM	7
Company address	COMADDR1-COMADDR5	40
Company phone	COMPHONE	20
Credit card info	CCBLOCK1-CCBLOCK3	31
Customer address	ADDRESS1-ADDRESS6	40
Publication code	PUBCODE	6
Publication name	PUBNAME1-PUBNAME2	30
Date	DATE	8
Order number	ORDERNUM	9
Effort number	EFFORT	2
Detail term description	TERMDESC	30
Detail price	PRICE	12
Detail shipping description	SHIPDESC	26
Detail shipping amount	SHIPCHARGE	12
Tax text	TAXDESC	26
Detail tax amount	TAX	12
Credit text	CREDITTEXT	26
Credit amount	CREDIT	12
Total text	TOTALTEXT	26
Detail total amount	TOTAL	12
Minimum copy text	MINTEXT	38
Offer 2 - Term description	OFFER2	30
Offer 2 - Price	PRICE2	12
Offer 2 - Offer message	OFFERTXT2	38
Offer 3 - Term description	OFFER3	30
Offer 3 - Price	PRICE3	12
Offer 3 - Offer message	OFFERTXT3	38
Offer 4 - Term description	OFFER4	30
Offer 4 - Price	PRICE4	12
Offer 4 - Offer message	OFFERTXT4	38
Offer 5 - Term description	OFFER5	30
Offer 5 - Price	PRICE5	12
Offer 5 - Offer message	OFFERTXT5	38
Message block one	MESSAGE1A-MESSAGE1D	40
Message block two	MESSAGE2A-MESSAGE2D	40
Expiration date	EXPDATE	20
Quantity	QUANTITY	4
Ship-to address	SHIPADDR1-SHIPADDR6	40
Payable to text	PAYABLETXT	18
Publication payable	PUBPAYABLE	30
Federal tax ID text	FEDTAXTXT	11
Company federal tax ID number	FEDTAXID	10
Customer telephone number	PHONE	20
Customer salutation	SALUTATN	43

MMERG2 format:

If you select the MMERG2 format code in your renewal package definitions, each record in your mail-merge file will include all of the MMERG1 fields plus the following ones:

Description	Field name	Maximum field length
Addressee street1	STREET1	40
Addressee city	CITY	26
Addressee state	STATE	2
Addressee zip or postal code	ZIP	10
Addressee zip+2	ZIP2	2
Addressee carrier route	CARRT	4
Addressee country code	CNTRYCODE	4
Addressee CASS certification date	CASSDATE	8
Addressee fax number	FAX	20
Addressee e-mail address	EMAIL	60
Addressee customer number	CUSAGENCY	9
Purchase order number	PONUM	20
Renewal series code	SERIES	6
Renewal package code	PACKAGE	6

MMERG3 format:

If you select the MMERG3 format code in your renewal package definitions, each record in your mail-merge file will include all of the MMERG1 and MMERG2 fields plus the following ones:

Description	Field name	Maximum field length
Addressee company	COMPANY	40
Addressee department	DEPT	40
Addressee prefix	PREFIX	12
Addressee first name	FNAME	20
Addressee last name	LNAME	30
Addressee suffix	SUFFIX	5
Addressee title	TITLE	40
Addressee street2	STREET2	40
Addressee country	COUNTRY	24
Addressee postal code position	ZIPLOCATE	1
Addressee sex	SEX	1
Addressee demographic codes	DEMOCODEA-DEMOCODED DEMODATA1-DEMODATA2	4 19
Addressee user ID	USERID	15
Addressee password	PASSWORD	15

MMERG4 format:

Description	Field name	Maximum field length
Record number	RECNUM	7
Publication code	PUBCODE	6
Renewal series code	SERIES	6
Renewal package code	PACKAGE	6
Renewal effort code	RENEFF	6
Customer address	ADDRESS1-ADDRESS6	40
Publication name	PUBNAME1-PUBNAME2	30
Date	DATE	8
Order number	ORDERNUM	9
Effort number	EFFORT	12
Type code 1	TYPE1	1
Description 1	DESCR1	38
Amount 1	AMOUNT1	12
Type code 2	TYPE2	1
Description 2	DESCR2	38
Amount 2	AMOUNT2	12
Type code 3	TYPE3	1
Description 3	DESCR3	38
Amount 3	AMOUNT3	12
Type code 4	TYPE4	1
Description 4	DESCR4	38
Amount 4	AMOUNT4	12
Type code 5	TYPE5	1
Description 5	DESCR5	38
Amount 5	AMOUNT5	12
Type code 6	TYPE6	1
Description 6	DESCR6	38
Amount 6	AMOUNT6	12
Type code 7	TYPE7	1
Description 7	DESCR7	38
Amount 7	AMOUNT7	12
Type code 8	TYPE8	1
Description 8	DESCR8	38
Amount 8	AMOUNT8	12
Type code 9	TYPE9	1
Description 9	DESCR9	38
Amount 9	AMOUNT9	12
Type code 10	TYPE10	1
Description 10	DESCR10	38
Amount 10	AMOUNT10	12
Type code 11	TYPE11	1
Description 11	DESCR11	38
Amount 11	AMOUNT11	12
Type code 12	TYPE12	1
Description 12	DESCR12	38
Amount 12	AMOUNT12	12
Type code 13	TYPE13	1
Description 13	DESCR13	38
Amount 13	AMOUNT13	12
Type code 14	TYPE14	1
Description 14	DESCR14	38
Amount 14	AMOUNT14	12
Type code 15	TYPE15	1
Description 15	DESCR15	38
Amount 15	AMOUNT15	12
Type code 16	TYPE16	1
Description 16	DESCR16	38
Amount 16	AMOUNT16	12
Type code 17	TYPE17	1
Description 17	DESCR17	38
Amount 17	AMOUNT17	12
Type code 18	TYPE18	1
Description 18	DESCR18	38
Amount 18	AMOUNT18	12
Type code 19	TYPE19	1
Description 19	DESCR19	38
Amount 19	AMOUNT19	12
Amount due	AMOUNTDUE	12
Term	TERM	4
Quantity	QUANTITY	4
Shipping method	SHIPMETHOD	20
Subscription type	SUBTYPE	1
Document descriptors	DOCDESC1-DOCDESC2	18
Message block one	MESSAGE1A-MESSAGE1D	40
Message block two	MESSAGE2A-MESSAGE2D	40
Expiration date	EXPDATE	20
Customer address	SHIPADDR1-SHIPADDR6	30
Company address	COMADDR1-COMADDR5	40
Company phone	COMPHONE	20
Publication payable	PUBPAYABLE	30
Credit card info	CCARDS	31
Company federal tax ID number	FEDTAXID	10
Purchase order number	PONUM	20
Addressee	ADDRESSEE	9
Customer number for bill-to customer	BILLTONUM	9
Customer number for ship-to customer	SHIPTONUM	8
Agency	AGENCY	6
Customer salutation	SALUTATN	43
Addressee prefix	PREFIX	12
Addressee first name	FNAME	20
Addressee last name	LNAME	30
Addressee suffix	SUFFIX	5
Addressee title	TITLE	40
Addressee company	COMPANY	40
Addressee department	DEPT	40
Addressee street1	STREET1	40
Addressee street2	STREET2	40
Addressee city	CITY	26
Addressee state	STATE	2
Addressee zip or postal code	ZIP	10
Addressee zip+2 (delivery point code)	ZIP2	2
Addressee country code	CNTRYCODE	4
Addressee country	COUNTRY	24
Addressee carrier route	CARRT	4
Addressee CASS certification date	CASSDATE	8
Addressee postal code position	ZIPLOCATE	1
Addressee sex	SEX	1
Addressee demographic codes	DEMOCODEA-DEMOCODED DEMODATA1-DEMODATA2	4 19
Customer telephone number	PHONE	20
Addressee fax number	FAX	20
Addressee e-mail address	EMAIL	60
Addressee user ID	USERID	15
Addressee password	PASSWORD	15