Send Object (Access 2003)

  • Thread starter Thread starter daveyboy300
  • Start date Start date
D

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
 
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]
 
Back
Top