Automate Bulk Certificate Generation & Emails

Customer: AI | Published: 27.02.2026
Бюджет: 30 $

My certificate template lives in a Word file that must be converted to PDF for each learner. Names, completion dates—and ideally their email addresses—sit in a single Excel sheet, and I want those columns to feed straight into the template in one sweep rather than by hand. The plan is to use that imported list, replace the placeholders, save every personalised certificate as <Name>-Certificate.pdf, and fire off an email with the PDF attached—100+ times in just a few minutes, completely error-free. Any approach is fine—VBA mail-merge, Power Automate, a Python script, even Google Workspace—so long as: • the entire run can start with a single click on my Windows 11 / Office 365 machine • every PDF carries only the right learner’s name and date • the PDFs reach the correct inbox with a short, editable email body Deliverables 1. The finished automation (macro, script or flow) and any support files 2. A concise setup guide so I can swap in a new Word template or updated Excel list later 3. A quick demo—live call or screen-recording—proving that at least 100 certificates are produced and dispatched in under five minutes Acceptance criteria • Zero mismatched names or dates • PDFs named consistently • Emails sent automatically without manual intervention Please outline which toolset you’ll use and how soon you can hand over the working solution.