Mail merge: how to send personalised letters

A step-by-step guide to mail merge: turning one letter and one spreadsheet into dozens of personalised letters, without copying and pasting a single name.

The Quillpage Mail Merge dialog reading “6 rows loaded. The document uses 6 fields.”, with field buttons for First name, Last name, Address, Bed, Spot and Week, a preview table of the rows, and options to make one PDF, one Word document or a Word file for each row

Mail merge takes one letter and one list, and produces a personalised copy for every person on the list. Instead of typing “Dear Priya” and then “Dear Tom” fifty times, you write the letter once with placeholders, called merge fields, and your word processor fills them in from a spreadsheet. It’s ideal for welcome letters, invitations, certificates, reminders and anything else where most of the wording stays the same.

The process is the same in every app that offers it: prepare the data, write the letter with fields, preview it, then choose how you want the results.

Step 1: prepare your spreadsheet

Most mail merge problems start in the spreadsheet, so a few minutes here saves a lot of fixing later.

  • Use a header row. The first row should name each column, such as First name, Last name, Address and Event date. Those names become your merge fields.
  • One row per person, one column per detail. Keep first and last names in separate columns, so you can write “Dear Priya” rather than “Dear Priya Shah”.
  • No blank rows or merged cells. A blank row in the middle can make some apps stop early or create an empty letter.
  • Check spelling and capitals. Whatever is in the cell appears in the letter, so “priya” stays lower case.
  • Format dates and amounts as you want them to read. If you want “19 October 2026” in the letter, it’s safest to have exactly that text in the cell.

Save it as an Excel workbook (.xlsx) or a CSV file. If your list is in Google Sheets or Apple Numbers, export it in one of those formats first.

Step 2: write the letter with merge fields

Write the letter as normal, but wherever a detail changes from person to person, insert a merge field instead of typing it. In most apps, fields appear with chevrons around them, like «First name». A greeting might read “Dear «First name»,” and an address block might be «First name» «Last name» on one line with «Address» below.

A welcome letter from Riverside Community Garden with merge fields for First name, Last name, Address, Bed, Spot and Week placed in the text
A letter with merge fields where each person’s details will go.

A few habits help the result read naturally:

  • Type the spaces and punctuation around each field yourself, such as the space between «First name» and «Last name», and the comma after the greeting.
  • Read each sentence as it will look with a long name and a short one.
  • Choose wording that works for everyone on the list, unless you have a column for the detail that changes.

Step 3: preview and check before you make the letters

Never make two hundred letters without looking at a few first. Check the first record, the last record and anyone with unusual details: a very long address, a name with an apostrophe or accent, or a row with an empty cell. If something looks wrong, fix it in the spreadsheet rather than in the finished letters, so a re-run comes out right.

If you’re printing, print one or two letters first to check the margins and, if you’re using window envelopes, that the address lines up with the window.

Step 4: choose how you want the results

Depending on your app, you’ll usually have a few options:

  • One PDF with every letter. Best for printing: one file, one print job, with each letter on its own page.
  • One Word document with every letter. Handy if you want to make small personal changes to individual letters before printing.
  • A separate file for each person. Useful when you’re sending letters as email attachments or saving a copy to each person’s record.
  • Emails. Some apps can send the merge as individual emails through your email program.

Mail merge in Word, LibreOffice and Quillpage

Microsoft Word has the most complete mail merge, on its Mailings tab. You start a merge, select your recipients from a spreadsheet or your contacts, insert merge fields, preview the results and then finish the merge to a new document, the printer or email. It also handles envelopes and labels well. It’s included with Microsoft 365 and Office.

LibreOffice Writer is free and has a Mail Merge Wizard that walks you through the same steps. It works well, though the wizard can feel less polished than Word’s.

Quillpage has mail merge under File ▸ Mail Merge. Load a spreadsheet with a header row (CSV, TSV or Excel .xlsx), or paste rows copied straight from a spreadsheet. Click a column name to insert a field such as «First name» at the cursor. Quillpage tells you how many rows loaded, shows the rows in a preview table, and warns you if the letter uses a field that isn’t in the spreadsheet, which catches typos before you make anything.

Then choose what to make: One PDF, One Word Document, or A Word File for Each Row. For separate files, you choose which column to name them after, so you could get a file per person named after their last name. Quillpage makes the files rather than sending emails, so for an email merge you’d attach each file yourself or use Word with Outlook.

Tips for a smooth merge

  • Keep a master copy of the spreadsheet and the letter, so you can re-run the merge next time with an updated list.
  • Add a column for anything optional you want to vary, such as a short personal line, rather than editing letters one by one.
  • If you also need to collect signatures on the finished letters, our guide on signing a PDF covers the free options on Mac and Windows.

Mail merge is included in Quillpage, which costs £19.99 once with a 7-day free trial and no subscription, on Mac and Windows. If you’re comparing apps, see our page on Word alternatives, and if you’re writing to employers, our guide to writing a cover letter may help.

Questions

What file does mail merge need?

A spreadsheet or table with a header row, where each column is one piece of information (such as first name or address) and each row is one person. An Excel file or a CSV file works in most word processors.

Can I mail merge from Google Sheets?

Yes, indirectly. Download the sheet as a CSV or Excel file, then use that file in your word processor’s mail merge. Some add-ons can merge straight from Google Sheets too.

How do I stop blank lines when a cell is empty?

The simplest fix is to make sure every row has something in every column you use. Otherwise, avoid putting an optional field on a line of its own, or fill gaps in the spreadsheet before you merge.

Is it safe to mail merge personal data?

A list of names and addresses is personal data, so treat it with care. Keep the spreadsheet somewhere secure, share it only with people who need it, and delete copies you no longer need.

Documents and presentations, paid for once

Quillpage opens, edits and saves Word and PowerPoint files on your Mac and Windows PC, with Quill Slides included. Try it free for 7 days, then it’s £19.99 once, on up to 3 of your devices.

Try free for 7 days

Microsoft, Microsoft 365, Office, Word, Excel and Outlook are trademarks of Microsoft Corporation. LibreOffice is a trademark of The Document Foundation. Quillpage isn’t made by or affiliated with Microsoft or The Document Foundation.

All articles