This article describes a Word mail merge application examples on how to make a name, department, number, photo of a work permit.

first material preparation:

material here is mainly pictures of each employee, according to a sequence number, photo number sequence database according to unit employees name, group in order to schedule. The photo can then be stored in the specified disk folder, such as "D: \ employee information."

establishment of employee information database

using Excel form a "Staff Information Form" included in the table to each employee's name, category, number and photograph, name, groups can be imported directly from the unit database, name, numbered in the order should be and The number in front of the order of the same photo, photos, insert a column does not need a real picture, but to enter this photo of disk addresses, such as "D: \ \ Staff Info \ \ 001.jpg", note here is double backslash production of the workbook after the re-named "Employee Information", as shown in Figure 1.

Figure 1

then create a work permit template

start Word 2003, now to create a main document, a design layout shown in Figure 2 to a table where you can frame is set to "None", the content is a work permit will not change the part. Of course, this is only an example, you can design a better layout to look.

Figure 2 $ show_page $

Finally add domain

Step 1 Select "View | Toolbars | Mail Merge Tools" menu item, adjust the "Mail Merge" toolbar.

Step 2 Click the "Mail Merge" toolbar "Open Data Source" button (the second icon on the left), pop-up "Choose Data Source" dialog box, select the just created "Employee Information Form", click on "Open "button, pop-up" Choose Form "dialog box, in the" Choose Form "dialog box, select the" Staff Information $ ", as shown in Figure 3. Click "OK" button to return to the main document.

Figure 3

Step 3 Position the cursor to the "name" after a cell, click the "Mail Merge" toolbar "Insert Field" button (the sixth icon on the left), pop-up "Insert Merge Field" dialog box, in the dialog box, select the domain "name", click "Insert" button to insert it into the specified location, as shown in Figure 4. Click "Close" button to return to the main document.

Figure 4

step 4 in the same way, the "group", "ID" field are inserted into the main document in the appropriate position.

Step 5 Position the cursor on the "¡Á ¡Á secondary work permit" right below a large cell, we want to show the staff in this photo. Press "Ctrl + F9" to insert the field, will appear within the cell at this time a pair of braces, in which the input "INCLUDEPICTURE" (MERGEFIELD "photo") "" (without the outside quotes), note which is in accordance with braces "Ctrl + F9" to insert.

Step 6 Finally click "Mail Merge" toolbar "Merge to New Document" button (the fourth icon on the right) will staff the information table according to the number of records to batch production "work permit" and rebuild the Word documents, thus, "¡Á ¡Á secondary work permit" production is completed. And then print directly on the line.

Tip: Should the new generation of document does not show pictures or all of the pictures shows a man, okay, you can press "Ctrl + A" Select All, then press the F9 key to refresh the document. Not yet, you only have to save the document first closed, then open, select all, press F9 key to refresh the document.