Can you help me with a send email macro? Access 2010

[Corwin Moyne]

I have built an after update macro that auto orders printing plates by using the sendemail macro when the stock is set to 0 by the user. The problem is, I need to add info from a related table to the body of the email but I cannot figure out how. It works fine when its only sending info from the table itself. How can I add a field from a related table?

[PGAC]

If you modify the form's recordsource to include the field from the related table, then add this as a field to the form you are using, you should be able to include it into your email.

In you macro, update the Body field to:

="your message" & Forms!FormName!FieldName & "your message"

I have done something simliar in the past, emailing from a form used to manage contacts and used fields to populate the "To" on the email.

[Corwin Moyne]

The after update macro is being triggered when the table updates though, not the form.

[PGAC]

Why not use the EmailDatabaseObject macro command on the form's after update (just don't specify an object to send).

[Corwin Moyne]

I have just tried your suggestion. I used the on close macro as I may need to change the qty on up to 7 items on a single form and I don't want to send an email for each item.

The on close does not work either as it only re orders the first item on the list. Getting closer though.