How-to

One sheet of names. One letter. Preview before you print 200 pages.

Mail merge in WPS is picky about headers. It is still better than a downloaded merge wizard from a video. This site is an independent handbook and is not affiliated with Kingsoft Office Software Corporation Limited.

Checklist notes beside a keyboard
Checklist notes beside a keyboard

Before you start

Save the data as XLSX with a single header row. No merged cells in the header. Mail merge in WPS is picky about headers. It is still better than a downloaded merge wizard from a video.

Preview three records before you print 200 pages. A short name, a long name, and an empty optional field will show spacing bugs.

Steps

  1. Clean the spreadsheet One row of headers: Email, Name, Address. No blank header cells. Save as XLSX.
  2. Open the letter in Writer Write the body with placeholders in your own words first, then replace them with merge fields.
  3. Connect the data source Use the mail merge tools to pick the sheet. If the wizard cannot see columns, your header row is the bug.
  4. Preview three records Check a short name, a long name, and an empty optional field. Fix spacing.
  5. Finish to PDF or print Export PDF if you need a copy. Do not email 200 DOCX files unless you mean to.

If it still fails

Writer notes: Writer. Sheets: Spreadsheets.