VBA to display (ready to send) custom outlook email based on cell value

Hello All,

I am looking for a solution that will watch column E and open a custom email (.display), ready to send, in outlook based on the values placed in column E. There needs to be 5 emails I can customize within the VBA code based on a Text value. One email each for values 1, 2 and 3 and two emails for value 4.

emails.png

Each email would have their own To, CC, BCC, body html message that can pull in data from that row and add the default signature below the html body message.

I would like to use column B to extract the Firstname and use within the body html as Hello (Firstname Value) and column D for the To email of each custom message.

If there is a Text Value of 4 in the cell then in this case I need to (.display) two separate custom emails instead of just one like the other text value options call for.

If a value in E is changed then a new email will (.display) based on the new value added for that person in the row.

If value in E is changed to empty then nothing happens.

I would also like the option for each value configured to watch in column E for me to be able change .display to .send in the code.

Thank you for any assistance or direction you can provide.