autosend email confirmation - based of cell value

Copper Contributor

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 


to manually do this

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

outlook will auto send confirmation email.

1 Reply


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?