Mailmerge may be a bad tool for this but it's the only thing I understand at the moment




I like to multiple choice quizzes to my classes every week, however, many of my old quizzes have been memorised/or photographed by older students.

I thought it would be a great idea if I could randomise the answers order and also the question order. Is it possible to randomise a mailmerge from excel?

Bonus: if I could also create an answer key for myself (A,C,D) for the random questions and answers that would be AMAZING!

I know Mailmerge is probably not the most efficient system for this. I would really love to be able to hit a button and print out a randomised quiz and answer key.
Thanks!