WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Use the Mail Merge function to input tabular data quickly

Uploaded time: October 31, 2021 Difficulty Beginner

Use the Mail Merge function to input tabular data quickly

Use the Mail Merge function to input tabular data quickly

WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. Easily compatible with 51 types, including doc, xls, ppt and other text types.Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.

Do you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Today, we will learn how to use the Mail Merge function of WPS Office to input employee information in the badge template quickly.

Taking this document as an example, we want to quickly input the employee information of another form into the document, and click theMail Mergebutton in theReferencestab before entering theMailingstab.

1 (1).gif

Step 1:

Let's input the employee data form prepared in advance into the document. Then, click theOpen Data Sourcebutton in theMailingstab, select the form, Stuff Profile in this case, then select the Sheet where your data is located. Finally clickOK.Here the data is imported.

1 (2).gif

Step 2:

Insert data in the corresponding position. First, clickName first, and then click theInsert Merge Fieldbutton in theMailings tab. In the pop-up dialog box, check theDatabase Fieldsoption, and selectNamein fields. Finally, clickInsertto complete data insertion. After clickingClose, continue to insert data. The steps are the same as above.

1 (3).gif

Step 3:

We can click theView Merged Databutton in theMailingstab to view the insertion result. Click theNext Recordbutton to view the next data insertion.

1 (4).gif

Step 4:

If you want the inserted data to be displayed in the new document, you can click theMerge to New Document button in the Mailings tab, and select All in the pop-up dialog box, so that all badges can be generated in the new document.

1 (5).gif

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.