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

Tips: you can turn on the volume by clicking

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 the Mail Merge button in the References tab before entering the Mailings tab.

1 (1).gif


Step 1:

Let's input the employee data form prepared in advance into the document. Then, click the Open Data Source button in the Mailings tab, select the form, Stuff Profile in this case, then select the Sheet where your data is located. Finally click OK. Here the data is imported.

1 (2).gif


Step 2:

Insert data in the corresponding position. First, click Name first, and then click the Insert Merge Field button in the Mailings tab. In the pop-up dialog box, check the Database Fields option, and select Name in fields. Finally, click Insert to complete data insertion. After clicking Close, continue to insert data. The steps are the same as above.

1 (3).gif


Step 3:

We can click the View Merged Data button in the Mailings tab to view the insertion result. Click the Next Record button 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 the Merge 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