Mail Merge & Document Generation in Excel: Letters, Labels, Emails & Certificates
Personalise names and salutations, put amounts and dates into sentences with TEXT, choose paragraphs with IF, IFS and SWITCH, fill letter templates with placeholders and CHAR(10), print label sheets with WRAPROWS, build email bodies and mailto links, number certificates without gaps and run a three-stage dunning series: 8 hands-on labs at one language school, graded instantly.
The first 2 lessons are free — no account needed.
Lessons
- Personalisation: Full Names, Salutations, Name Blocks and Group GreetingsFree
- Numbers, Dates and Currency inside Sentences: TEXT FormatsFree
- Conditional Paragraphs: IF, IFS and SWITCH Decide What Each Letter Says Pro
- Letters from Records: Address Blocks, Templates with Placeholders and Line Breaks Pro
- Address Labels: Multi-Line Label Text and Label Sheets with WRAPROWS Pro
- Emails: Subject Lines, Bodies, mailto Links and a BCC List Pro
- Certificates: Results, Gap-Free Serial Numbers and Certificate Text Pro
- Capstone: A Three-Stage Dunning Run (Reminder, Second Reminder, Final Notice) Pro