send object

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
 
S

Steve Schapel

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]
 
A

Alec Green

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge file containing a Word Table 0
Insert name and adress from a list in a word document 1
Can't send emails on new PC 1
Office 365 Email Encryption One time Passcode 0
Change the "From" email address VBA 0
Sharepoint not capturing staff name when automation runs 0
"The operation cannot be performed because the object has been deleted." 0
Outlook emails loading very slowly 0

Top