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]
 

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

Send Object Macro 3
How to Avoid getting email message box when Access macro sends rep 1
Condition for Send object 1
Emailing multiple reports in Access 0
send object 3
Send object function with a CSV file 4
send object command - 5
send object using a maco--filter report 1

Back
Top