Mail Merge (Edexcel IGCSE ICT)

Revision Note

Robert Hampton

Expertise

Computer Science Content Creator

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

You've read 0 of your 0 free revision notes

Get unlimited access

to absolutely everything:

  • Downloadable PDFs
  • Unlimited Revision Notes
  • Topic Questions
  • Past Papers
  • Model Answers
  • Videos (Maths and Science)

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

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.