Re: HYPERLINK=mailto: - getting info from cells
I was able to concatenate 6 email addresses and no more... is this an excel bug?
Code
=HYPERLINK("[EMAIL=""&E3&"?Subject="&E6&"&CC="&E4&"&Bcc="&E5&"&Body="&E7,"Click"]mailto:"&E3&"?Subject="&E6&"&CC="&E4&"&Bcc="&E5&"&Body="&E7,"Click[/EMAIL] on this Hyperlink to send the Email to all List")
while B1 to B100 are email addresses, E4 is this;
Code
=SUBSTITUTE(SUBSTITUTE(CONCATENATE(B1,B2,B3,B4,B5,B6,B7,B8,B9,B10,B11,B12,B13,B14,B15,B16,B17,B18,B19,B20,B21,B22,B23,B24,B25,B26,B27,B28,B29,B30,B31,B32,B33,B34,B35,B36,B37,B38,B39,B40,B41,B42,B43,B44,B45,B46,B47,B48,B49,B50,B51,B52,B53,B54,B55,B56,B57,B58,B59,B60,B61,B62,B63,B64,B65,B66,B67,B68,B69,B70,B71,B72,B73,B74,B75,B76,B77,B78,B79,B80,B81,B82,B83,B84,B85,B86,B87,B88,B89,B90,B91,B92,B93,B94,B95,B96,B97,B98,B99,B100),E3,""),E5,"")
This hyperlink only works when I have only 6 email addresses in the range of B1:B100