Automate HR Onboarding Paperwork
New hire onboarding generates a mountain of paperwork. Offer letters, NDAs, benefits enrollment, policy acknowledgments, equipment agreements — all needing personalization per employee. For growing companies, this repetitive document generation is one of the most time-consuming tasks in the entire hiring process.
The Challenge
Manual onboarding document production is slow, error-prone, and does not scale. Consider what happens during a typical onboarding cycle:
For each new hire, HR teams must manually open a template, fill in the employee’s name, role, start date, and salary, adjust role-specific clauses and compensation details, export the result as a PDF, and then email it to the correct recipient. Now multiply that across five document types per employee — offer letters, NDAs, benefits enrollment forms, policy acknowledgments, and equipment agreements.
For a cohort of just 20 new hires, that translates to over 100 individual documents spread across five different templates. At enterprise scale, where hundreds of employees may onboard in a single quarter, the manual approach becomes completely unsustainable. Typos in compensation letters, mismatched dates in NDA agreements, and forgotten policy acknowledgments are not just embarrassing — they create real legal and compliance risks.
The cost is significant. HR coordinators spend an estimated 30 to 45 minutes per new hire on document preparation alone. For a company onboarding 50 people per month, that is 25 to 37 hours of pure administrative work — time that could be spent on strategic initiatives like improving the employee experience or refining the onboarding curriculum.
The Solution
Mergram replaces this manual cycle with a fully automated mail merge pipeline. Instead of editing documents one at a time, you prepare a single spreadsheet containing all new hire data and run merge jobs against your template library. Each job generates a complete set of personalized, publication-ready PDFs in seconds.
With Mergram, the workflow becomes:
- Prepare one spreadsheet with all new hire data — names, roles, start dates, salaries, department codes, benefit selections, and any other variables your templates require.
- Upload your document templates as PDFs — offer letters, NDAs, benefits forms, and more, each designed with placeholder fields for dynamic data.
- Map spreadsheet columns to template fields using the visual canvas editor — drag and drop field positions with pixel-perfect precision.
- Run merge jobs — each job generates personalized PDFs for every row in your spreadsheet.
- Email everything automatically — Mergram sends each document to the correct new hire with personalized subject lines.
Tip
Keep a master onboarding spreadsheet with consistent column headers. When new hires join, simply add their rows and re-run the merge jobs — no template changes needed.
Document Types
| Document | Key Merge Fields | Typical Use |
|---|---|---|
| Offer letters | Role, compensation, start date, reporting manager | Pre-boarding |
| NDA agreements | Employee name, company, effective date | Day-one signing |
| Benefits enrollment | Plan selections, dependents, coverage dates | Open enrollment |
| Policy acknowledgments | Employee name, policy version, date | Compliance tracking |
| Equipment agreements | Device details, serial numbers, return dates | IT provisioning |
| Direct deposit forms | Bank name, account type, routing number | Payroll setup |
| Relocation letters | Package details, moving allowance, temporary housing | Relocation offers |
Step-by-Step Workflow
- Export your HR data from your HRIS (Workday, BambooHR, Gusto, or any system that exports CSV or Excel). Include columns for every variable field your templates need.
- Upload your PDF templates to Mergram. These can be designed in Word, Google Docs, Canva, or any tool that exports to PDF.
- Open the visual editor and drag field placeholders onto each template. Position them exactly where you want the merged data to appear.
- Upload your spreadsheet and map each column to the corresponding field on the canvas.
- Preview a sample output to verify accuracy before generating the full batch.
- Run the merge job — Mergram generates all documents and can email them automatically to each new hire.
Results and Benefits
Organizations that automate onboarding document generation with Mergram typically see measurable improvements in their HR operations:
- 90% reduction in document preparation time per new hire — from 30-45 minutes down to under 5 minutes of setup.
- Zero manual errors in merged fields — names, salaries, and dates are populated directly from the source spreadsheet, eliminating typos.
- Consistent branding and formatting across every document, every cohort, every time.
- Faster time-to-productivity for new hires who receive complete, accurate onboarding packets on day one.
- Merge history — every generated document is tracked in merge history, making it easy to verify what was sent and when.
Tip
Use password protection for compensation-related documents like offer letters and salary breakdowns. Mergram can encrypt each PDF with a unique password from your spreadsheet, ensuring only the intended recipient can open it.
Getting Started
Getting started takes less than 10 minutes:
- Gather your templates — export your most-used onboarding documents as PDFs.
- Prepare your data — create a spreadsheet with one row per new hire and columns for every variable field (name, role, start date, salary, department, etc.).
- Upload to Mergram — drag your PDF template onto the canvas, then upload your spreadsheet.
- Map your fields — use the visual editor to place merge fields exactly where they belong.
- Preview and generate — check a sample, then run the full merge.
No credit card required. Start with your first template for free.