RESOLVED: Strings truncating in Outlook

I am using a vlookup to return a long piece of text to a cell that I then want to put in the body of an email. This piece of text has carriage returns and spaces in.

My piece of VBA enters the lookup value:

Code:

---

Worksheets("Valuation Types").Cells(42, 1).Value = strValType

---

Then gets the results of the lookup from an adjacent cell:

Code:

---

strDisclaimer = Trim(Worksheets("Valuation Types").Cells(41, 2).Text)

---

It is then attached to email

Code:

---

olMailItem.Body = strDisclaimer

---

Unfortunately the string is truncated about half way through and I am not sure why. It does not truncate where there is a carriage return, I have tried splitting the text into 2 halves and I have tried changing the format of the cell to a few different combinations but with no luck. Any ideas?

Putting .value instead of .text solves this problem