Hi Paul,
The macros are quite hashed with my limited knowledge of VBA. The macros above colour the cells based on one of three specific sets of text (MMY, MMI, MMN) and then colour the text the same to essentially hide it - creating a traffic light system that is clear for students. Is there a way to get this code into the letters created when the document is merged? Thank you for your prompt reply. Luke