- Practice
- About 12 min
- 5 practice questions
Tables and mail merge in depth
Count cells after merging and splitting, use table commands correctly, and list the parts and steps of a mail merge.
If something looks wrong, please tell us.
Tables and mail merge give a steady flow of questions that need a little counting and clear vocabulary. The first lesson on layout gave the basic terms. Here we go deeper into the operations and into how a mail merge actually works.
Table operations
| Operation | Effect |
|---|---|
| Insert row or column | Adds a new row above or below, or a column left or right |
| Delete row or column | Removes it along with its contents |
| Merge cells | Joins selected cells into one larger cell |
| Split cells | Divides one cell into a chosen number of rows and columns |
| AutoFit | Adjusts column width to the content or the window |
| Sort | Arranges rows alphabetically, numerically or by date |
| Borders and shading | Lines around cells and background colour inside them |
| Convert text to table | Turns text separated by tabs or commas into rows and columns |
The Table Tools tabs (Design and Layout) appear only when the cursor is inside a table. Gridlines are faint guide lines that show cell edges on screen but do not print, while borders do print.
How a mail merge works
A mail merge has three parts: the main document (the letter with fixed text), the data source (a table or spreadsheet of names and addresses; each row is a record and each column is a field), and the merge fields placed in the letter, such as the name or the city. When the merge is run, the word processor produces one copy of the letter for every record.
- Write or open the main document.
- Choose or create the recipient list (the data source).
- Insert merge fields where the personal details should appear.
- Preview the results to check the merge.
- Finish: print the letters, save them or send them by e-mail.
Worked examples
Example 1. A table has 5 rows and 4 columns, so it has 5 x 4 = 20 cells. The two cells in the first row, columns 1 and 2, are merged into one. Number of cells now = 20 - 1 = 19, because merging two cells leaves one. If another cell is split into 3 pieces, the count rises by 3 - 1 = 2, giving 21.
Example 2. A school keeps a list of 250 parents in a spreadsheet and has 1 invitation letter. A mail merge makes 250 letters, one for each record. The letter file is the main document, the spreadsheet is the data source, and the column holding the parent's name is a field. If 10 records are removed from the list before merging, only 240 letters are produced.
Example 3. A student pastes names separated by commas, such as Asha,Ravi,Mohit, and wants them as three cells in a row. Select the text and use Convert Text to Table, choosing comma as the separator. One row with 3 columns is created.
A mail merge makes one copy for every record: main document + data source + merge fields.
Key takeaways. Merging cells reduces the cell count, splitting increases it. Record means row, field means column. A mail merge needs a main document, a data source and merge fields, and produces as many letters as there are records.
Check your understanding
-
1. In a mail merge, each row of the data source is called a:
- Field
- Record
- Cell
- Section
Show answer
Answer: B. A row holds all details of one person and is a record. A column, such as the name, is a field.
-
2. A table of 6 rows and 3 columns has two cells merged into one. How many cells remain?
- 18
- 15
- 16
- 17
Show answer
Answer: D. 6 x 3 = 18 cells. Merging two cells into one leaves one cell fewer, so 18 - 1 = 17.
-
3. Which command divides one cell into several rows or columns?
- Merge Cells
- Split Cells
- AutoFit
- Sort
Show answer
Answer: B. Split Cells divides a cell. Merge Cells does the reverse, and AutoFit only adjusts widths.
-
4. A data source has 180 records and the main letter is merged with all of them. How many letters are produced?
- 180
- 1
- 18
- 360
Show answer
Answer: A. One letter is produced for each record, so 180 letters in all.
-
5. Which lines show cell edges on screen but do not appear in print?
- Borders
- Gridlines
- Underlines
- Margins
Show answer
Answer: B. Gridlines are only a guide on the screen. Borders are real lines and are printed.
Sign in to keep track of the lessons you finish.