WPS Mail Merge on Windows FAQ

When using WPS Mail Merge, common questions usually involve data source connection, field recognition, and output choices; this FAQ includes 4 common questions and a glossary.

FAQ

What should I do if I cannot open the data source?

1. First, confirm that the 32-bit AccessDatabaseEngine database engine is installed on the device.
2. If the issue continues, save the data source again in .xls format and reconnect it.
3. Check whether the data table is damaged and whether field names are in the first row.

Why does the inserted merge field not show the expected content?

1. First, confirm that the data source has been loaded successfully.
2. Check whether the inserted field matches the column name in the data table.
3. Use View Merged Data to preview records one by one and confirm the field mapping.

How do I save each record as a separate file?

1. Open the Mail Merge tool area.
2. Click Merge to Different New Documents.
3. Set the file naming information, save type, and save location, then run the output.

How to do mail merge in WPS for invitations, envelopes, or pay slips?

1. Mail Merge can be used for invitations, envelopes, pay slips, transcripts, and other documents that need personalized content in batches.
2. If each document uses the same structure and only the field values change, Mail Merge is a good fit.
3. Prepare a clean data table first, then insert fields and preview the results for a smoother mail merge workflow.

Glossary