![]() Now we have to input the Image Number serially in this sheet, for example In this process, we will enter the pictures’ location instead of their name in the field code.ĭataset needs to be prepared properly in order to avoid any kind of unwanted outcome. Read More: Mail Merge from Excel to Word Envelopes (2 Easy Methods) After clicking Yes, you will notice that the word file is filled with the merged image with merged information stored in the Excel sheet.To make it visible, press Ctrl+A to select all the contents in the word file, and then press F9. Then there will be another dialog box, in that box, select All, then click OK.Then from the Mailings tab, click on Finish & Merge, then click on Edit Individual Documents.Press Alt+F9 again, but the image is not still visible.After clicking on the Image field, the code will change like the below image.Then select the IMAGE letter in the highlighted image code and then go to Mailings > Insert Merge Field tab select the Image field, from the drop-down menu.Doing this will enable the code format of the word, and let us edit the code manually.After we click OK, the image will load, but will not be visible yet.Now we will put the image field in the code field and then format it accordingly. Step 4: Insert Picture into Word Document Then in the FIeld Properties enter any name, and we put “Image” in the field.Then there will be a new dialog box, from that box, in the Field names options menu, select IncludePicture.To do this, go to Insert > Text group > Quick Parts > Field. Next, we will enter the image link in the word.After filling the fields, they will look something like the below image.Repeat the same procedure for the first part.Select X as shown in the image, and then from the Mailings tab, click on the Insert Merge Field.Now we are going to replace the Name, Age, Hometown, Country, etc value in the Word file.After that, you can enter the field like name, age, and country from the Excel sheet into the word file from the Insert Merge Fields command from the Mailings tab.Next, there will be a new window name Select Table, it will ask which sheet you want to choose.From that window, select the list file that we just created in Excel. Next, there will be a new file browsing window that will open.Now from the Mailings tab, go to Select Recipients > Use an Existing List.And the images are going to be added in the top right corner of the word file.The draft of the word file is already done, the texts in the draft we going to be repeated in every single entry in the list created in Excel.and edit them accordingly to make room for images. Step 3: Create Relation Between Excel and Word FileĪfter completing the Excel file information, open the word file. The work in the Excel sheet is done, and this list will be used in the Word file. Repeat the same process for the rest of the entry.We need to modify the link address a little bit, adding another slash after every slash already in the link.Then you are going to notice that the link address now showing in cell G4. ![]() ![]() Select the image, and the location directory text that is going to show in the text box will be shown in the Text to Display box above.After clicking the Link, then there will be a new dialog box asking for the location of the images on your pc.To do this, first, go to the Insert tab, and from there click on the Link from Links group.Now we need to insert the images into a specified folder and then enter the images hyperlink The information we gathered is shown below.We are going to create a list of the information of different persons in the Excel sheets. ![]() In this case, the variable information will be the person’s name.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |