email body getting truncated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that writes to a table.
I have created a button that uses a macro to invoke the sendmail object.
However the when it populates the message text it gets truncated.
Is this a parameter sent somewhere

Any help is greatly appreciated,
thanks,
 
I have a form that writes to a table.
I have created a button that uses a macro to invoke the sendmail object.
However the when it populates the message text it gets truncated.
Is this a parameter sent somewhere

Any help is greatly appreciated,
thanks,
Click to expand...

Might you be saving the text to a field of Text datatype (limited to
255 bytes) instead of a Memo (65536 bytes or bigger depending on how
it's filled)?

Note that a Query which sorts or groups by a Memo field will also
truncate it.

John W. Vinson[MVP]
 
No I checked that, it does seemed to be limited to about 255 characters.
I confirmed the message text is coming from a field that is set to MEMO
datatype.
Just the first 255 char get copied into the email body everything else is
truncated, while the datebase stores the entire message.

thanks,
 
No I checked that, it does seemed to be limited to about 255 characters.
I confirmed the message text is coming from a field that is set to MEMO
datatype.
Just the first 255 char get copied into the email body everything else is
truncated, while the datebase stores the entire message.
Click to expand...

Please post your code, and the SQL of the query if any.

John W. Vinson[MVP]
 
I don't really have code to post. I am using a macro that calls SendObject.
I then just reference the form fields in the parameters.
It pull the to:, subject:, bcc:, and even the message text: Only it
truncates the message text. I have done some searching around and it seems it
is a bug in the SendObject.

Any idea how I a can dynamically create the email based on the form fields?
 
I don't really have code to post. I am using a macro that calls SendObject.
I then just reference the form fields in the parameters.
It pull the to:, subject:, bcc:, and even the message text: Only it
truncates the message text. I have done some searching around and it seems it
is a bug in the SendObject.
Click to expand...

Other than opening an Outlook Automation object I can't think of
anything. Try searching at www.mvps.org/access or Tony's Email FAQ at
http://www.granite.ab.ca/access/email.htm.

John W. Vinson[MVP]
 
Back
Top