Let word also print labels in bulk

In order to meet the superior inspection and standardize the file management, the school decided to archive all files are archived, such as each teacher's Business files File box label requirements Unified Printing into the following picture. More than 200 tags if you use the table directly in WPS or Word, it will be very troublesome, in order to quickly complete this task, we found the Word2003 in the long unused "mail Merge" feature.

1, from the computer to find the original input of the staff situation registration form, payroll, such as the Excel spreadsheet file with the name of the whole school, copy the list of names to a new spreadsheet file so that you can call it in Word (in fact, do not re-create the file, but that is a bit messy in the call), Also prone to misoperation). This eliminates the heavy workload of having to re-enter the name.

2. Start Word2003, click tools → letter and mail → Mail merge, select label in the Select document type item in the Open Mail Merge task pane, and then click Next: Starting document, as shown in Figure 2.

3. In the Change document layout item, click Label Options, select Default Tray (Auto Select) in the paper tray box of the Label Options dialog box, because the default is manual feed, which can cause problems with the final printing. Then click the New Label button to open the New Custom Label dialog box, in the Label name box, enter the name you want to add to the new label, such as file tags, and change the top margin and bottom margin to 1 cm according to the icon in the preview box and the paper size you want to print out; put "label height" and " Label width "to 18.8 cm and 3.8 cm respectively (according to the size and thick of the file box); The number of labels is 7, the number of rows is 1; the transverse span is 3.85 cm, ( That is, the label width of 3.8 cm on the basis of a further 0.05 cm spacing, so that the final printout between the two labels will have 0.05 centimeters of space, directly from the middle of a cut can solve the problem, if this gap over the General Assembly has white edge, to cut trouble, also waste paper. )

Finally, in the Page Size box, select A4 Landscape (29.7x21 cm), then for the size we set above find the basis for: Side margin 1 cm + label width 3.8 cm x label number 7+ label spacing 0.05 cm x6 spacing

4. Click "Browse" select the Excel spreadsheet file with only one list of names you created in Excel, and then the "Select Table" dialog box appears, with sheet1$, sheel2$ and sheel3$ three worksheets to choose from, and the general situation is to choose sheet1$, Determines whether the "first row contains column headings" Item is selected according to the header row of the Excel file, and the final point "OK", as shown in Figure 4, when the Mail Merge Recipients dialog box appears, click OK, as shown in Figure 5.

5, the cursor (insertion point) in the first tab, in the case, click the "table" → insert → table, according to the preparation of the label format, insert a 1 column 6 rows of the table. Then drag the row line of the table, adjust the height of each row, and ensure the height of the entire table is close to the label. Note: Sometimes the cursor within the tag (the insertion point) takes up a blank line, which affects the height of the table, so you can click the DEL key to delete it, as shown in Figure 6.

6, point the cursor to the top of the table, when the mouse pointer changes to a wide downward black arrow, click the Left button to select the entire table, and then right-click, in the pop-up shortcut menu, select the "Cell alignment" item under the "Horizontal, vertical center." Finally, in the corresponding cell to enter each label is the same content: photos, personal business files, 2003-2006, Jianchang Camp Town Middle School and other content, such as Figure 7.

7, click the cell that you want to automatically enter the teacher's name, then click Next: Select labels in the task pane on the right, click More items ..., click the Insert button in the New Insert Merge Field dialog box, and then click the New Close button, as shown in Figure 8.

"Name" appears in the cell, as shown in Figure 9.

8, set the contents of the table font, font size, and so on, right-click the table, select borders and Shading from the shortcut menu that pops up, and in the Borders and Shading dialog box, increase the width of the table line to 2 points, and then click OK to exit, as shown in Figure 10.

9, click "Update all Labels", the format of the 7 labels will change to the same, then click Next: Preview label to display the final style of the label (without the "nextrecord" tag), click Next: Complete the merge, and then click Edit Personal Label, and in the Merge to New Document dialog box, select All and click OK to exit. Word automatically creates a new file named "Label 1" and makes all the data in the Excel spreadsheet file the appropriate label, as shown in Figure 11.

10, if the printout of the size is found to be biased (the first estimate is wrong), you can start from the 2nd step, but to the 3rd step can be directly to find the new "file tag" to modify the size on it. When you click Label Options, select Other/custom directly in the Label products box in the Label Options dialog box. Then in the Product Number list box, select our original "File tag--Customization", the last point "details" can directly modify the label size, as shown in Figure 12.

We use the automatic filling function of Excel to input the relevant data, and then use Word's mail merge function to print all the labels of the files with the highest speed and the highest quality, and thus received the table Yang. In fact, we can also imitate this method to print output payroll, transcripts and so on. Finally teach you a trick to cut the skill: put a ruler of the side of the two labels in the middle, one hand hold the ruler, a hand down the edge of a ruler up a tear did not hold another part of the two labels easily separated.