Send Object

K

Kathy Webster

I'm using the SendObject macro command to send an email of the current
record.
I want the [Notes] field to appear as the text of the email, so I have
=[Notes] as the Message Text Argument.

It works great on short notes, but it is truncating long notes (the Notes
field is a Memo field and can be quite lengthy)

Is there anything I can do to be sure the entire contents of the notes field
is included in the body of the email?

Thank you.
 
A

Access Jackass via AccessMonster.com

I have yet to figure this out as well, so i consulted a pro and this is what
he wrote:

Thanks for your email, and the confirmation of payment. I am working on the
later stages of an Access development at present, so will get to your
specific items when I have a moment.

In the mean time, Access will chop off the text in a memo field at 255
characters if:
a) There is anything in the Format property of the text box on the
form/report, or in the Format property of the field in the table, or
b) It has to perform any aggregation on the field.

Examples of aggregation:
1. Totals query where you Group By the memo field.
2. Query with DISTINCT predicate (= query's Unique Values property set to Yes.
)

Workaround for #1: Use First instead of Group By. (The name of the output
field changes from MyMemo to FirstOfMyMemo.)

Workaround for #2: Omit the memo field. Then create another query using the
first as an input table, and add the memo there.

The memo may also be chopped off in other contexts, such as in the column of
a list box or combo.

Let me know if that does not address your case.

Regards

Allen Browne - Microsoft MVP (Most Valuable Professional)
Allen Browne's Database and Training - Perth, Western Australia.
Ph: 618 9378 4113. Fax: 618 9378 4150. Mb: 0412 298 692.
http://allenbrowne.com

Now i yet to try this so let me know if it works.

Kathy said:
Any takers on this one???
I'm using the SendObject macro command to send an email of the current
record.
[quoted text clipped - 8 lines]
Thank you.
 
K

Kathy Webster

Thanks for the reply. Hmm...I don't have any of these issues...no
aggregation, no format properties. It's a simple textbox of a memo field
with no additional format properties. The underlying query is a basic select
of the current record displayed in the form. Couldn't be more simple or
uncomplicated. But it is still chopping off at 255 characters. Aaargh!


Access Jackass via AccessMonster.com said:
I have yet to figure this out as well, so i consulted a pro and this is
what
he wrote:

Thanks for your email, and the confirmation of payment. I am working on
the
later stages of an Access development at present, so will get to your
specific items when I have a moment.

In the mean time, Access will chop off the text in a memo field at 255
characters if:
a) There is anything in the Format property of the text box on the
form/report, or in the Format property of the field in the table, or
b) It has to perform any aggregation on the field.

Examples of aggregation:
1. Totals query where you Group By the memo field.
2. Query with DISTINCT predicate (= query's Unique Values property set to
Yes.
)

Workaround for #1: Use First instead of Group By. (The name of the output
field changes from MyMemo to FirstOfMyMemo.)

Workaround for #2: Omit the memo field. Then create another query using
the
first as an input table, and add the memo there.

The memo may also be chopped off in other contexts, such as in the column
of
a list box or combo.

Let me know if that does not address your case.

Regards

Allen Browne - Microsoft MVP (Most Valuable Professional)
Allen Browne's Database and Training - Perth, Western Australia.
Ph: 618 9378 4113. Fax: 618 9378 4150. Mb: 0412 298 692.
http://allenbrowne.com

Now i yet to try this so let me know if it works.

Kathy said:
Any takers on this one???
I'm using the SendObject macro command to send an email of the current
record.
[quoted text clipped - 8 lines]
Thank you.
 
A

Ann

Did you ever figure this out? I'm having the same problem and haven't been
able to find an answer. Thanks.

Kathy Webster said:
Thanks for the reply. Hmm...I don't have any of these issues...no
aggregation, no format properties. It's a simple textbox of a memo field
with no additional format properties. The underlying query is a basic select
of the current record displayed in the form. Couldn't be more simple or
uncomplicated. But it is still chopping off at 255 characters. Aaargh!


Access Jackass via AccessMonster.com said:
I have yet to figure this out as well, so i consulted a pro and this is
what
he wrote:

Thanks for your email, and the confirmation of payment. I am working on
the
later stages of an Access development at present, so will get to your
specific items when I have a moment.

In the mean time, Access will chop off the text in a memo field at 255
characters if:
a) There is anything in the Format property of the text box on the
form/report, or in the Format property of the field in the table, or
b) It has to perform any aggregation on the field.

Examples of aggregation:
1. Totals query where you Group By the memo field.
2. Query with DISTINCT predicate (= query's Unique Values property set to
Yes.
)

Workaround for #1: Use First instead of Group By. (The name of the output
field changes from MyMemo to FirstOfMyMemo.)

Workaround for #2: Omit the memo field. Then create another query using
the
first as an input table, and add the memo there.

The memo may also be chopped off in other contexts, such as in the column
of
a list box or combo.

Let me know if that does not address your case.

Regards

Allen Browne - Microsoft MVP (Most Valuable Professional)
Allen Browne's Database and Training - Perth, Western Australia.
Ph: 618 9378 4113. Fax: 618 9378 4150. Mb: 0412 298 692.
http://allenbrowne.com

Now i yet to try this so let me know if it works.

Kathy said:
Any takers on this one???

I'm using the SendObject macro command to send an email of the current
record.
[quoted text clipped - 8 lines]

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top