Use Word to make a batch of photo ID

The production of student ID card or work permit time is very troublesome, should be in urgent need of photos and name correspondence, also learn to document number also corresponds. In particular, batch production. Recommend a tool bar, is the leading barcode label design software, you can import photos into the database, name and card number only need to set up will be batch generation and you need the same license number. It's very convenient. But what if you don't use the software? Blue1000.com teaches you to use Word to make lots of work permits with photos. is more than the leading barcode label design software trouble, seriously learn oh.

Word mail merge is a very useful feature. Now I'm going to introduce you to a Word mail merge application example, make a name, department, number, photo of the work card.

Preparation of the material

The material here is mainly the photos of each employee, and in a certain sequence of numbers, the number of photos can be in accordance with the Unit's database in the name of the workers, group order to arrange. You can then store the photos in a folder on the specified disk, such as "E: Employee information."

Establishing a database of employee information

Use Excel tables to create a "staff information table" in the table to include the employee's name, group, number and photos, the name, group can be directly imported from the unit database, the name and number of the order and the previous photo number sequence, the photo column does not need to insert a real picture, Instead, enter the disk address for this photo, such as "E: Employee Information 01.jpg," and note that this is a double backslash, and then rename the workbook to "employee Information" as shown in Figure 1.

Figure 1

Create a badge template

To start Word 2003, create a main document and design a table that looks like the one shown in Figure 2, where you can set the border to "none", which is the part of the work card that doesn't change. Of course, this is just an example, you can design a better layout.

Figure 2

Adding fields

Step 1 Select the View | toolbar | Mail Merge Tool menu item and bring up the Mail Merge toolbar.

Step 2 Click the Open Data Source button on the Mail Merge toolbar (the second icon on the left). Pop-up "Select Data Source" dialog box, select the "Employee Information table" Just established, click on "Open" button, pop-up "Select Table" dialog box, in the "Select Table" dialog box, select "Employee Information $", as shown in Figure 3. Click on the "OK" button to return to the main document.

Figure 3

Step 3 Position the cursor to the cell after name, and then click the Insert Field button on the Mail Merge toolbar (the sixth icon on the left). pops up the Insert Merge Field dialog box, select name from the list of fields in the dialog box, click the Insert button, and insert it in the specified location, as shown in Figure 4. Click the "Close" button to return to the main document.

Figure 4

Step 4 in the same way, insert the group, Number field into the main document in the appropriate location.

Step 5 Positioning the cursor in the "XX High School ID card" in the large cell right below, we want to display a photo of employees here. Insert the field by pressing "CTRL+F9", where a pair of curly braces appears, in which you enter "IncludePicture" {MERGEFIELD "photo"} "" (without the outer quotation marks), noting that the braces are also inserted by "ctrl+f9".

Step 6 Finally click the "Merge to New Document" button on the Mail Merge toolbar (the 4th icon on the right), will be based on the number of records in the Staff Information table batch production "work Card", and regenerate Word documents, so far, "xx High school work card" finished. And then print it directly.

Tip: If the newly generated document does not display a picture or all the pictures show a person, it doesn't matter, you can press "CTRL + a" to select all, and then press F9 to refresh the document. Not yet, you only have to save this document is closed, then open, select All, press the F9 key to refresh the document.