Forum Discussion
Hyperlinks to send email to multiple recipients with multiple CC
Hello Everyone, Thank you for your support in advance My query is just to create a hyperlink to be able to send an email to multiple recipients and multiple CC, So I have come so far with thi...
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.