Maybe https://www.gmayor.com/mail_merge_charts.htm would help?

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thankyou for the reply ...

I have managed to do it another way as i needed it to look as close to the chart as possible, I have now amended my mail merge data with a new column and a nested if statement in excel puts the file paths in matching the conditions i have set,

I then used macropod's example of field code to include a picture in the word mail merge.

{ include picture {if true"{MERGEFILED pupil_mins_lost_imagepath}" \d }

This works as intended!

Thankyou both for your help

Retro,


were you able to figure out this mail merge? I have the similar issue with students that I am trying to mail merge letters with a chart for each student.

I did....
It was hard work though, how far have you got with your mail merge fields?

if you press alt+F9 you will see the merge field code
i then added my merge field source spreadsheet with filepaths to my images needed and used this

{ include picture {if true"{MERGEFILED pupil_mins_lost_imagepath}" \d }

press alt+F9 and preview the results and your image should appear if it exists in the image path in your mail merge source