Hyperlink to email

[tjcgti]

Hi all,

I am trying to make life a bit easier by hyperlinking data from an excel sheet to an email whereby you don't really need to copy anything into it.

I managed the below formula however it seems like if I go over a certain number of characters within this formula, the result ends up being #VALUE !

Am I correct in saying this? That this Hyperlink formula is limited as to how many sentences you can add or the number of characters you can have?

Bit stuck now as I'm not sure how else I can do this hyperlink.

My data is just an invoice number, amount and running total at the bottom.

[TABLE="width: 128"]
<tbody>[TR]
[TD="width: 64"]Invoice[/TD]
[TD="width: 64"]Amount[/TD]
[/TR]
[TR]
[TD="align: right"]740780[/TD]
[TD="align: right"]950.4[/TD]
[/TR]
[TR]
[TD="align: right"]740740[/TD]
[TD="align: right"]108[/TD]
[/TR]
[TR]
[TD="align: right"]740742[/TD]
[TD="align: right"]186[/TD]
[/TR]
[TR]
[TD="align: right"]740742[/TD]
[TD="align: right"]186[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD="align: right"]1430.4[/TD]
[/TR]
</tbody>[/TABLE]

=HYPERLINK("mailto:"&R266&"&subject=D/Debit Collection&body=Hello%0d%0dFor you reference the Direct Debit collection on or just after the 1st of next month will be for the following invoices:%0d%0d"&P266&" "&U266&"%0d"&P267&" "&U267&"%0d"&P268&" "&U268&" %0d"&P270&" "&U270&"","Email")

Can anyone assist in this?

Cheers
Tristan