send object

  • Thread starter Thread starter Alec Green
  • Start date Start date
A

Alec Green

Hi

I have set up a macro using the send object function, to send a report by
email, which works fine ater I enter a email address in the To: section -
however I would the recipient to be a field on my report.

Thanks

Alec
 
Alec,

You won't be able to reference a control in the report itself, but if
you have the email address in a form which is open at the time the macro
is run, you can use this syntax in the To argument of the SendObject
macro...
=[Forms]![NameOfForm]![NameOfEmailControl]
 
Thanks Karl, but it does not work!

KARL DEWEY said:
Try this in the TO line --
=[Reports]![lYourReportName]![YourReportField]

Alec Green said:
Hi

I have set up a macro using the send object function, to send a report by
email, which works fine ater I enter a email address in the To: section -
however I would the recipient to be a field on my report.

Thanks

Alec
Click to expand...
Click to expand...
 
Back
Top