Random name pairing, no duplicates, 12 months, auto email

Hi,

Tricky task, but I want to create a macro that randomly pairs all names in a column without any repeats, then it will draft and send email to each of those pairs.

but.. then I want to be able to perform this same action again a month later, but not have any repeats of the previous month, until all possible combinations are exhausted.

I have added an example worksheet with manually sorted lists and some comments to explain the order of actions.

Any clues on how to even start this? maybe it's worth solving the pairing aspect first, without the emailing - then add that later/separately?

Any help appreciated.

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you