Within the HR module, document templates can be uploaded to specific Locations and Job Titles. These documents can contain mail merge fields that will pick up the information from the relevant employees' details stored on the system.
This functionality is useful when creating contracts, or specific letters for employees who have recently joined the company. As long as the employee has been created within the HR module, the documents can then be produced with the correct information.
Adding the Merge Field
First, the document with the mail merge fields needs to be created.
- Open a relevant document (the contract/letter to be sent to the employee) and add the required fields to populate with the employee's details
The table below has a list of the available fields, which can be used to copy and paste into the document.
Table 1 - Mail merge fields
|The field name in EMS||Enter in Word Doc||The field name in EMS||Enter in Word Doc|
|Title||<?Title?>||Second Expense Manager||<?SecondaryExpenseManager?>|
|First name||<?Firstname?>||Primary Holiday Manager||<?PrimaryHolidayManager?>|
|Surname||<?Surname?>||Secondary Holiday Manager||<?SecondaryHolidayManager?>|
|Address 1||<?EmployeeAddress1?>||Primary Timesheet Manager||<?PrimaryTimesheetManager?>|
|Address 2||<?EmployeeAddress2?>||Second Timesheet Manager||<?SecondaryTimesheetManager?>|
|Address 3||<?EmployeeAddress3?>||Start Date||<?StartDate?|
|Address 4||<?EmployeeAddress4?>||Employee Number||<?EmployeeNumber?>|
|Town||<?EmployeeTown?>||Date of Birth||<?DateofBirth?>|
|Post Code||<?EmployeePostCode?>||Home Tel||<?HomeTel?>|
|Location Address 1||<?LocationAddress1?>||<?Email?>|
|Location Address 2||<?LocationAddress2?>||Employee Status||<?EmployeeStatus?>|
|Location Address 3||<?LocationAddress3?>||User Level||<?UserType?>|
|Location Address 4||<?LocationAddress4?>||Holiday Allowance||<?HolidayAllowance?>|
|Location Address Town||<?LocationTown?>||Bank Name||<?BankName?>|
|Location Address County||<?LocationCounty?>||Bank Address 1||<?BankAddress1?>|
|Location Address Postcode||<?LocationPostCode?>||Bank Address 2||<?BankAddress2?>|
|Division||<?Division?>||Bank Address 3||<?BankAddress3?>|
|Salary||<?Salary?>||Bank Address 4||<?BankAddress4?>|
|Job Title||<?JobTitle?>||Bank Address Town||<?BankTown?>|
|Rate (£/hr or shift)||<?PayAmount?>||Bank Address County||<?BankCounty?>|
|Pay Period (i.e. hour shift)||<?PayType?>||Bank Address Postcode||<?BankPostCode?>|
|Primary Absence Manager||<?PrimaryAbsenceManager?>||Account Number||<?AccountNumber?>|
|Secondary Absence Manager||<?SecondaryAbsenceManager?>||Account Name||<?AccountName?>|
|Primary Expense Manager||<?PrimaryExpenseManager?>||Payment Method||<?PaymentMethod?>|
|Tronc Rate||<?TroncRate?>||Eligibility Proof||<?EligibilityProof?>|
|Total Rate||<?TotalRate?>||Work Permit Type||<?WorkPermitType?>|
|Reports To Full Name||<?ReportsToFullName?>||Work Permit Expiry Date||<?WorkPermitExpiryDate?>|
|Reports To Job Title||<?ReportsToJobTitle?>||Work Time Directive Opt-Out||<?WorkTimeDirectiveOptOut?>|
|Job Title FTE Hours||<?JobTitleFTEhours?>||Employment Type||<?EmploymentType?>|
|Job Title FTE Shifts||<?JobTitleFTEshifts?>||Holiday Allowance||<?HolidayAllowance?>|
|Job Title FTE Days||<?JobTitleFTEdays?>||Paid by Rota||<?PaidByRota?>|
|Basic Holiday Allowance||<?BasicHolidayAllowance?>||FTE Shifts||<?FTEShifts?>|
|Continuous Service||<?ContinuousService?>||Holiday Display||<?HolidayDisplay?>|
|Contract Hours||<?ContractHours?>||Staging Date||<?StagingDate?>|
|Pension Scheme Description||<?PensionSchemeDescription?>||Date Valid Pension Notice Received||<?DateValidPensionNoticeReceived?>|
|Automatic Enrollment Date||<?AutomaticEnrolmentDate?>||Date Active Member Worker Join Notice||<?DateActiveMemberWorkerJoinNotice?>|
|Employee Percentage Deduction||<?EmployeePercentageDeduction?>||Employee Contribution Type||<?EmployeeContributionType?>|
|Employee Fixed Amount Deduction||<?EmployeeFixedAmountDeduction?>||Opt-In Date||<?OptInDate?>|
|Employer Percentage Deduction||<?EmployerPercentageDeduction?>||Date Invalid Opt-Out Notice Received||<?DateInvalidOptOutNoticeReceived?>|
|Employer Fixed Amount||<?EmployerFixedAmount?>||Date Valid Opt-Out Notice Received||<?DateValidOptOutNoticeReceived?>|
|Deferral Date||<?DeferralDate?>||Opt-Out Reference Number||<?OptOutReferenceNumber?>|
- Once the mail merge fields have been added, save the document
Adding the Document in HR
Once the new document has been created, it will need to be uploaded into the system.
- Go to HR > Administration > Document Management > Document Templates
If this function has been used previously there may be templates already uploaded. These can be deleted at any time. However, make sure a hard copy is stored onsite or scanned and uploaded to the employee file if necessary, as it will delete the template from their file.
- From this screen, select Upload New Template
Fig.2 - The 'Upload New Template' option from Document Templates
- Browse for the .doc file to upload and enter a Description
Fig.3 - Uploading the amended document
- Select Upload
- Select the relevant Locations
Fig.4 - Pulling over the relevant locations
- When the relevant locations have been assigned, select Next
- Select the applicable Job Title(s) within the location(s)
Fig.5 - Assigning the document to the applicable Job Titles
- Select Next
The new document has now been assigned. This will apply to all employees at the given locations and job titles.
Viewing the Documents Against Employees
Once documents have been uploaded to the portal, they can be run from an employee's file.
- Go to HR > Employees > Employee List > Select Employee > Employee Info > Document Management > View Templates
- From the list, open the relevant document by selecting View
Fig.6 - All documents that have been assigned to an employee - 'View' buttons appear on the right side
The document(s) should then appear with mail merge fields populated as expected.
Please sign in to leave a comment.