EMail a report

[henny]

I have a table of employees with there email addresses. I want a macro that will send an report via email to a selected employee. How can I accomplish this?

 

[Talismanic]

I could be wrong but I don't think you can accomplish that with just a macro. See this thread for instructions of how to do it with code.

Topic: Emailing System Help

 

[Talismanic]

I may of misunderstood your question the first time. If you have the form open and the email address is in a field. This may work: Put Me.YourFiledName in the To part of the SendObject argument.

Just use your field that holds the email address in place of the YourFieldName.


In code you would do it like this:

DoCmd.SendObject acReport, "ReportName", , Me.EmailAddress, , , _
"OptionalSubject", "OptionalMessage", True

 

[Talismanic]

henny, you may also want to check this more recent thread here:

Topic: E-mail Field

It may be a little more relevant to your situation.