I have a shared workbook we use for internal
communication/collaboration.

Is there anyone that can generate vis basic code that would send an
email out automatically based on a cell changing to a certain value?
we use Outlook

e.g., if in a range of cells, a cell changes to a certain value, an
email would automatically be sent out to a certain list of people, with
a certain message text.