email macro

[alex]

Hello,

I have a memo field in an access table that feeds a text box in a form. I
also have a macro built that creates an email and who to send it to. When i
run the macro, for some reason, only the first 255 characters get copied into
the body of the email. I dont think the issue is with the table because a
memo field holds over 65,000 characters. The text box does seem to hold all
of the msg that i'm trying to send but for some reason, only a portion gets
copied over. Does anyone know what the problem is and how i can fix it?

Thank you in advance,

Alex

 

[alex]

Anyone have any suggestions here?

 

[Bill Mosca]

It would help if we knew a bit more detail. Are you emailing a report? Did
you chose RTF format?

Maybe if you converted the macro to VBA code you could post the code.
Sometimes that's easier than writing out all the macro steps by hand.

--
Bill Mosca, MS Access MVP
http://www.thatlldoit.com
http://mvp.support.microsoft.com/profile/Bill.Mosca
http://tech.groups.yahoo.com/group/MS_Access_Professionals

 

[alex]

Bill,

This macro just creates an email nothing more. There arent any attachments.

The text that is being cut off is in a text box and the contents of the text
box need to go to the body of the email. I'm not sure why it was built that
way. I am guessing the original msg had less than 255 characters in it which
is why they didnt have problems with the macro before. What needs to be in
RTF format?

Thank you,

Alex

 

[Alex Torres]

A text box will hold only 255 characters. If you macro is copying from the
text box instead of the memo, that's why It got truncated.