>Sorry Borislav not explaining myself correctly. I am using the Outlook mail class from this site. When I run the sendmail procedure there is a variable called lcbodytext used to populate the body of the email.
>
>I want to populate this variable with some header information, the contents of a query from a cursor and some footer information. Dependant on the number of records in the query what I have noticed is that not all information is stored to the variable (Chopping off some records and the footer). Thats why I was just wandering if there is a limitation of the amount of characters you can store to a variable? I know I could create a txt file with the query results in and attach it but I would like to put everything in the body of the email.
>
>Neil
From Limitations (HELP):
Other Capacities
Maximum # of characters per character string or memory variable 16,777,184
You could do this just for testing:
After you build this string, export it to file with STRTOFILE() and open this file with notepad to see if all info is in it. If so the you should seach somewhere else to find who cut you string.
Becuase I never used this class I don't know what it do. Also I am not sure what is the maximium number of chars for eMail body when you send it directly from Outlook.
Another suggestion, when you export that variable to file, open that file, select all->Copy. Then try to Paste its contetns directly to Outlook and send this mail to you, just to see if Outlook will cut the body.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.