Mailmerge create a coloured box based on data

[haydencohen]

Hi,



I'm wanting to create two sets of labels with different colours on them. The first set would be a list of students who have been placed either in group 1, 2 or 3.

Each label should have a coloured box representative of the group. i.e. 1=red, 2=blue, 3=yellow.

The second set would be for resits. There are upto 4 composite parts of an assessment. On resitting, I want each label to have a maximum of four coloured boxes dependent on which parts they need to resit.

Can you help?


Hayden