Mail Merge (Edexcel IGCSE ICT)

Revision Note

Robert Hampton

Written by: Robert Hampton

Reviewed by: James Woodhouse

Mail merge

What is a mail merge?

  • A mail merge is a time saving way of creating multiple similar looking documents all in one go

  • It allows personalised mass production of documents

  • Mail merge uses two files:

    • a data source

    • a main document

  • A data source can be created from a word processing, spreadsheet or database management application

Case Study

A company wants to send a letter to all of its registered customers telling them about an event happening soon

They have created a letter that they want to use as a template (main document) and have created a spreadsheet of all the customers they would like to send the letter to (data source)

They would like each letter to be personalised by using the customers name at the start

The process of a mail merge would be:

  1. Create the template letter and leave blank spaces where any personalised data should go

  2. Connect the template to the data source

  3. Choose which fields in the data source should appear in the main document

  4. Complete the merge and have individual letters for each customer ready to print

A screenshot of a Word document describing a half-price event with up to 50% off, free gifts, and tips on how to shop the sale, set for July 7-9.
Creating a mail merge from a spreadsheet data source

Last updated:

You've read 0 of your 5 free revision notes this week

Sign up now. It’s free!

Join the 100,000+ Students that ❤️ Save My Exams

the (exam) results speak for themselves:

Did this page help you?

Robert Hampton

Author: Robert Hampton

Expertise: Computer Science Content Creator

Rob has over 16 years' experience teaching Computer Science and ICT at KS3 & GCSE levels. Rob has demonstrated strong leadership as Head of Department since 2012 and previously supported teacher development as a Specialist Leader of Education, empowering departments to excel in Computer Science. Beyond his tech expertise, Robert embraces the virtual world as an avid gamer, conquering digital battlefields when he's not coding.

James Woodhouse

Author: James Woodhouse

Expertise: Computer Science

James graduated from the University of Sunderland with a degree in ICT and Computing education. He has over 14 years of experience both teaching and leading in Computer Science, specialising in teaching GCSE and A-level. James has held various leadership roles, including Head of Computer Science and coordinator positions for Key Stage 3 and Key Stage 4. James has a keen interest in networking security and technologies aimed at preventing security breaches.