Reading text into varchar

[Hayat]

Hello,

I have a column (text datatype) and has to send an email as a text
(not attachment) using cdonts. I am reading the data from text column
storing in a varchar field and saying cdonts.body = [data].

This way I can send email to as a text format. Now, my problem is when
length of data is greater than the 8000 chars it truncates the rest of
the data.......and email I send is a truncated email.......loosing
imporatnt data.

How should I resolve this situation.......I am trying some different
ideas but not worked yet. Finally, I am writting the entire content in
a file and sending it as attachment but the reaquirement is to send it
as a body text.

Any ideas?

Let me know if you need more details!

Thanks,

-Hayat
www.mysticssoft.com

[John Bell]

Hi

You may want to look at:
http://support.microsoft.com/default...EN-US;Q325492&

John

"Hayat" <in**@mysticssoft.com> wrote in message
news:29**************************@posting.google.c om...

Hello,

I have a column (text datatype) and has to send an email as a text
(not attachment) using cdonts. I am reading the data from text column
storing in a varchar field and saying cdonts.body = [data].

This way I can send email to as a text format. Now, my problem is when
length of data is greater than the 8000 chars it truncates the rest of
the data.......and email I send is a truncated email.......loosing
imporatnt data.

How should I resolve this situation.......I am trying some different
ideas but not worked yet. Finally, I am writting the entire content in
a file and sending it as attachment but the reaquirement is to send it
as a body text.

Any ideas?

Let me know if you need more details!

Thanks,

-Hayat
www.mysticssoft.com