I have SQL Server backend database that logs all messages coming into an Oulook 2000 mailbox. On the Application_NewMail event I have written a proc that logs onto the SQL databnase using ADO, and then adds a new record and applies information to the relevant fields in that record, such as Sender, Subject and Body from the new meassage. Sender and Subject are fine, but when it tries to write the contents of the variable hloding the message body to the body field in SQL nothing gets written. I think this is because the body field in SQL is declared as ntext, as when I converted it to nvarchar the text was written to SQL. I have tried the appendchunk method but this doesn't work either. I have also set up a small test Access 2000 project that uses the same SQL backend, and I can write variables to ntext fields happily. Is this something to do with Outlook? Please help me!! 
[sig][/sig]
[sig][/sig]