How to write a mailto link in excel without problems

Question

I am trying to create a mailto link in excel which will allow me to make multiple emails very easy. As I need the body text to be separate onto different lines I am using concatenate and using char(10) to create the line space. The problem I am having is that the link is throwing an error very strangely.

This is my command

=HYPERLINK("mailto:" & B1 & "?subject=" & B2 & "&body=" & CONCATENATE(B14, CHAR(10), CHAR(10), B15, CHAR(10), B16, CHAR(10), B17, CHAR(10), B18, CHAR(10), B19, CHAR(10), B20, CHAR(10), B21, CHAR(10), B22, CHAR(10), B23, CHAR(10), B24, CHAR(10), B25), "Link")

B14, B15, B17,B19,B22, B24 and B25 print fine, however if the contents of those cells get moved into one of the not working cells, it still won't work so its not a cell content issue from what I can see. As I am using a Mac macros are not a simple solution to this problem