sorry for incomplete text earlier

i am using  sp_OASetProperty for setting property value for a cdo.message
object. But it might happen body size is more than 8000 character... in
that
case i want to write follwoing statement in a loop
  EXEC @V_hr = sp_OASetProperty @V_iMsg, 'HTMLBody', @P_Body   ..

so that more than 8000 charactes can be added to body part.. is it possible
?
anyother way of passing body as more than 8000 character?

Finding the right record
CHARINDEX in CASE Within SELECT Statement
Default Value Calculation
Deadlock updating different rows
No retrieving dupicate rows