![]() 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. 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. Save your Excel file with your data and note the location where you save your Excel document. In Microsoft Excel Enter your data Make sure that you have labels on the top of every column of data. Finally, click Insert to complete data insertion. How To: Mail Merge with Word & Excel Mail Merges are a great way to create letters, certificates, and labels. 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. Select Get Date from Other Sources From Microsoft Query. In these examples, we will create a simple query using Microsoft Excel and the MS Query tool to mine the data for the Mail Merge. 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. The first step in creating a mail merge is defining the Data Source. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |