Hyperlinks to send email to multiple recipients with multiple CC

%3CLINGO-SUB%20id%3D%22lingo-sub-3479607%22%20slang%3D%22en-US%22%3EHyperlinks%20to%20send%20email%20to%20multiple%20recipients%20with%20multiple%20CC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3479607%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20support%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20query%20is%20just%20to%20create%20a%20hyperlink%20to%20be%20able%20to%20send%20an%20email%20to%20multiple%20recipients%20and%20multiple%20CC%2C%20So%20I%20have%20come%20so%20far%20with%20this%3CBR%20%2F%3E%22%3DHYPERLINK(%22mailto%3A%22%26amp%3B%24D%246%26amp%3B%22%3B%22%26amp%3B%24D%247%26amp%3B%22%3B%22%26amp%3B%24D%248%26amp%3B%22%3B%22%26amp%3B%24D%249%26amp%3B%22%3B%22%26amp%3B%24D%2410%26amp%3B%22%3B%22%26amp%3B%24D%2411%26amp%3B%22%3Fsubject%3D%22%26amp%3B%24A%242%26amp%3B%22%26amp%3Bcc%3D%22%26amp%3BD12%26amp%3B%22%3B%22%26amp%3BD13%26amp%3B%22%3B%22%26amp%3BD14%26amp%3B%22%3B%22%26amp%3BD15%2C%22Send%22)%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20once%20I%20type%202nd%20CC%20it%20shows%20me%20%23value!%20and%20I%20want%20to%20add%20multiple%20CCs%20but%20no%20errors%20show%20in%20front%20of%20me%20if%20I%20type%20one%20CC%20which%20means%20if%20I%20stop%20at%20%22D12%20%22so%20any%20ideas%20on%20how%20to%20solve%20this%20issue.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3479607%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3479657%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20to%20send%20email%20to%20multiple%20recipients%20with%20multiple%20CC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3479657%22%20slang%3D%22en-US%22%3EAny%20Help%20Please%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3479694%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20to%20send%20email%20to%20multiple%20recipients%20with%20multiple%20CC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3479694%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1416874%22%20target%3D%22_blank%22%3E%40EzzEldean%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDon't%20be%20so%20impatient!%20Forum%20members%20are%20users%20like%20you%20who%20help%20others%20as%20volunteers.%20Expecting%20a%20reply%20within%2020%20minutes%20is%20not%20reasonable.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYour%20formula%20works%20OK%20for%20me.%20Make%20sure%20that%20the%20cells%20that%20you%20refer%20to%20contain%20valid%20email%20addresses.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S1494.png%22%20style%3D%22width%3A%20723px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22S1494.png%22%20style%3D%22width%3A%20723px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22S1494.png%22%20style%3D%22width%3A%20723px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22S1494.png%22%20style%3D%22width%3A%20723px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22S1494.png%22%20style%3D%22width%3A%20723px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22S1494.png%22%20style%3D%22width%3A%20723px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22S1494.png%22%20style%3D%22width%3A%20723px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22S1494.png%22%20style%3D%22width%3A%20723px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22S1494.png%22%20style%3D%22width%3A%20723px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22S1494.png%22%20style%3D%22width%3A%20723px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22S1494.png%22%20style%3D%22width%3A%20723px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F378333i1D7AF6B0A5B6BB3F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S1494.png%22%20alt%3D%22S1494.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3479729%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20to%20send%20email%20to%20multiple%20recipients%20with%20multiple%20CC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3479729%22%20slang%3D%22en-US%22%3EAppreciate%20your%20answer.%3CBR%20%2F%3Eit's%20just%20a%20task%20that%20we%20need%20to%20do%20that's%20why%20we%20are%20in%20a%20hurry%20as%20we%20have%20a%20deadline%20regardless%20if%20you%20could%20help%20me%20with%20this%20matter%20as%20it%20still%20shows%20me%20%23value!%20even%20after%20checking.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3479813%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20to%20send%20email%20to%20multiple%20recipients%20with%20multiple%20CC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3479813%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1416874%22%20target%3D%22_blank%22%3E%40EzzEldean%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHere%20is%20a%20demo%20workbook%20with%20the%20formula%20in%20cell%20A1.%3C%2FP%3E%0A%3CP%3EWhat%20do%20you%20see%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3479832%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20to%20send%20email%20to%20multiple%20recipients%20with%20multiple%20CC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3479832%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%D9%90Of%20course%20appreciate%20your%20efforts%20but%20I%20really%20don't%20know%20why%20it%20keeps%20showing%20me%20the%20error%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20ideas%20or%20even%20another%20way%20to%20do%20the%20same%20purpose.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EzzEldean_0-1654640458377.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22EzzEldean_0-1654640458377.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22EzzEldean_0-1654640458377.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22EzzEldean_0-1654640458377.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22EzzEldean_0-1654640458377.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22EzzEldean_0-1654640458377.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22EzzEldean_0-1654640458377.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22EzzEldean_0-1654640458377.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F378342iCD24B0B17379BD77%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22EzzEldean_0-1654640458377.png%22%20alt%3D%22EzzEldean_0-1654640458377.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3479962%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20to%20send%20email%20to%20multiple%20recipients%20with%20multiple%20CC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3479962%22%20slang%3D%22en-US%22%3EAny%20Ideas%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3480721%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20to%20send%20email%20to%20multiple%20recipients%20with%20multiple%20CC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3480721%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1416874%22%20target%3D%22_blank%22%3E%40EzzEldean%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20attach%20a%20sample%20workbook%20(without%20sensitive%20data)%2C%20or%20if%20that%20is%20not%20possible%2C%20make%20it%20available%20through%20OneDrive%2C%20Google%20Drive%2C%20Dropbox%20or%20similar%3F%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3480747%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20to%20send%20email%20to%20multiple%20recipients%20with%20multiple%20CC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3480747%22%20slang%3D%22en-US%22%3EGerman%20formulas%20need%20%22%3B%22%3CBR%20%2F%3EEnglish%20formulas%20need%20%22%2C%22%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3481473%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20to%20send%20email%20to%20multiple%20recipients%20with%20multiple%20CC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3481473%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emy%20apologies%20but%20it%20shows%20me%20not%20supported%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20all%20I%20want%20to%20do%20is%20just%20be%20able%20to%20press%20the%20send%20button%20to%20send%20to%20multiple%20people%20and%20cc%20Multiple%3C%2FP%3E%3CP%3Epeople%3C%2FP%3E%3CP%3Eis%20there%20even%20a%20VBA%20for%20this%20istead%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3481486%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20to%20send%20email%20to%20multiple%20recipients%20with%20multiple%20CC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3481486%22%20slang%3D%22en-US%22%3Ethank%20you%20for%20your%20reply%20but%20if%20I%20do%20this%20it%20won't%20appear%20in%20outlook%20as%20emails%20but%20as%20texts%20which%20force%20me%20to%20edit%20them%20one%20by%20one%20so%20%3B%20helped%20me%20with%20that%3C%2FLINGO-BODY%3E
Occasional Contributor

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.

 

10 Replies

@EzzEldean 

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.

 

S1494.png

Appreciate your answer.
it's just a task that we need to do that's why we are in a hurry as we have a deadline regardless if you could help me with this matter as it still shows me #value! even after checking.

@EzzEldean 

Here is a demo workbook with the formula in cell A1.

What do you see?

@Hans Vogelaar 

ِ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.

EzzEldean_0-1654640458377.png

 

@EzzEldean 

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.

German formulas need ";"
English formulas need ","

@Hans Vogelaar 

 

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?

thank you for your reply but if I do this it won't appear in outlook as emails but as texts which force me to edit them one by one so ; helped me with that