- Home
- Skills
- Workflow Automation
- Mail Merge Studio
More screenshots
Works with the AI Agents you already use
Mail Merge Studio
Turn Excel or CSV lists into personalised, editable Word documents. Map fields, check a real proof, and generate traceable batches with 60 complete examples. Free.
Free
Mail Merge Studio
Example session with this skill installed
Use Mail Merge Studio with the bundled course-completion example. Create certificates for all three fictional recipients. Keep the original CSV unchanged, use the supplied date mapping, check the longest name in a native proof, and deliver editable Word documents, PDFs if the converter is available, the reusable master and a row-by-row batch ledger.
- Read your context and instructions
- Compiled the mail merge studio
- Generated the data export
Course completion batch — local example
This is a reproducible fictional example from the included course-completion project, using the local workflow. It does not claim a verified Agensi buyer execution.
| Check | Result |
|---|---|
| Original source | course-completion.csv retained with its recorded SHA-256 digest |
| Source records | 3 |
| Ready / blocked / excluded | 3 / 0 / 0 |
| Native Word documents | 3 |
| Corresponding PDFs | 3, generated with the configured local converter |
| Word master | Retained for reuse |
| Ledger coverage | All 3 source records |
Documents produced
- 00017-Maya Bennett.docx and its matching PDF
- 00018-Zoë O’Connor.docx and its matching PDF
- 00019-Christopher Alexander Montgomery.docx and its matching PDF
The certificate states “Course completion certificate”, names the Editorial Illustration programme, includes the supplied participation statement and mapped date, and identifies Willow House Studio. The longest-name output was included in the native rendering checks. All names and addresses in this example are fictional.
Delivery structure
The example produces documents/, pdf/, templates/master-template.docx, the preserved input and the batch verification/ledger files in a fresh output directory. Word text and document structure remain editable; the PDF is the rendered proof. The ledger records every original row rather than hiding skipped records.
Next step
Approve the wording and proof before printing or sharing. For a correction, edit the record override and regenerate the selected record into a new revision. Keep the original source, prior output and complete row ledger. Physical stock alignment and Microsoft Word desktop editing still require your own acceptance check.
course-completion.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
One approved list. Many personal documents.
Create personalised editable Word documents from your Excel, CSV or TSV list. Map fields explicitly, review a real document proof, then generate the full batch or regenerate selected records without changing your original source.
Built for event organisers, educators, community groups, client-facing teams and independent studios. The complete Skill is free; there is no paid template unlock.
60 complete examples across 10 families
Certificates and recognition; events and identity; invitations and occasions; business and clients; education and training; community and membership; mailing and labels; personal and professional; teams and operations; arts and independent studios.
Start with a letter, certificate, invitation, badge, label, card, feedback sheet or notice. Four native compositions and 16 typography/colour foundations support different document needs. Adapt the content and structure to your task rather than treating the examples as fixed pages.
Editable documents, careful batches
- Native Word paragraphs, runs, tables, bullets and callouts remain editable. Reuse the Word master or bring a supported DOCX template with literal {{field}} placeholders.
- Keep original source bytes and their SHA-256 digest. Preserve leading-zero identifiers and distinguish zero from blank.
- Review mappings, date formats, missing fields, duplicates, long names and per-record corrections. Required-field problems block affected output; exclusion needs a reason.
- Retain a disposition for every source row. Selected regeneration writes a new revision with portable, unique filenames.
- Where the host has an approved Word-to-PDF converter, inspect the actual PDF proof and produce matching PDFs. Generic actual-size A4/US Letter cut sheets support small items.
- A local workbench supports editing, explicit Apply/Discard, stale-proof checks, and private project save/reopen. It does not send email.
What local validation demonstrates
All 60 examples were built with three fictional recipients each: 180 editable Word documents and 180 corresponding one-page PDFs were checked. Browser download/reopen, selected corrections and clean-package execution were also exercised. The gallery shows actual fictional outputs.
Requirements and honest limits
Requires a code-executing agent with file capabilities, Python and the declared libraries. PDF proof/export additionally requires an approved local converter and suitable fonts. No seller backend, paid API or email account is required.
Agensi buyer-side multi-file loading, relative Python imports under the no-save policy, runtime/font/converter availability, and generated document/master/private-project retrieval have not been verified. Loading SKILL.md alone is not an end-to-end compatibility test; platform verification is requested before approval. Generated files are intended work products; this listing does not promise downloadable or offline Skill source.
Microsoft Word desktop edit/save, physical printing, commercial label-stock alignment and real customer acceptance remain unverified. Selected regeneration over a 500-row source was tested; full 500-document batch performance was not. This is document preparation, not postal validation, certification, tax receipt issuance or electronic signing.
Agensi buyer-side multi-file/no-save execution, runtime/font/converter availability and generated work-product retrieval remain unverified. Microsoft Word desktop editing, physical printing, commercial label-stock alignment and real customer acceptance are unverified. Maximum input: 500 rows, 60 columns, 40 mapped fields, 10 MiB; full 500-document throughput not tested. No email sending, macros, legacy MERGEFIELD or remote PDF service.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 14 days ago
- Free with an Agensi account
Requires
Permissions
Read only user-selected spreadsheet/template inputs. Preserve original source bytes. Write generated documents, ledgers and private project bundles to a new user-approved output directory. Optional browser access is limited to the local workbench. No email account, remote sending or seller cloud is required. Private bundles contain source data and should only be shared deliberately.