Skip to main content
Finance & Business

Mail Merge & Document Automation

Stop copy-pasting names into letters and emails

12 lessons4 modules9h 20m durationbeginner level

Instructor: StretchLearn Faculty

About this course

This course teaches office managers, administrators, finance and HR staff, educators, and small-business owners to automate personalized documents and bulk email without any coding. You will build a reliable data source, master mail merge in Microsoft Word and Google Docs, run trackable email campaigns with Yet Another Mail Merge and Gmail, and generate batches of PDFs such as invoices, certificates, and statements from a single spreadsheet. Every lesson uses named tools and real settings, includes worked examples with actual field names and numbers, and ends with a concrete build step you complete in your own files.

Curriculum

Module 1: Foundations: Data Sources and How Merge Works3 lessons
  • What Mail Merge Really IsPreview45m
  • Building a Clean, Merge-Ready Data Source🔒50m
  • Choosing the Right Tool for the Job🔒40m
Module 2: Mail Merge in Microsoft Word3 lessons
  • Your First Word Letter Merge, Step by Step🔒50m
  • Formatting Numbers, Dates, and Conditional Text🔒50m
  • Labels, Envelopes, and Email from Word🔒45m
Module 3: Personalized Bulk Email with Google and YAMM3 lessons
  • Setting Up Your First YAMM Campaign🔒50m
  • Tracking, Scheduling, and Personalization at Scale🔒45m
  • Deliverability: Staying Out of the Spam Folder🔒40m
Module 4: Generating Documents: Invoices, Certificates, and PDFs3 lessons
  • Spreadsheet to PDF with a Google Docs Template🔒50m
  • Building Invoices and Statements That Add Up🔒50m
  • Reusable Systems, Testing, and Avoiding Disasters🔒45m
Powered by StretchLearn