Emailing very large memo fields

[Paul_B]

Help!!

with Acsess 2000 I am trying to send an email using:

DoCmd.SendObject acSendNoObject, , acFormatTXT, assignto, , , task, comment, False

where 'comment' is a memo field on a form.

After much tedious test I have discovered it only sends if the length of the memo field is less than 2184 characters.

My perfect solution is not to convert the memo into an attachment - so is there some other way around this ?

 

[J-F]

Is the 2184 characters limit actually recognised by Microsoft? It tried to do the same thing a few weeks ago where access would crash after setting up and sending the first email from a whole list of addresses.
I thought that it might have been the fact that the content of the textbox was too big but tried it again with just a couple of line and it still crashed.
The only way I could get it to work was to send the text as an attachment.