Finance & Business
Mail Merge & Document Automation
Stop copy-pasting names into letters and emails
12 lessons4 modules9h 20m durationbeginner level
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 Works
- What Mail Merge Really IsPreview
- Building a Clean, Merge-Ready Data Source🔒
- Choosing the Right Tool for the Job🔒
Module 2: Mail Merge in Microsoft Word
- Your First Word Letter Merge, Step by Step🔒
- Formatting Numbers, Dates, and Conditional Text🔒
- Labels, Envelopes, and Email from Word🔒
Module 3: Personalized Bulk Email with Google and YAMM
- Setting Up Your First YAMM Campaign🔒
- Tracking, Scheduling, and Personalization at Scale🔒
- Deliverability: Staying Out of the Spam Folder🔒
Module 4: Generating Documents: Invoices, Certificates, and PDFs
- Spreadsheet to PDF with a Google Docs Template🔒
- Building Invoices and Statements That Add Up🔒
- Reusable Systems, Testing, and Avoiding Disasters🔒
Powered by StretchLearn