Macros and e-mailing

  • Thread starter Thread starter Pap
  • Start date Start date
P

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,
 
Pap,

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