Sending email to different people based on the value in a cell

• I have two columns:
• Column on left with names of engineers
• Column on right has drop down menu with option :YES and NO
• Every time an engineer completes his job, and selects YES in column to, a standard email is sent to two concerned ppl.
• I want to add the engineer’s name as well in the mailing list . How is it possible?

Additional info :

• Engineers name in the column same as PC name : Do you think I could use the following code =USERNAME() function to find the PC name and then add [email protected]?
  
  

  Please Login or Register  to view this content.

• Is there a way to tell the code to take the engineer’s name from column 1 and add [email protected] and send ?

Code for sending email used :

Please Login or Register  to view this content.

Any hints and help will be highly appreciated.

Thanks !

Just replace:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Are you trying to add the engineer to the To or the CC?

I would guess if the engineer is sending it to themselves you would want it in the CC line. Maybe:

Please Login or Register  to view this content.