This is a common problem based on the search I just did. On Monday, I used a little VBA to send email to contacts. It looped through a query result and sent the email to each contact. The email included a msg from a separate table with one record defined as memo. Then it looped through the data to build appended data for review. This data included 3 memo fields per issue, and multiple issues.
On Monday, it worked fine. All memo fields were plugged into the email. Today, Friday, I had to resend to one contact, so added a WHERE for her. The email body msg (memo) was imported fine. All memo fields associated with the issue were truncated to 255(?).
The query uses four related tables and they return complete memo fields when opened. I've removed (prior to this problem) all formatting in the design. I've since removed all hints of formatting (including captions).
The query, which I confess was renamed, now truncates every issue-associated memo field (the msg is selected from the table directly for the email). I even eliminated tables from the query to show just one of the memos. Still truncated.
As many people that have this problem, certainly there is a reason and a solution. I have, indeed, noted that formatting causes the truncation (even though the HELP does not tell you this clearly), but I had that problem and eliminated it. What is the real answer?
Thanks.
On Monday, it worked fine. All memo fields were plugged into the email. Today, Friday, I had to resend to one contact, so added a WHERE for her. The email body msg (memo) was imported fine. All memo fields associated with the issue were truncated to 255(?).
The query uses four related tables and they return complete memo fields when opened. I've removed (prior to this problem) all formatting in the design. I've since removed all hints of formatting (including captions).
The query, which I confess was renamed, now truncates every issue-associated memo field (the msg is selected from the table directly for the email). I even eliminated tables from the query to show just one of the memos. Still truncated.
As many people that have this problem, certainly there is a reason and a solution. I have, indeed, noted that formatting causes the truncation (even though the HELP does not tell you this clearly), but I had that problem and eliminated it. What is the real answer?
Thanks.
