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
|