This is a discussion on Reading text into varchar within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello, I have a column (text datatype) and has to send an email as a text (not attachment) using ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| ||||
| Hi You may want to look at: http://support.microsoft.com/default...EN-US;Q325492& John "Hayat" <info@mysticssoft.com> wrote in message news:29e54c97.0310050024.268c40a1@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 |