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 seperator is | (pipe) instead of , (comma)
I tried this formula but its not working
=Hyperlink("mailto:"&W1&subject="&S1&"&body="&A2:K151|"Email")
Kindly help
- Have you considered an email merge in Word using the Excel workbook as data source?
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)
