WPS Mail Merge on macOS FAQ

Last updated:July 15, 2026

These Mail Merge FAQs focus on data source setup, field insertion, preview checks, and output choices, with 5 common questions and answers.

FAQ

Why can’t WPS Mail Merge read the fields in my data source correctly?

  1. Check whether the data source file is an Excel workbook that opens normally.
  2. Make sure the header row contains field names and the following rows contain actual data.
  3. Reopen the file through Open Data Source, then try inserting merge fields again.

Why do I see field placeholders instead of the final name or address?

  1. Confirm that you inserted merge fields instead of typing plain text manually.
  2. Click View Merged Data to preview different records.
  3. If the preview is still empty, check whether the corresponding field contains data in the source file.

How do I create multiple separate files with WPS Mail Merge on macOS?

  1. Open the Mail Merge tab.
  2. Click Merge to Different New Documents.
  3. Set the save location, file type, and record range, then confirm the action.

How can I check each record before I finish the merge?

  1. Click View Merged Data.
  2. Use Previous Record or Next Record to review records one by one.
  3. Confirm layout, field content, and page breaks before running the final merge.

Can Mail Merge print directly or send email messages?

  1. Yes. You can choose Merge to Printer or Merge and Send based on your task.
  2. Before printing, check the printer status. Before sending, check the recipient and subject settings.
  3. After that, save the template or output files if needed.

Glossary

TermDefinition
Data sourceA file that provides the record data used for batch merging, commonly an Excel workbook.
Merge fieldA placeholder inserted into the template that is replaced with actual values during the merge.
Record rangeThe set of records selected for the merge, such as all records, the current record, or a specified range.
Merge to New DocumentCreates one new result document that contains merged output for the selected records.
Merge to Different New DocumentsCreates separate files by record for easier saving and distribution.