![]() csv file, use the Text Import Wizard to set up your data in Excel. 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. Step 1: Set up your data source in Excel If you're using an Excel spreadsheet as your data source for a mail merge in Word, skip this step. Click the Next Record button to view the next data insertion. We can click the View Merged Data button in the Mailings tab to view the insertion result. After clicking Close, continue to insert data. ![]() Finally, click Insert to complete data insertion. In the pop-up dialog box, check the Database Fields option, and select Name in fields. First, click Name first, and then click the Insert Merge Field button in the Mailings tab. Insert data in the corresponding position. Then, click the Open Data Source button in the Mailings t ab, select the form, Stuff Profile in this case, then select the Sheet where your data is located. Let's input the employee data form prepared in advance into the document. 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. Today, we will learn how to use the Mail Merge function of WPS Office to input employee information in the badge template quickly. ![]() ![]() Best free office suite alternative to Microsoft Office Word, Excel, and PowerPoint,applicable to Windows, mac OS, Android and iOS.ĭo you know how to make badges in batches? Are you still inputting employee information one by one? It's a waste of time. Easily compatible with 51 types, including doc, xls, ppt and other text types. WPS Office contains four major functional modules: Writer, Spreadsheet, Presentation, and PDF Converter. ![]()
0 Comments
Leave a Reply. |