Send Object (Access 2003)

[daveyboy300]

I currenty have a send object macro, for submitting reports via email
attachments(.rtf) which works, however. I want the macro to "pick up" the
email address from a field within my db rather then a fixed address set up
within the send object properties.

The scenario is multiple branches need to submit the same report to there
relavent nominated head office controller.

dave

 

[Steve Schapel]

Dave,

If the email address is within the current record of a form that is open
at the time, then in the 'To' argument in your macro, you can put like this:
=[Forms]![NameOfForm]![NameOfYourEmailField]