Hyperlink Mailto with large email with multiple lines?

Hi all,

I have a hyperlink mailto - =HYPERLINK(CONCATENATE("mailto:",C2,"?subject=",C3,"&body=",C4),"Request Update")

But the body only supports a line or two of text, which isn't helpful, and doesn't allow for different lines to be placed within it.

I then tried addeding extra text with another cell - =HYPERLINK("Mailto: "&C2&"?Subject="&C3&"&Body="&C4&" "&TEXT(C5,"$#,##0.00")&".")

But this doesn't work either. Both come up with #value error with too much text..

Any help would be appreciated!

Originally Posted by ld2x07

Hi all,

I have a hyperlink mailto - =HYPERLINK(CONCATENATE("mailto:",C2,"?subject=",C3,"&body=",C4),"Request Update")

But the body only supports a line or two of text, which isn't helpful, and doesn't allow for different lines to be placed within it.

I then tried addeding extra text with another cell - =HYPERLINK("Mailto: "&C2&"?Subject="&C3&"&Body="&C4&" "&TEXT(C5,"$#,##0.00")&".")

But this doesn't work either. Both come up with #value error with too much text..

Any help would be appreciated!

Hello mate,
I am also wondering how this is done, or if there is a way.......you can type and add break lines in the client email subject line but for whatever reason when using &C1&M1&M2 to bring in text from certain cells within an excel document and when the text extends past one line you get the #Value error or the message "error processing command line arguments" that is before the email client opens up, incidently the email client I am using is Lotus Notes 8.02.