How does mail merge work, and how is data brought into a word-processed document?
Using mail merge to produce personalised documents (the main document and the data source, merge fields, and filtering recipients), and importing and linking data from other applications (spreadsheets and databases) into a word-processed document.
An SQA Higher Administration and IT answer on using mail merge to produce personalised documents, covering the main document, the data source, merge fields and filtering recipients, and importing and linking data from spreadsheets and databases into a word-processed document.
Reviewed by: AI editorial process; not yet individually human-reviewed
Have a quick question? Jump to the Q&A page
Jump to a section
What this key area is asking
A common administrative job is sending the same document to many people, personalised for each. The SQA expects you to use mail merge: the main document and the data source, merge fields, and filtering recipients, and to import or link data from other applications (spreadsheets, databases) into a word-processed document. These connect word processing to the spreadsheet and database areas.
How mail merge works
The main document and merge fields
The main document is created once. It contains the standard text and merge fields, placeholders that mark where personalised data goes. For example, a letter begins "Dear <
The data source, merging and filtering
The data source supplies the data, often a spreadsheet or database of customers. Merging combines the two, generating a personalised document per record. Filtering the recipients (for example only those who have not renewed) and sorting them (for example by postcode) means only the correct recipients get the merge.
Benefits and uses of mail merge
Mail merge is used whenever the same document must go to many people, personalised, for example renewal reminders, invitations, statements or mailing labels. Its benefits:
- Saves time: one main document produces hundreds of personalised copies, far faster than typing each.
- Reduces errors: the data comes from one source, so it is consistent and not re-typed.
- Targeted: recipients can be filtered so only the right people receive the document.
- Reusable: the main document and data source can be reused for the next mailing.
Importing and linking data into a document
Administrators also bring data from other applications into a document. A spreadsheet table or chart, or a database report, can be:
- Imported / embedded: a static copy is placed in the document; it does not update if the source changes.
- Linked (a dynamic link): the copy updates automatically when the source changes, but the link breaks if the source is moved or deleted.
This reuses data without re-keying, keeps figures consistent across documents, and saves time, the same idea as linking met in the spreadsheet area.
Examples in context
Example 1. Invitations from a database. An administrator runs a mail merge using an events database as the data source and a standard invitation as the main document, filtering to guests who replied "yes". Each guest receives a personalised invitation, produced in one operation, illustrating merge fields, the data source and filtering.
Example 2. A report with linked figures. A monthly report links a sales table and chart from a spreadsheet. When the spreadsheet is updated, the report's table and chart update automatically, so the figures are always current and never re-typed, showing linking data into a document.
Try this
Q1. Name the two main parts of a mail merge. [2 marks]
- Cue. The main document (the fixed text plus merge fields) and the data source (the list of recipients, for example a spreadsheet or database).
Q2. Describe two benefits of using mail merge. [4 marks]
- Cue. Saves time (one main document produces many personalised copies); reduces errors (data from one source, not re-typed); recipients can be filtered so only the right people receive it; the main document and data source can be reused (any two, developed).
Exam-style practice questions
Practice questions written in the style of SQA exam questions on this dot point, with worked answer explainers. The year tag is the paper they imitate, not the source.
SQA Higher style4 marksDescribe how mail merge works, naming the two main parts.Show worked answer →
Worth 4 marks. Name and describe the two parts and the process.
The main document and merge fields (about 2 marks). A main document (for example a standard letter) contains the fixed text plus merge fields (placeholders such as Name and Address) where personalised data will go.
The data source and the merge (about 2 marks). A data source (a list, spreadsheet or database of recipients) supplies the data. When merged, the software produces one personalised copy per record, inserting each recipient's data into the merge fields.
SQA Higher style4 marksDescribe two benefits of using mail merge, and one situation where it would be used.Show worked answer →
Worth 4 marks. Describe benefits and a use.
Benefits (about 3 marks). It produces many personalised documents quickly from one main document, so it saves a great deal of time compared with typing each one; it reduces errors because the data comes from one source; and recipients can be filtered so only the right people receive the document.
Situation (about 1 mark). Sending the same letter, personalised, to a large list of customers, for example a renewal reminder, an invitation or a statement.
Related dot points
- Creating and working with word-processed documents using advanced features (styles, sections, headers and footers, page and section breaks, columns, tables, templates, table of contents, track changes and comments) to produce well-structured business documents.
An SQA Higher Administration and IT answer on advanced word-processing features, covering styles, sections, headers and footers, breaks, columns, tables, templates, a table of contents, track changes and comments, used to produce well-structured business documents.
- Researching information and presenting it effectively, using editing, formatting and reviewing features (master slides, transitions, animations, multimedia and hyperlinks), the notes feature, and managing and printing a presentation in a range of formats (slides, handouts, notes pages).
An SQA Higher Administration and IT answer on presentations, covering researching and presenting information effectively, editing, formatting and reviewing features such as master slides, transitions, animations and hyperlinks, the notes feature, and managing and printing a presentation in a range of formats.
- Creating and using forms for data entry, creating reports (including grouped reports with totals), printing database results in a range of formats, and exporting data to spreadsheet, word-processing and presentation applications.
An SQA Higher Administration and IT answer on creating and using database forms for data entry, creating reports including grouped reports with totals, printing results in a range of formats, and exporting data to spreadsheet, word-processing and presentation applications.
- Managing worksheets and workbooks, consolidating data across sheets, creating dynamic links between software applications, and importing and exporting spreadsheet data from and to external sources.
An SQA Higher Administration and IT answer on managing worksheets and workbooks, consolidating data across sheets, creating dynamic links between applications, and importing and exporting spreadsheet data to and from external sources.
- Appropriate methods of communication (oral, written, electronic) and how to choose between them, and appropriate methods of research, including evaluating sources for reliability and presenting findings.
An SQA Higher Administration and IT answer on appropriate methods of communication and research, covering oral, written and electronic communication, how to choose the right method, and how to research and evaluate sources of information.