Mailto Formula - 225 Characters limit

[Safeer992]

Hi,
Good day,

I am trying to bypass 225 characters limit in email body but didn't find any solution so far.
Once 225 characters passed in email body 1 column, formula give error (#VALUE!).
Can anyone please help!

[Logit]

A number of resources I found online spoke of using more than one cell for your message. For example if the email body text is presently located in cell A1 ... break the entire text into two equal
lengths pasting the first half in cell A1 and the second half in B1.

No use the CONCENTATE command to join both cell contents in your formula.