Set a macro to send an email

[lena_form]

I have a macro that each time a change is requested in a document, belonging
to a database, send an email to warn of this request. But the email has a
fixed text in the subject. I want the subject with the result of a specific
field of a table (the document name or number)
how do I do it?
Thanks

 

[Steve Schapel]

HC,

How will we "know" which data to put in the Subject? Is it in the active
record on a form at the time that the email is sent? Can you give a
specific example?

 

[lena_form]

Hello and thanks for the quick answer.
Excuse the delay in my answer but I have been on vacation. As for macro, the
macro is activated by a button that is in a form and not in the table on
which I want to send the field
Thanks