• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Mail Merge incorporating images

excel_321

New Member
Hi all,

I need to (mail/)merge information from excel into the attached (word) document for a group of students I teach. It is an A5 sheet; two on one page. The fields that need to be picked up are as follows:


1- The score to appear in the box

2- Comment 1 and Comment 2

3- Image


The image will need to be picked up also from excel. I have no idea how images can be merged into word! Please note the image would need to be automatically resized to fit the box in word.


As for the comments they need to be merged into word with the same text formatting (i.e. bold green text).


I hope someone can help me. This task will greatly reduce my workload.

Thanks
 

Attachments

  • Assessment Template.png
    Assessment Template.png
    43.2 KB · Views: 1
Back
Top