Hi All

I have a memo field in an Access 2003 database table which contains text I wish to use as body text in an email created using VBA.
Even though the memo field supports more than 255 characters it still only places 255 chartacters in Outlook.

I have tried changing the data type in VB to variant instead of string but still no change.

I would appreciate any assistance.

Cheers in advance.

Adam

Maybe this thread (http://www.accessforums.net/ftopic5593.html) can shed some light on the topic.