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.