Mail-merge report automation
End-to-end pipeline that aggregates evaluation data, runs Word mail-merge, auto-fixes layout issues, and publishes finalized reports to the site.
// OUTCOME
- 01250+ hours saved per year on manual merging and design fixes.
- 02End-to-end zero-touch pipeline.
- 03Annual reporting cycle delivered consistently and faster.
// PROBLEM
Distinguished Clubs generates detailed Word evaluation reports for every member club every year. Each report pulled data from multiple sources (internal APIs, survey datasets, club records), used a Word mail-merge template, then required someone to manually fix recurring design and layout issues before publishing — 250+ hours a year of pure document grunt work.
// SOLUTION
- 01Aggregates evaluation data across internal APIs, surveys, and club records.
- 02Maps every required mail-merge field automatically.
- 03Runs the merge with the Word template.
- 04Auto-fixes the recurring design and layout issues that previously needed manual cleanup.
- 05Publishes finalized reports directly to the Distinguished Clubs site.
// STACK
PythonWord mail-merge automationMulti-source data aggregationCMS publishing
AUTOMATIONDOCUMENT GENERATIONMAIL MERGECMS INTEGRATION