Jun 07 2022 01:57 PM
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 this
"=HYPERLINK("mailto:"&$D$6&";"&$D$7&";"&$D$8&";"&$D$9&";"&$D$10&";"&$D$11&"?subject="&$A$2&"&cc="&D12&";"&D13&";"&D14&";"&D15,"Send")"
However, once I type 2nd CC it shows me #value! and I want to add multiple CCs but no errors show in front of me if I type one CC which means if I stop at "D12 "so any ideas on how to solve this issue.
Jun 07 2022 02:15 PM
Jun 07 2022 02:31 PM
Don't be so impatient! Forum members are users like you who help others as volunteers. Expecting a reply within 20 minutes is not reasonable.
Your formula works OK for me. Make sure that the cells that you refer to contain valid email addresses.
Jun 07 2022 02:41 PM
Jun 07 2022 03:09 PM
Jun 07 2022 03:23 PM
ِOf course appreciate your efforts but I really don't know why it keeps showing me the error
any ideas or even another way to do the same purpose.
Jun 07 2022 04:43 PM
Jun 08 2022 12:43 AM
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
Jun 08 2022 12:53 AM
Jun 08 2022 04:04 AM
my apologies but it shows me not supported
but all I want to do is just be able to press the send button to send to multiple people and cc Multiple
people
is there even a VBA for this istead?
Jun 08 2022 04:06 AM
Oct 18 2022 07:14 AM
Did you find a solution? I have the same issue, I cannot figure it out how to solve it... :(
Nov 09 2022 12:36 PM
Nov 18 2022 06:12 AM
Nov 19 2022 10:29 AM
Jan 26 2023 08:46 PM
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.