In this video, I walk you through the process of creating Word reports from Excel spreadsheets using Mail Merge. If you're a teacher or education leader managing student data, this simple yet powerful tool can save you hours of manual work! I’ll cover step-by-step instructions on how to merge data from an Excel file into personalised Word documents, allowing you to quickly create reports, certificates, or letters. Perfect for classroom management, assessment reports, or bulk communications!

What you’ll learn:

The basics of Mail Merge
How to format Excel sheets for merging
Creating custom Word templates

Resources:
Need more help or want access to the template files used in the video for your own training needs or practise? Join my Patreon today for exclusive templates, downloads and walkthroughs!
https://www.patreon.com/eduflip

Don’t forget to like, comment, and subscribe for more EdTech tips!

Thank you all our Channel members! If you'd like to become a member as well follow this link:
https://www.youtube.com/channel/UC_Mv2BsvWR03-s7S5CrNm3w/join

You can also join our Facebook Community here: https://www.facebook.com/groups/538644703169584


SERVICES AND SOFTWARE I USE DAILY:
Video editing: https://sethideclercq.com/camtasia
Amazing screenshots: https://sethideclercq/Snagit
Website hosting: https://sethideclercq.com/bluehost
Screenshots and GIFs: https://sethideclercq.com/snagit
Courses: https://sethideclercq.com/teachable
Email lists and newsletter: https://sethideclercq.com/convertkit
Website building: https://sethideclercq.com/wix

GEAR AND RESOURCES:
https://www.amazon.com/shop/flippedclassroomtutorials
https://kit.co/FlippedTutorials

My TPT Store: https://www.teacherspayteachers.com/store/eduflip

Disclaimer: Some of these links are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you. These videos have been made for educational purposes and all views or opinions expressed are my own.