Get the App
SLTechnology News&Howtos  ›  IT Information  › 

How to use Word to generate admission cards with photos in batches

Shulou Source: shulou.com Published: 2023-11-24 13:08:00 10月03日 Update

The original title: "there is still such a magic operation in Word, printing shops do it!" "

Sometimes, we need to print N documents, and each document template is the same, but individual content needs to be modified, how to deal with this situation? In fact, Word already provides us with such a feature, that is, "mail merge", but most people don't know it.

Preparation work here, I take the admission card with photos as an example, the admission card templates are all the same, but the name, photo, certificate number and other information have changed.

1. Put all the examinee's photos under a folder.

2. Data source file. As shown in the following figure, you can see the path where the "photo" in the data source is located. The default should be "D:\ easy Snow Dragon\ Wonder woman .jpg". Here we need to change it to a double slash, that is, "D:\ easy Snow Dragon\\ Wonder woman .jpg".

3. The blank template document of the admission card.

Start production 1, enter "Mail"-"start Mail merge"-"letter"; click "Select recipient"-"use existing list", select the location of the "data source" table, and determine.

2. Position the cursor to a blank cell, enter "Mail"-"write and insert fields"-"insert merge fields", and insert the corresponding cells in turn.

3, position the cursor to the inserted time domain cell, "right"-"switch field or code", add "\ @" yyyy-MM-dd "," right "-" update field "after" exam time ".

4. Position the cursor in the photo cell, enter "insert"-"text"-"text part"-"Field", select "IncludePicture", and enter "photo" in "File name or URL:".

5, select the photo, use the shortcut key "ALT + F9", select the word "photo" in the domain code to delete, enter the "photo" field in the "insert merge field", and finally use "ALT + F9" to switch back.

6. Click "Mail"-"finish"-"finish and merge"-"Edit a single document"-"all"-"OK". At this point, we will find that we have generated a mail merge document, all the information is correct, that is, the photo or picture can not be displayed, at this time, we use the shortcut key "Ctrl + A" to select all, and then press "F9" to update the field, we can display the picture.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Yi Xuelong

Tags: Photos emails selections units files admission cards cursors just documents templates snow dragons location magic code messages pictures women that is shortcut keys Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MySQL Microsoft NVidia OPPO Reno macOS