WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

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

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

Create 100 recruitment notices in batches

Uploaded time: March 15, 2022 Difficulty Beginner

Create 100 recruitment notices in batches

Create 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 convenience, we set the table headers as: Name, Entry time, Department, Position, and Salary.

3. Then press Ctrl+S to save the document.

Create_100_recruitment_notices_in_batches_1.gif 

4. Go back to the Word document, head to the Reference tab, click Mail Merge, click the Open Data Source drop-down button and choose Open Data Source. Find the table file of employees' information, select it and click Open  data-imgw=800 data-imgh=450 data-src="//res-academy.cache.wpscdn.com/images/def29def76268936c93abb27aa45df69_0.46_8330.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(450/800)); text-align:center;" >

Tips: if the error message occurs, change the suffix of the table name to XLS.

5. Now we need to insert all Merge Fields into the document. Select the position where you need to insert Merge Field.

For example, to insert the Name column, select the text Name highlighted in the document, and click Insert Merge Field in the Mailings tab to pop up a dialog. Select Database fields at Insert and Name at Fields. Then click Insert.

6. You can insert the Fields of Entry Time, Department, Position, and Salary following the same steps.

Then there are two ways to produce documents.

Merge to Different New Document.

1. Click Merge to Different New Document to pop up a dialog, where we can choose the name of the document at Use field name, set a document type at Save as type, and set the File Location.

2. Select All and click OK  data-imgw=800 data-imgh=450 data-src="//res-academy.cache.wpscdn.com/images/b0353d86836cf9a684bac97a0cccd04e_0.46_1829.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(450/800)); text-align:center;" >

Merge to New Document.

Click Merge to New Document to pop up a dialog, click All, and click OK  data-imgw=800 data-imgh=450 data-src="//res-academy.cache.wpscdn.com/images/0f1f2297657620855f8bcac56d4999f8_0.46_4491.gif" data-test="skks" style="max-width: 100%; width: 720px; max-height: 405px; height: calc(100vw *(450/800)); text-align:center;" >

This is the method of generating documents in batches with the Merge Mail function. Did you get it?

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