Now, please place the cursor at the position where you want to display the picture, and then click Insert > Quick Parts > Field, see screenshot:ġ1. After inserting the data fields, next, you should insert the image field. Then, you should repeat the above step to insert other corresponding fields for Age, Couse and College to get the following results:ġ0. And then, put the cursor beside the Name, and click Mailings > Insert Merge Field > Name, and the Name field will be inserted into the word document as below screenshot shown:ĩ.
In the following Select Table dialog box, select the worksheet containing the student information you want to use, and then click OK, see screenshot:Ĩ. Then, in the popped out Select Data Source window, select the Excel file you created, and then click Open button, see screenshot:ħ. After completing the format of the information in word file, please click Mailings > Select Recipients > Use an Existing List, see screenshot:Ħ. Step3: Establish the relationship between the Excel file and the Word documentĥ. You can prepare and design the card formatting in a Word document as below screenshot as your own need:
After entering the data, save and close the Excel file.Ĥ. Tips: If there are multiple single slash needed to be converted to double slashes, you can apply the Find and Replace feature in Excel to find and replace them at once.ģ.
0 kommentar(er)
