autosend email confirmation - based of cell value

[Russel2160]

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.

[#2]

@Russel2160 

I don't think that triggering to send the mail can be done with a hyperlink.

Let me but love to disabuse :)

Until then, here are some links with VBA and around :)

How to send email if a certain cell is modified in Excel?

How to automatically send email based on cell value in Excel?