send object

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alec Green - 12 Oct 2005 18:21 GMT

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

Reply to this Message

Steve Schapel - 12 Oct 2005 18:42 GMT

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]

Signature

Steve Schapel, Microsoft Access MVP

> Hi
>
[quoted text clipped - 5 lines]
>
> Alec

Reply to this Message

KARL DEWEY - 12 Oct 2005 18:43 GMT

Try this in the TO line --
=[Reports]![lYourReportName]![YourReportField]

> Hi
>
[quoted text clipped - 5 lines]
>
> Alec

Reply to this Message

Alec Green - 12 Oct 2005 19:02 GMT

Thanks Karl, but it does not work!

> Try this in the TO line --
> =[Reports]![lYourReportName]![YourReportField]
[quoted text clipped - 8 lines]
>>
>> Alec

Reply to this Message