Macros and e-mailing

[Pap]

I am trying to send an access report as a Rich Text
Format to an e-mail address using a macro. However,
instead of hard coding the e-mail address into the macro
I want it to pick it up off the form that the macro runs
from (off a button). Can anyone help?

Thanks,

 

[Steve Schapel]

Pap,

In the "To" argument of the SendObject macro action, put the equivalent
of...
=[Forms]![NameOfForm]![NameOfEmailTextbox]