Training Providers: Generate Joining Letters, Training Agreements and Enrolment Certificates From One Excel File
Before every session, the same documents to personalise: joining letters, training agreements, enrolment certificates. How to organise the Excel file, prepare the templates and generate everything without retyping a line.
To produce the start-of-training documents without retyping them one by one, keep a single Excel file per session, with one sheet for trainees and one sheet for companies, prepare one PDF template per document type, then generate each batch in one go: one joining letter and one enrolment certificate per trainee, one training agreement per company. The rule that prevents most mistakes: one spreadsheet row equals one document.
A new session always means the same series: send joining instructions to trainees, get the training agreements signed, hand over an enrolment certificate when the employer or the funder asks for one. Done in Word by duplicating last session's document, this is where mistakes creep in: a leftover example date, a truncated postcode, a gendered word that no longer matches the trainee. This article covers the start of a session; for the end (training certificates and completion certificates), see how to generate training certificates without management software.
Which documents should you prepare before a session starts?
Three documents come back at every session, but they do not concern the same people, and that is what matters when generating them. The legal references below are French, since that is where the training agreement is defined by law.
- The training agreement (convention de formation). The French Labour Code (article L6353-1) provides that it is concluded between the buyer of the training and the provider delivering it. When the training is funded by an OPCO, article D6353-1 lists what it must contain: title, objective and content, resources, duration and period, share of distance learning, how the training is run, monitored and assessed, price and payment terms. So there is one agreement per company or funder, not per trainee.
- A training contract instead of an agreement when a person trains individually at their own expense (article L6353-3). It is signed before final enrolment, and the trainee has ten days to withdraw (article L6353-5).
- The joining letter, one per trainee: dates, times, place or connection link, contact. It carries part of the information that article L6353-8 requires to be made available to the trainee before final enrolment (objectives, times, assessment methods, contact person, internal rules).
- The enrolment certificate (attestation d'entrée en formation), one per trainee, when the host company, the funder or a scheme asks for it.
These texts change over time: check them on Légifrance or the official Code du travail numérique before freezing your templates, and have your funder validate your agreements if it uses its own model. Mail merge only solves the typing, not the legal content.
How should you organise the session's Excel file?
The classic trap is putting everything on one row per trainee, company and price included. The agreement would then come out in as many copies as there are trainees from the same company. Split it instead:
- A 'Trainees' sheet: title, first name, last name, address, company, plus the session columns repeated on every row (course title, start and end dates, times, place, contact person).
- A 'Companies' sheet: company name, address, signatory, number of trainees, price, payment terms, and the same session columns.
- An ID or file-name column if you want to find each document easily later.
Repeating the session columns on every row looks redundant, but it is what guarantees that the joining letter, the certificate and the agreement show exactly the same dates. One copy-down and consistency is ensured. InOneShot reads the workbook's active sheet: save it with the right sheet displayed before each batch, or keep one file per sheet. For the general rules, see how to create one filled PDF per Excel row offline.
How do you handle gendered wording automatically?
An enrolment certificate often contains a sentence such as 'certifies that Ms X started the training on…'. In French, the past participle agrees with the trainee (entré or entrée); in English, pronouns and titles do. If you only place the name in the middle of fixed text, two problems appear: the wording does not follow, and a short name leaves a visible gap in the sentence.
The most reliable fix is to build the whole sentence in Excel, in a dedicated column, for example with a formula that picks the right word from the title column, then to place that single column on the template. The sentence is then always correct and always well aligned. One technical detail: InOneShot reads formula results as Excel last saved them. Open and save the workbook in Excel after editing it, especially if another program produced it, otherwise calculated cells may arrive empty.
How should you prepare the PDF templates?
Start from your current Word documents and save them as PDF after emptying the variable areas (names, dates, addresses): those spots will receive the spreadsheet columns. Use the occasion to proofread the template once and for all. Templates copied from session to session often share the same defects: a four-digit postcode, a typo in the course title, a numbered clause that went missing, example dates that differ from one document to the next. Fixed in the template, they disappear from every future session.
An agreement often runs to several pages: InOneShot accepts multi-page templates and lets you place fields on any page. Added text is written in a standard font (Helvetica), in black, with an adjustable size that shrinks automatically if the value is too long for its box; so keep special formatting (coloured headings, logo, fixed clauses) in the template itself. For the director's signature, an image can be placed once and repeated on every document: see how to add a signature image to bulk documents, which also explains what a signature image is legally worth.
How do you generate and file the documents?
Open the template, link the Excel file, place each column where it belongs, then generate: one PDF per row. Two settings save time when it comes to sending them out:
- File names: a pattern such as {LastName}_{FirstName} gives files you can identify at a glance, instead of numbered documents to rename.
- Merging into a single PDF: handy to print every joining letter of a session, or to archive the whole batch as one file.
Then save the field layout as a reusable template: next session, you only change the Excel file. To file those templates by document type and course, see how to organize your mail merge template library. Everything is processed on your computer: your trainees' names and addresses are not sent to any server, which also keeps your GDPR records simpler.
On cost, the free version of InOneShot generates 5 PDFs per batch, enough to test your templates on a few rows. For a session of twelve or fifteen trainees you need the Pro version, a one-time €39 with no subscription.
What does a PDF mail merge tool not do?
It does not replace training management software: it handles neither enrolments, nor invoicing, nor Qualiopi indicator tracking. It does not email the joining letters or collect electronic signatures: it produces PDFs ready to send, print or have signed with the tool of your choice. And it does not check the legal content of your agreements: if a clause is missing from the template, it will be missing from every generated document. It is a tool to remove retyping, not to replace proofreading the template.
Frequently asked questions
Do you need one training agreement per trainee?
No. Under article L6353-1 of the French Labour Code, the agreement is concluded between the buyer of the training and the provider: there is one per company or funder. A person training individually at their own expense signs a training contract instead (article L6353-3).
Can joining letters and agreements come from the same Excel file?
Yes, as long as the sheets are split: one row per trainee for joining letters and certificates, one row per company for agreements. Repeat the session columns (dates, place, title) on every row so all documents match.
How do you get gendered wording right automatically?
Build the whole sentence in an Excel column from the title column, then place that column on the template. Save the workbook in Excel so formula results are read correctly.
How many documents does the free version generate?
5 PDFs per batch. The Pro version, a one-time €39, removes that limit.
Does trainee data leave the computer?
No. The Excel file, the templates and the generated PDFs stay on your machine: nothing is sent to a server.
Going further
A well-prepared session comes down to one correct Excel file, a few templates proofread once, and documents that all match. Also read: how to generate training certificates without management software; HR mail merge: contracts, invitations and badges; how to add a signature image to bulk documents.
Ready to automate your PDFs?
Try InOneShot for free and generate your documents in one click.
Discover InOneShot