autosend email confirmation - based of cell value

We are using a 'form' to update a Spreadsheet 

Is it possible that when asked in the form do you want confirmation email - [tick yes]

For excel to automatically send and email response to the spreadsheet update.

We are using the formula 

 =HYPERLINK("MailTo:"&BH2&"?Subject="&BI2&"&cc="&$BA$2&"&body="&BJ2,"EMAIL")

to manually do this

But we want - when cell  [BD2] is "yes"

outlook will auto send confirmation email.