Aristotle Support

Merge Codes

Article ID: 628
Last updated: 11 Mar, 2010

Merge Codes
The following tables show the Merge Code used for each field in Campaign Manager 
 
NOTE: When using WordPerfect for Windows, a blank line remains in the document if a Merge
Code is the only item on the line and the field is blank in CM5. Place a question mark (?) after
the Merge Code to have WordPerfect automatically remove the blank line when the field is
blank. 
 
The following Field Names and Merge Codes are available for both Mail Merges and Letter
Batches:

Field Name    Merge Code

Voter ID     VRNUMBER

Last Name    LASTNAME

First Name    FIRSTNAME

Mail Name    MAILNAME

Salutation  SALUTATION

Address Line 1   ADDRESS1

Address Line 2   ADDRESS2

Address Line 3   ADDRESS3

City     CITY

State     STATE

Zip     ZIP

County    COUNTY

Congressional District  CONGRESS

Carrier Route    CARRT

Home Phone#    HPHONE

Work Phone#  WPHONE

Fax Ph one #    FPHONE

Alternate Phone #   APHONE

Email     E_MAIL

Employer    EMPLOYER

Occupation   OCCUPATION

Birth Date    BIRTHDATE

Record Type    CONSTITUENTTYPE

Origin    ORIGIN

Affiliation    AFFILIATION

Sex     SEX

Precinct    PRECINCT

Upd ate Date    UPDATEDATE

Work Address Line 1   WADDRESS1

Work Address Line 2   WADDRESS2

Work Address Line 3   WADDRESS3

Work City     WCITY

Work State    WSTATE

Work Zip     WZIP

Work Carrier Route   WCARRT

Mail Address Line 1   MADDRESS1

Mail Address Line 2   MADDRESS2

Mail Address Line 3   MADDRESS3

Mail City     MCITY

Mail State    MSTATE

Mail Zip     MZIP

Mail Carrier Route   MCARRT

Default Address Line 1  DADDRESS1

Default Address Line 2  DADDRESS2

Default Address Line 3  DADDRESS3

Default City    DCITY

Default State    DSTATE

Default Zip    DZIP

Default Carrier Route   DCARRT

Household Mail Name   HOUSEHOLDMAILNAME

Household Salutation   HOUSEHOLDSALUTATION

The following Merge Codes are only available when running a Mail Merge. They are associated
with Contribution Subfile information. Because of the nature of the mail merge in a relational
database, information about specific contributions will not merge to the document. You can,
however, merge general contribution data.

Contribution Data     Merge Code

Total Contribution     TOTALCONTRIBUTIONS

Largest Contribution     LARGESTCONTRIBUTION

Average Contribution    AVERAGECONTRIBUTION

Last Contribution    LASTCONTRIBUTION 

Last Contribution Date    LASTCONTRIBUTIONDATE

Contribution Total for Year 1    YEAR1TOTAL

Contribution Total for Year 2    YEAR2TOTAL

Number of Contributions in Year 1   CONTRIBUTIONSYEAR1

Number of Contributions in Year 2   CONTRIBUTIONSYEAR2

NOTE: A more complete list of Merge Codes used for Mail Merges in CM5 can be found by
selecting Utilities on the Main Menu Bar, selecting Export Dataset, then selecting combined
Format.

The following Merge Codes are only available when running a Contribution Letter Batch:

Field Name    Merge Code


Date    DATE

Amount    AMOUNT

Period    PERIOD

Type    TYPE

Source    SOURCE

Note    NOTE

Check #    CHECKNO

Letter    LETTER

The following Merge Codes are only available when running an Issue Letter Batch:

Field Name    Merge Code

Date    ISSUEDATE

Issue    ISSUE

Staff Name    STAFF

Letter File Name   LETTER

This article was:   Helpful | Not helpful Report an issue


Article ID: 628
Last updated: 11 Mar, 2010
Revision: 1
Views: 424
Prev     Next
Word Processing       Creating a Mail Merge document