Forum Discussion
Email the selected Cells
I need help in finding a solution to send email automate feature is disabled so no idea what should I do email content To : W1 Subject: S1 Body : A2:K151 There is no CC Please help, My list...
With comma as link separator formula looks like
=HYPERLINK("mailto:" &W1 & "&subject=" & S1 & "&body=" & TEXTJOIN(",",,A2:K3),"Email")You need to join texts in the range in one text to add it to the body. However, entire link is limited by 255 characters length, otherwise it returns #VALUE! error. Thus I'm not sure you can send long text here.
thank you for looking into the issue
I guess 255 Character limit restriction might be causing
is there a way to do it though VBA ?
Yes, with VBA it could be done. VBA is not my territory, what quick googling returns
How to have a Hyperlink Mailto with more than 255 characters. (msofficeforums.com)