thankQ Help

Merge Field Name

Example Data

Description

ADMITNAME

M0854

The mailing id given on creation of a mailing.

MAILINGDETAILSERIALNUMBER

0000970

Can be used as the serial number of the contact but it is used when there are more than one barcode purpose id’s in a mailing.

BARCODEPURPOSEID

Used to insert a barcode into a template for:

DATAIMPORTBARCODEID

Used in Data Import mailing and reporting.

GROUPID

0000970

The id of a contact, search or group loaded into the mailing.

EXTERNALREFID

MBR000000002

Used to store the record identifier when generating a mailing from another module e.g. generating a membership mailing would cause the membership ID to be recorded here.

USESERIALNUMBER

0000970

Serial number of the Contact or Serial Number of the address record associated with that contact for that mailing.

TOTITLE

Mr

The main contact details. Please note that if the resolved address is that associated with an Organisation then the name of the Organisation will be set in ORGANISATIONNAME.

TOFIRSTNAME

First

TOKEYNAME

Surname

TOOTHERINITIAL

Initial

TOPOSTNOMINAL

MBE

NICKNAME

Nickname

PREVIOUSNAMES

PreviousName

ORGANISATIONNAME

Westpoint Dentists

TOENVELOPESALUTATION

Mr First Surname MBE

The Envelope and Letter Salutation fields that will based on the name of the contact and the lookup values you have set for the contact. Please note that if Apply Households and/or Joint Salutations is applied in a mailing the H/H Envelope and Letter salutations will be used in these merge fields.

TOLETTERSALUTATION

First

TOCONTACTPOSITION

Principal

The Contact Details that are normally displayed in the panel below:

OCCUPATION

Teacher

GENDER

Male

MARITALSTATUS

Single

DATEOFBIRTH

2/11/1987

WEBSITE

www.thankq.com.au

CAREOFPREFIX

c/o

This is always specified as c/o.

CAREOF

Mr Burns

The Address Fields as specified in this Contact Panel:

Note that Address Line 5 refers to the Street Number and Address Line 6 refers to the street name.

MAILINGDETAILSUBADDRESS

Desk 4

ADDRESSLINE1

275 Alfred Street

ADDRESSLINE2

Address Line 2

ADDRESSLINE3

NORTH SYDNEY

ADDRESSLINE4

NSW

ADDRESSLINE5

275

ADDRESSLINE6

Alfred Street

POSTCODE

2060

COUNTRY

Australia

CAREOFENVELOPESALUTATION

N/A

These merge fields are no longer used. Do not add them to your template.

CAREOFLETTERSALUTATION

N/A

CAREOFCONTACTPOSITION

N/A

SALESREGION

NORTH SYDNEY

This is the Federal Electoral Division.

DAYTELEPHONE

02 8888 7654

The contact details in the Telephone/Email panel.

EVENINGTELEPHONE

02 1234 5677

FAXNUMBER

02 9876 7876

MOBILENUMBER

0414 234 234

EMAILADDRESS

jonathemail@anemail.com

CCEMAIL

extra@anemail.com

The details of the contact as shown in the Online Details Panel.

Note: CCTO = CC Name

CCTO

DONOTMAIL

-1

The Contact Details as listed in the Do Not Communicate panel.

DONOTMAILREASON

Unsubscribe

DONOTEMAIL

-1

DONOTSMS

-1

DONOTPUBLISH

-1

DONOTCALL

-1

PREFERREDMETHOD

E-Mail

From the Address Info Panel.

Address Code 1: Address DPID

Address Code 2: Address Barcode

Address Code 3: Verification Message

ADDRESSCODE1

93348596

ADDRESSCODE2

1301013010101122123020333100131112013

ADDRESSCODE3

No full match (K0)

Include Text Rules Merge fields

INCLUDETEXTREF

Used with Include Text Rules

INCLUDETEXTNTHRULE

INCLUDETEXTFILE

Mailsort Merge fields

MAILSORT

BSPNUMBER

007 *

These fields are for Mailsort and the Sort Plan

BSPNAME

ST LEONARDS

PARCELZONE

N1

PRESORTINDICATOR

206

CATEGORY

Delivery Area

COMMENT

MAILINGQUANTITY

This can be set under Mailing Preferences and can be used to specify how many letters/brochures etc to insert into an envelope as some customers may request extra copies.

INFORMATION

Narrative is used to store search criteria relevant to the mailing in question e.g. the search applied when generating a mailing from the membership form.

NARRATIVE

0000970

BPay and Post Bill Pay Merge fields

BPAYBILLERCODE

120352

Used to generate BPay and Post Bill Pay information. Note last three Post Bill Pay fields are generated when option POST Billpay is selected.

BPAYREF

BD01300048713

BPAYCHECKSUM

00

POSTBILLPAYCODE

12035

POSTBILLPAYREF

P013000000048713

POSTBILLPAYCHECKSUM

00

POSTBILLPAYKEYINGLINE

12035  P013000000058713 00

POSTBILLPAYBCODESTR

000000000P013000000058713

POSTBILLPAYBCODE

(this is an encrypted value - Don't use)

Next Ask Merge fields

NEXTASK

10.00

Setup under Canvassing & Prospecting, Next Ask can have between 1 to 5 different percentages asking for donors to increase their giving.

You will need to use the option Apply Next Ask for these fields to be merged as well.

NEXTASK2

20.00

NEXTASK3

30.00

NEXTASK4

40.00

NEXTASK5

50.00

LASTDONATION

2.00

AVERAGEDONATION

2.00

DONORTYPE

Non-Regular

RFM merge fields

RANKR

5

Results from Recency, Frequency and Monetary Value (RFM Manager) Module under Canvassing & Prospecting. You will need to use the option Apply RFM Scores for the merge to work.

RANKF

5

RANKM

5

RFMSCORE

555

Other Details and Classifications

CHARITYNUMBER

35345

Fields from this panel in the contact form. Only Charity Number, Volunteer and Do Not Volunteer are available to merge.

VOLUNTEER

-1

DONOTVOLUNTEER

-1

TAXSTATUS

N/A

This is no longer used.

SOURCE

Mailing

All fields in the Classifications panel except for Primary Category.

SOURCE2

SOURCEDATE

26/09/2017

Audit merge fields

RECORDOWNER

Audit information for Record Creation, the record creation fields are all able to be merged except for Owner Code, Viewable Group and Hide Sensitive Data.

CREATED

19/10/2004 2:33:38 PM

CREATEDBY

ADMiT

MODIFIED

6/10/2022 1:24:47 PM

MODIFIEDBY

ADMiT

EXTERNALREF

IMP90154

Misc audit info for imports - merge fields do not include Type or the Web Info.

EXTERNALREFTYPE

Data Import

EXTERNALREFDATE

27/03/2010 10:12:15 PM

HTMLNOTES

Archived by ADMiT - 28-Jun-05

Merge field for the notes tab.

COUNTAMOUNT

Number of instalments

All fields in the Hard Donations panel can be included in the merge.

SUMAMOUNT

Total Donated

MAXAMOUNT

Maximum Donated

AVGAMOUNT

Average Donated

MAXDATE

Last Date Donated

MINDATE

First Date Donated

JOINTSALUTATION

Mr First Surname MBE

The household salutations associated directly with the contact being mailed e.g. if contact is a household sub-ordinate then these fields will be blank since only populated on head of household.

JOINTLETTERSALUTATION

First

DEFAULTTITLE

Mr

All of the Default Address fields can be merged. In addition some fields that are not displayed in the panel such as the Default name, title and Address Codes can also be merged as well.

DEFAULTFIRSTNAME

First

DEFAULTKEYNAME

Surname

DEFAULTADDRESSLINE1

275 Alfred Street

DEFAULTADDRESSLINE2

Address Line 2

DEFAULTADDRESSLINE3

NORTH SYDNEY

DEFAULTADDRESSLINE4

NSW

DEFAULTPOSTCODE

2060

DEFAULTCOUNTRY

Country

DEFAULTADDRESSCODE1

DEFAULTADDRESSCODE2

SUBADDRESS

Mailing Preference Sub-Address - this is tied to the Mailing Preference used in Mail Manager.

PLAINTEXTEMAIL

-1

Merge fields from the Online Details panel. The fields for Social Media cannot be merged.

CCEMAILADDRESS

esittest@test.com

CCNAME

test@test.com

CANVASSEE

-1

If a contact has been Canvassed By someone it will appear as a -1 in this merge field, 0 if not.

VOLSOURCE

Friend

Volunteering Fields can be merged. Tel refers to Emergency Number.

VOLSPECIALREQ

Needs a special diet

EMERGENCYNAME

0000008

EMERGENCYNUMBER

02 9964 5432

VOLUNTEERMANAGER

0000004

CRMPRIMARYMANAGER

training13

Contact Relations Panel

CRMSECONDARYMANAGER

training12

CRMPLAN

Bi-Monthly

CRMREFERMANAGER

-1

CRMNOTE

CRM Note

SECONDCONTACT

0000006

For organisation contacts only, this is the serial number of the secondary contact.

MEDICALREF1

Support Services fields, no longer used.

MEDICALREF2

MEDICALREF2DATE

DEFAULTRECEIPTREQUIRED

Yes

Merge fields for the Contact's Default Payment settings.

DEFAULTRECEIPTSUMMARY

No

DEFAULTSOURCE2

09031CA

TEMPMAINTITLE

Do not use these fields, they are involved in creating organisations but will likely not reflect the correct data.

TEMPMAINFIRSTNAME

TEMPMAINKEYNAME

TEMPSECONDARYTITLE

TEMPSECONDARYFIRSTNAME

TEMPSECONDARYKEYNAME

DEFAULTPRODUCTLEVEL

Used to detail the default price level to be applied when orders are created for that contact.

CONFIGTEXT1

Special fields that are custom configured to be displayed by thankQ. Do not use if these fields are not visible.

CONFIGTEXT2

CONFIGTEXT3

CONFIGTEXT4

CONFIGTEXT5

IC

Identity Card number and Type (for Singapore clients only).

ICTYPE

ALTTITLE

This panel can be activated via Lookup Values.  

Other keyboard characters can be copied and pasted into the fields here. This is useful for Non-Latin Alphabet names/addresses.

ALTFIRSTNAME

ALTKEYNAME

ALTADDRESS

SUMAMOUNTSOFT

These are the Merge Fields for Hard/Soft Donations of a Contact.

COUNTAMOUNTSOFT

SUMAMOUNTHARDNSOFT

COUNTAMOUNTHARDNSOFT

REFERRALSOURCE

These Support Services merge fields are no longer used.

QLDHEALTHREGION

QLDREGION

ISLANDER

WRITTENPRIVACYCONSENTHELD

VERBALPRIVACYCONDENTGIVEN

ADMITNAME1

M0854

The Mailing ID

SERIALNUMBER1

0000970

This contact’s serial number.

ADDITIONALID1

0000972

Used to store the record identifier when generating a mailing from another module e.g. generating a membership mailing would cause the membership ID to be recorded here.

PARAMETERVALUE1 to 100

(Varies)

See Field Rules for more information.