744 results for mail merge wps office
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
744 results for mail merge wps office
Use the Mail Merge function to input tabular data quickly
01:49Use 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 fun....
How to use Merge Shapes in WPS Presentation
02:45How to use Merge Shapes in WPS Presentation
Merge Shapes is an important function in WPS Presentation. By using it skillfully, you can also create slides that have a strong sense of design.In short, based on the Boolean operation, Merge Shapes is the process of adding and subtracting two or more graphics. Select two or more graphics on the slide, and click the Drawing Tool tab and the Merge Shapes drop-down button.In the drop-down menu, we can see there are five options. They are Union, Combine, Fragment, Intersect and Subtract.....
Merge and split table cells in WPS Writer
01:09Merge and split table cells in WPS Writer
Today we are going to learn how to merge and split table cells in a document.Take this table as an example.· Merge cellsHere, we can merge cells. Select the cell in the first column and click the Merge Cells button in the Table Tools tab to merge the cells. · Split Cells1. If we want to divide a cell into several cells, we can select the cell that needs to be split. 2. Click the Split Cells button in the Table Tools tab.3. In the pop-up dialog box, we can set the number of columns and ....
Hyperlink in WPS Office Spreadsheet
02:22Hyperlink in WPS Office Spreadsheet
When we work, we often need to add hyperlinks in spreadsheets to jump to other tables or add hyperlinks to jump to web pages. So, how can we add hyperlinks to WPS Office Spreadsheet? Take this spreadsheet as an example.1. ClickStatistics and click the right mouse button. 2. In the pop-up shortcut menu, select the Hyperlink option. You can also use the Ctrl + K shortcut key to open the Hyperlink dialog box. 3. In the pop-up dialog box, click Place in this Document. 4. Under the Cell Ref....
Set the page printing area in WPS Office Spreadsheet
00:47Set the page printing area in WPS Office Spreadsheet
What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....
How to change the data source used in mail merge
1. Open the document we want to edit in WPS Writer.2. Click the References tab → click the Mail Merge button.3. In the Mailings tab area, we can click the Mail Merge Recipients to see the data we have already inserted. 4. Click the Open Data Source drop-down button → select Close Data Source first.5. Then click Open Data Source and choose a needed data source according to our needs. 6. Now we have successfully changed the data source! To be office word advanced, you could learn how to ....
Create 100 recruitment notices in batches
02:33Create 100 recruitment notices in batches
Here are one hundred profiles of new employees, which need to be made into recruitment notices. If you are the HR of this company, how would you do that? The Mail Merge function allows you to handle these 100 notices easily. Take this document as an example. We need to input employees' names, entry time, department, position, and salary.1. Open the table that contains the information of new employees. 2. The information of the five columns will be inserted as Merge Fields. For conv....
How to merge PDF quickly in WPS Office
Are you wondering how to merge multiple PDF files into one file quickly? WPS Office provides the Merge PDF function for you. Read the following free tutorial, and you are sure to master the method. · Steps to merge PDF in WPS Office.1. Open one of the PDF files you need to merge in WPS Office.2. Head to the Pages tab > Merge PDF. 3. Click Add files to add the files you need to merge, and set the Page range and Language as needed.4. Input the merged file’s name at Output Name.5. Set th....