Chapter 4 — Word Processor – Mail Merge

What is Mail Merge?
Mail merge is a simple idea with helpful results: take one document that contains the parts which remain the same and combine it with a list of information that changes for each person. The word processor replaces placeholders in the document with real names, addresses or other details from the list. The result is many personalised documents produced automatically from one setup.

Parts of the process
There are always two parts: the template (the main document) and the data source (the table of information). The template has the fixed message and special placeholders called merge fields. The data source contains rows for each person and columns for each piece of information the template needs. When connected, the software generates a merged document for every row in the data source.

How it helps
Imagine writing 30 letters by hand. Mail merge lets you type the common parts once and then automatically fill in each person’s name and address. This saves time and reduces repeated typing mistakes. It also helps maintain consistent formatting: every letter uses the same font, spacing and layout unless you change the template.

Real life uses for students
In a school, mail merge can be used to make permission slips, report envelopes, labels for books or name badges for an event. Students learn to plan which text stays the same and which text will change. Planning is important because the more carefully you prepare the data and template, the fewer errors will appear in the final printed documents.

Classroom tip
Begin with a small list of 5–8 records for practice. This helps students see how changing one cell in the data table changes the merged output. Encourage checking spellings in the data table first, because corrected data leads to better-looking merged documents.

The document template
The template is the document you design first. It holds the text and layout that will be the same for everyone. For example, the heading, the main message and the closing line of a letter will usually not change. Within the template you leave places where personal information must be filled in. These places are called merge fields.

What are merge fields?
Merge fields act like blanks that the computer fills with information from the data source. Each merge field corresponds to a column name in the data table. For instance, a column named 'FirstName' will fill the merge field «FirstName» in the template. The software reads each row and replaces merge fields with actual data to create personalised documents.

Choosing good field names
Use clear, consistent names for columns such as FirstName, LastName, Address, City and PINCode. Avoid special characters and extra spaces in column headings because some programs may not recognise them. If headings are simple and match exactly with merge field labels, the connection works smoothly.

Placing fields carefully
Think about where each field appears. Place a name in the greeting line and address fields in the address block. Add punctuation and line breaks in the template so the final document looks correct. For example, write 'Dear «FirstName» «LastName»,' rather than placing punctuation in the data table.

Formatting fields
Some fields, like dates and amounts, may need special display. Templates can format dates or numbers so all merged documents show the same style. If you expect long names, leave enough space or choose a smaller font. Always preview to make sure merged fields fit the design and do not overflow or create awkward spacing.

What is the data source?
The data source is a table that holds the changing information for each person. Think of it like a spreadsheet where each row is one person and each column is one type of information. A clear table helps the mail merge software place the right values into the correct merge fields.

Designing good column headings
Use simple, consistent headings such as FirstName, LastName, AddressLine1, City and PINCode. Column headings should match exactly the names you will use when inserting merge fields. If a heading has extra spaces or different spelling, the merge field may not find the data and will appear blank in the output.

Filling the rows
Enter one record per row. Do not leave empty rows between data; blank rows can be read as empty records and cause extra blank letters. Put each piece of information in its own cell. For example, put house number, street and area in separate columns if you want them on separate lines in the final document.

File formats and saving
You can make a data table inside the word processor or use a spreadsheet program. A common and simple file format is CSV (comma-separated values), which many programs can read. When saving as CSV, be careful with commas inside data; text that includes commas should be enclosed in quotes so it is treated as one cell.

Checking and cleaning data
Check for spelling mistakes, consistent use of capital letters and correct PIN codes. Remove extra spaces at the start or end of cells and ensure there are no accidental line breaks. Clean data produces neat merged documents and avoids many common errors during preview and printing.

Why connect?
Connecting the template and the data source is the step where the word processor is told which table to use for the merge. Without this connection the merge fields in the template have nothing to display. The software usually asks you to choose the file or table that contains the recipient list and then links it to the open template.

How to connect
Open your template document and find the mail merge or mailing tools menu. Choose the option to select recipients or use an existing list. If the data is in the same document as a table, choose that table. If you saved the data as a spreadsheet or CSV file, browse to that file and open it. The word processor will show the names of the fields so you can insert them in the template.

Choosing the correct sheet or table
If your data file has more than one sheet, select the correct sheet with the data. If there are multiple tables in a document, select the intended table. The program may show a preview of the first few records so you can confirm you chose the right source.

Fixing connection problems
If the merge fields do not display data, check that the file is saved and not moved to another folder. Ensure the column headings match the merge fields. If the data source requires a password or is on a network drive, make sure you have access. Save both files in a safe folder so the link remains valid for later use.

Practice tip
Before a class activity, practise connecting a template to a small CSV you prepared. This helps students see how the file selection dialog works and reduces confusion during the lesson. Also show how to re-open a linked template and re-connect if the data file name or location changes.

Deciding field positions
Before inserting merge fields, read the template and decide where each piece of personal information should appear. Typical places are the salutation line ('Dear …'), the address block, or within the body where a name, class or roll number may be needed. Plan the layout so fields appear naturally within sentences and blocks of text.

Inserting fields
Use the 'Insert Merge Field' command from the mail merge toolbar. A list of available field names (from the data source) will appear. Click the field name to insert it at the current cursor position. You can insert many fields in a single line—like FirstName and LastName—to show a full name, but remember to put a space between them.

Spacing and punctuation rules
Always add punctuation (comma, colon, full stop) and spaces in the template around fields, not inside the data cells. If a field might be missing in some records, consider how the template will look if the field is blank. For example, avoid writing a hard-coded comma directly after a field that could be empty, or accept that there may be a blank line in such cases.

Using line breaks and paragraphs
For address blocks, use separate lines for each address field. Insert hard line breaks after street address and before city or PINCode. This ensures the address prints on multiple lines rather than appearing together on one line. If you need the entire address in one paragraph, keep all address fields on one line with commas in the template.

Grouping and order
Keep related fields together and in the correct order: for names use FirstName then LastName, for address use AddressLine1 then AddressLine2 then City then PINCode. If you join fields in the wrong order, the merged document will show information in an odd sequence. After inserting fields, always preview to confirm their arrangement and make small adjustments as needed.

Preview as a safety step
Previewing is a vital step that lets you check how the merged documents will look before printing or saving. When you preview, the merge fields are replaced by real data from the data source and you can view each record as if it were a finished letter. This prevents wasting paper and time on incorrect prints.

How to use the preview
Most word processors have a 'Preview Results' or 'View Merged Data' button. Click it and use the navigation controls to move through records one by one. Look at the greeting, address layout and any numbers or dates. Pay special attention to records with long names or missing fields, because these often reveal layout problems.

What to check in preview
Check for blank fields which may indicate a mismatch of field name or missing data. Look for unwanted extra spaces, doubled punctuation, wrong date formats or names that run into other text. If there are blank lines where an address line is missing, decide how to change the template or edit the data to avoid poor-looking output.

Test special cases
Previewing should include testing edge cases: a very long name, a missing PIN code, or a name with a title. Preview these records to see whether the font size, spacing, or line breaks need adjusting. For certificates and badges, test how a long name fits the design and change font size or layout if required.

Fixing problems seen in preview
If you find issues, stop printing and correct the template or the data source. Small fixes like changing a column heading, adding a space or moving a field are common solutions. After making changes, preview again to confirm that the problem is solved before printing the final set.

Choose the right printing method
After a careful preview, decide whether to print immediately or save the merged output first. You can print all records, a selected range, or just a few test pages. Choose the correct paper size and printer tray. For labels and envelopes, set the printer to use the tray that holds the special paper to avoid jams.

Test prints and alignment
Always do a test print of one or two pages on plain paper. Hold the test print against the label sheet or envelope to check alignment before printing on expensive label sheets or stationery. If alignment is off, adjust the label settings or margins in the template and test again until it matches.

Saving merged documents
Some programs let you save the merged results as one combined document, which is useful to keep a single file of all letters. Others allow saving each merged record as a separate file, which is helpful when you need to email each person separately or file each child's letter in their folder. Choose the method that fits your needs and the school's rules for handling documents.

File naming and organisation
If saving individual files, use a sensible naming pattern such as Class6_Letter_Ravi.pdf so you can find files later. Store templates and data sources in a clear folder and keep a backup. For important documents, save both the editable version and a PDF copy to avoid format changes when opened on another computer.

Final checks and environmental care
Before printing a large batch, re-check spellings and get teacher approval. Print only what you need to reduce paper waste and follow the school's rules on handling student data. When printing on special paper, feed one sheet at a time if the printer is prone to jams.

Using merge for labels and envelopes
Labels and envelopes are common outputs for mail merge. Labels are small sticky areas on a sheet and must be aligned precisely. Envelopes require the address to be positioned on a larger area with correct orientation. Mail merge can fill many labels or envelopes quickly from the same data source and template.

Selecting the right layout
Choose the exact label or envelope template that matches your paper. Most word processors include popular label sizes and brands. If the exact layout is not listed, you can create a custom label by measuring the height and width of a single label and setting margins and spacing accordingly. For envelopes, choose the envelope size the printer supports and set the feed direction.

Placing fields inside label areas
Insert merge fields into the label template just like a normal document, but ensure they sit within the borders of each label box. For address labels, place name on the first line, street on the second and city and PINCode on the third. Use smaller fonts if a name or address is long, but check legibility after printing.

Test and adjust
Always print a test page on plain paper and hold it against a label sheet to see if text falls within the label outlines. If the text is too high or too low, adjust top margins or label vertical spacing. For envelopes, feed a blank envelope and mark where the printer placed the text, then tweak the envelope layout if needed.

Helpful tips for class use
When using label sheets for many students, print in small batches to avoid wasting many labels if alignment is wrong. Label sheets can be expensive; so practising on plain paper helps. For envelopes, practise feeding one envelope at a time until you are confident the printer handles the special paper well.

Finding common errors
When using mail merge, common problems include blank fields, wrong field names, extra spaces, misplaced punctuation and format differences for dates or numbers. Troubleshooting means checking both the template and the data source to find the source of the error and fixing it so the final documents look correct.

Blank or incorrect fields
If a merge field appears blank in the merged output, verify that the column heading in the data table matches the merge field exactly, including capitalization and spaces. Then check that the specific row has a value for that column. If the column heading uses 'First Name' but the merge field is 'FirstName', they will not match. Correct headings or re-insert the right merge field.

Handling missing values
Some records may lack certain details. Decide whether to fill missing data in the table or change the template wording to avoid awkward gaps. For example, avoid writing 'City: «City»' if many records do not have a city; instead write the address block so a missing field causes no visible error line. For Class 6, simple edits and data checks are usually enough rather than advanced conditional fields.

Fixing format problems
If dates or numbers look wrong, either change the data source to use the desired format or set the field format in the template if the software allows. Remove unwanted extra spaces in the data table by editing cells. If text overlaps or names are too long, reduce font size slightly or allow wrapping within the design.

Testing after fixes
After making corrections, use preview again and test-print a few pages. Troubleshooting is often an iterative process: fix, preview, test-print, and repeat until the output is correct. Teach students to save changes frequently and to make small test prints to avoid wasting paper.

Applying mail merge to different outputs
Mail merge is useful for many kinds of school materials beyond letters. Certificates, invitations and badges often have the same layout for everyone but need a name, class or award filled in for each person. With a certificate template and a list of recipients, you can produce many personalised certificates quickly and consistently.

Designing for long names
Certificates must look neat, so design the template with enough space for longer names. Choose a clear font and set a maximum font size that fits most names. If a name is unusually long, preview and then consider manually reducing the font size for that single record after the merge. Teach students to look out for overflow and to test a few long names during preview.

Paper and print quality
Certificates are often printed on thicker paper or coloured stock. Perform test prints on plain paper first to check alignment and content. When ready, print certificates slowly and in small batches to avoid printer jams. For invitations, choose card paper and test the fold and orientation so the design appears correctly on the final folded card.

Practical classroom uses
Teachers can prepare award lists and merge names to create prize certificates at the end of term. For events, use mail merge to produce personalised invitation cards with guest names and seating details. Badges for a function can be made by merging names into a badge template and printing them on card or badge sheets.

Sharing and finishing
After merging, certificates can be saved as PDFs to share with parents or school staff, or printed and signed by the teacher. Encourage students to preview carefully, do a test print and obtain teacher approval before final printing. This ensures that certificates and invitations are professional and error-free.

Organising files
Keep your template and data source files organised in a clear folder structure. Use names that describe the content, for example 'Class6_Invitations_Template' and 'Class6_GuestList.csv'. This helps you and others find the correct files later and avoids accidentally connecting the wrong data source to a template.

Sensible saving choices
Decide whether to save merged output as one combined document or as individual files. A single file is good for record-keeping and printing at once. Individual files are useful if each document needs to be emailed or stored separately. When saving, include a date or version number so you can track changes, for example 'Invitations_2026-08-01.pdf'.

Sharing with permission
Before sharing lists that contain personal details, always seek permission from a teacher or guardian. Do not email lists with phone numbers or home addresses to everyone. If you must share merged documents, consider removing private data or sending only to authorised people. Schools often have policies on sharing student information—follow those rules carefully.

Privacy and safe handling
Close files and sign out on shared computers so others cannot access sensitive information. Delete or archive old lists that are no longer needed, and ask a teacher about secure storage options if required. Teach students to never post personal details online without permission and to treat other people's contact information with care.

Backup and responsibility
Keep a backup of important files on a school server or a USB drive so you do not lose work. Make sure the backup storage is also secure. Responsibility for data lies with the person who created or used it; always follow the school's instructions about data retention and disposal.

Activity goal
This activity guides students to make personalised permission slips or short letters using mail merge. The aim is to practise the whole process: create a data table, design a template with merge fields, link the data, preview the results and print or save the final personalised letters. Working with a small class list of 6–8 records helps students learn quickly and see immediate results.

Step-by-step approach
1. Plan the template: decide the fixed text (for example, a permission message) and which parts will change (student name, class). 2. Create the data table with headings such as FirstName, LastName and Class, and fill 6–8 rows with example student information. 3. Save the data table in a supported format like a document table or CSV. 4. Open a new letter template and insert merge fields in the correct places: greeting, body and closing. 5. Connect the data source to the template and use 'Preview Results' to view each personalised letter.

Teacher guidance and checks
The teacher should check that students used correct column headings, that there are no blank rows in the data table and that personal data is appropriate for class use. Students should be encouraged to perform a test print on plain paper to check layout, spacing and spelling before printing on final letterhead or special paper.

Learning outcomes
After this activity students will understand how a template and data source combine, will be able to insert merge fields, preview merged output and solve small formatting issues. The exercise also teaches careful data entry and the value of previewing and test printing to avoid mistakes.

Extension ideas
Advanced students can try saving merged letters as a single PDF, or creating small labels for the same list. Discuss how mail merge could be used for certificates or invitations and ask students to sketch a template layout before starting the merge.

Reviewing the main steps
Summarise the mail merge process in clear steps that students can remember: create and clean the data source, design the template and insert merge fields, connect the data source to the template, preview merged records and finally print or save the output. Revising the order of these steps helps reinforce understanding and builds confidence before practical tests.

Suggested assessment tasks
Design small tasks that check both theory and practice. For example: ask students to create a 5-row data table with correct headings; design a one-page letter template with merge fields for name and class; connect the data source and produce a saved merged document that contains five personalised letters. Give points for correct headings, correct placement of fields, successful preview and proper saved output.

Rubric and marking
Use a simple rubric: data correctness (spelling, headings), template design (fields in right places), successful merge (no blank fields), previewing and test printing performed, and final saved or printed output. Each item can have a few marks so students know where to improve. Encourage self-check using a checklist before submission.

Class discussion and common mistakes
Discuss frequent errors such as mismatched field names, blank rows in the table, punctuation inside data cells and failure to preview. Show one or two wrong examples and ask students to spot and correct the errors. This reinforces attention to detail and helps reduce mistakes in future work.

Next learning steps
After assessment, suggest extension activities such as making labels, badges or certificates. These tasks build on the same principles of templates and data and introduce new considerations like alignment and special paper handling. Encourage students to practise and keep templates and data organised for future use.