RESOLVED: Strings truncating in Outlook

[jrpfinch]

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:

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

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

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

It is then attached to email

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?

[jrpfinch]

Putting .value instead of .text solves this problem