How does word make a pay bar?

Source: Internet
Author: User

How does word make a pay bar? There are many ways to make payroll, including subtotals, VBA, skill sorting, and so on. Today I'll explain how to use Word to make a pay bar.

1. Create a new Word document and select "Mail"-"Start mail Merge"-"directory" command.

2, according to the contents of the Excel Payroll table in Word to create a figure below the basic salary bar.

3, select "Mail"-"Start mail Merge"-"Select Recipient"-"Use existing list" command.

4. In the pop-up Select Data Source dialog box, select the Payroll source file you created, and click the Open button.

5, in the pop-up "Select Table" dialog box, select the entire payroll, press the OK button.

6. Position the cursor to the cell under Name, click Mail-Write and insert field-Insert Merge field Drop-down button, and select the corresponding field in the pop-up Drop-down box, that is, name. In this way, you insert the corresponding fields for other blank cells. After the completion of the effect is as follows:

7, select "Mail"-"Finish"-"complete and Merge"-"Edit a single document" command, in the pop-up Merge to New Document dialog box, click the "All" option, and then clicking the OK button.

8, so the salary table is completed, see the effect of it!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.