I want excel to email a sheet as message body if a
checkbox is ticked

Always to the same mail reciepient