Merge fields to use with Letter Merging v2
| Core Pupil Merge Fields | Description (Example) |
|---|---|
|
«pupil.txtdob» |
Pupil date of birth (30th October 2016) |
|
«pupil.txtforename» |
Pupils Forename (Matthew) |
|
«pupil.txtfullname» |
Pupils Full name (Matthew Smith) |
|
«pupil.txtgender» |
Pupils Gender (Male) |
|
«pupil.txtinitials» |
Pupil Initials (MHS) |
|
«pupil.txtlabelsalutation» |
Pupil Label salutation (Mstr. M Smith) |
|
«pupil.txtlettersalutation» |
Pupil letter salutation (Mstr. Smith) |
|
«pupil.txtmiddlenames» |
Pupil middle name (Henry) |
|
«pupil.txtprename» |
Pupil preferred name (Matt) |
|
«pupil.txtsurname» |
Pupils surname (Smith) |
|
«pupil.txttitle» |
Pupil title (Mstr.) |
|
«pupil.txtDOB» |
Date of Birth |
|
«pupil.txtEmailAddress» |
Pupil school email address (Msmith@school.co.uk) |
|
«pupil.txtHomeEmailAddress» |
Pupil home email address (Msmith@gmail.com) |
|
«pupil.txtMobileNumber» |
Pupil mobile number (07654 456 765) |
| School Fields | Description (Example) |
|---|---|
|
«pupil.intNCYear» |
Pupils National Curriculum Year (NC) |
|
«pupil.txtForm» |
Pupils form (7HA) |
|
«pupil.txtAcademicHouse» |
Pupils Academic House (North House) |
|
«pupil.txtBoardingHouse» |
Pupils Residential House (St Martha’s) |
|
«pupil.txtType» |
Pupils boarding status (Day) |
|
«pupil.intSystemStatus» |
Current (1) Former (0) Applicant (-1) |
|
«pupil.txtSchoolID» |
Pupils iSAMS School ID (tyuio9876545789) |
| Admissions Fields | Description (Example) |
|---|---|
|
«pupil.txtadmissionsstatus» |
Admissions status (Registered) |
|
«pupil.txtenquirydate» |
Enquiry date (3rd March 2016) |
|
«pupil.txtenquirytype» |
Enquiry Reason (Word of mouth) |
|
«pupil.txtenrolmentform» |
Enrolement form (6FG) |
|
«pupil.txtenrolmentterm» |
Enrolement term (Autumn) |
|
«pupil.txtEnrolmentDate» |
Enrolement date (6th September 2017) |
|
«pupil.intEnrolmentSchoolYear» |
Enrolement academic year (2017) |
|
«pupil.intEnrolmentNCYear» |
Enrolement NC year (7) |
|
«pupil.txtEnrolmentHouse» |
Enrolement Boarding House (St Martha’s) |
|
«pupil.txtEnrolmentAcademicHouse» |
Enrolement Academic House (North) |
|
«pupil.txtScholarshipList» |
Awarded Scholarship (Academic) |
|
«pupil.txtScholarshipInterestList» |
Scholarship Interest (Music) |
|
«pupil.txtReferenceRequestedDate» |
Reference requested date (6th Oct 2016) |
|
«pupil.txtReferenceReceivedDate» |
Reference received date ( 10th oct 2016) |
|
«pupil.txtLearningSupportReceived» |
Learning Support received (Y/N) |
|
«pupil.txtInterviewDate» |
Interview date (12th November 2017) |
|
«pupil.txtInterviewTime» |
Interview Time (13:00) |
|
«pupil.txtInterviewNotes» |
Interview notes (Please arrive promptly……) |
|
«pupil.txtWithdrawnDate» |
Withdrawn date (12th July 2015) |
|
«pupil.txtWithdrawnReason» |
Withdrawn reason (Chosen alternative school) |
|
«pupil.txtRejectedDate» |
Rejected date (12th July 2015) |
|
«pupil.txtRejectedReason» |
Rejected reason (Did not pass entrance exam) |
|
«pupil.txtSchoolLink» |
School link (Father came to school) |
| Contact Fields | Description (Example) |
|---|---|
|
«parent.txtlabelsalutation» |
Contacts label salutation (Mr & Mrs G Smith) |
|
«parent.txtlettersalutation» |
Contacts letter salutation (Mr & Mrs Smith) |
|
«parent.txtaddress1» |
Address line 1 (Manor House) |
|
«parent.txtaddress2» |
Address line 2 (The Green) |
|
«parent.txtaddress3» |
Address line 3 (Turvey) |
|
«parent.txttown» |
Town (Bedford) |
|
«parent.txtcounty» |
County (Bucks) |
|
«parent.txtpostcode» |
Post code (MK7 8HY) |
|
«parent.txtCountry» |
Country (United Kingdom) |
|
«parent.txtaddresstype» |
Contact address location (Home) |
|
«parent.txtcontactsforename» |
1st Contact forename (George) |
|
«parent.txtcontactstitle» |
1st Contact title (Mr) |
|
«parent.txtcontactssurname» |
1st Contact surname (Smith) |
|
«parent.txtemail1» |
1st Contact email (GSmith@gmail.com) |
|
«parent.txtmobile1» |
1st Contact mobile (07654 788 998) |
|
«parent.txtsecondaryforename» |
2nd Contact forename (Lucy) |
|
«parent.txtsecondarysurname» |
2nd Contact title (Mrs) |
|
«parent.txtsecondarytitle» |
2nd Contact surname (Smith) |
|
«parent.txtemail2» |
2nd Contact email (LSmith@gmail.com) |
|
«parent.txtmobile2» |
2nd Contact mobile (076548 765 432) |
| Other School Fields | Description (Example) |
|---|---|
|
«school.name» |
School name (St Georges Primary) |
|
«school.address1» |
School Address line 1 (School Road) |
|
«school.address2» |
School, Address line 2 (Greens Norton) |
|
«school.address3» |
School Address line (Towcester) |
|
«school.town» |
Town (Northampton) |
|
«school.county» |
School county (Northamptonshire) |
|
«school.country» |
School country (England) |
|
«school.postcode» |
School postcode NN12 8UI) |
|
«school.title» |
School primary contact title (Mr) |
|
«school.forename» |
School primary contact forename (Simon) |
|
«school.surname» |
School primary contact surname (Roberts) |
|
«school.fullname» |
School primary contact surname (Simon Roberts) |
|
«school.initials» |
School initials (FGH) |
|
«school.profession» |
School primary contact profession (Headmaster) |
|
«school.salutation» |
School primary contact salutation (Mr) |
|
«school.type» |
School type (Primary) |
| Other Useful Fields | Description (Example) |
|---|---|
|
«Date» |
Current Date (29th September 2017) |
|
«Time» |
Current Time (09:00) |
|
«HeShe» |
Pupil noun capitalised (He) |
|
«heshe» |
Pupil noun lowercase (he) |
|
«HisHer» |
Pupil pronoun capitalised (His) |
|
«hisher» |
Pupil pronoun lowercase (his) |
|
«himher» |
Pupil pronoun lowercase (him) |
|
«HimselfHerself» |
Pupil pronoun capitalised (Himself) |
|
«SonDaughter» |
Parental relationship to Pupil (Son) |
|
«PP-Number» |
Parent Poral Activation Number (65432345) |
|
«PP-Password» |
Parent Portal Activation Password (GTREWYU) |
|
«ForenameApostrophe» |
Pupil forename with apostrophe (Matthew’s) |
|
«SurnameApostrophe» |
Pupil surname with apostrophe (Smith’s) |
|
<<--SIGNATURE-->> |
Placeholder for electronic signature |