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.
