Send Report via Email

[ViRi]

Hi

I have a Report that I would like to send via Email using Outlook Express directly from the Report ie without leaving Acess.

Thanks
ViRi

 

[gemma-the-husky]

docmd.sendobject

 

[slifer666]

docmd.sendobject

Hi, i would also like to know how to do this, but what you have given does not help, what am i meant to do with this code?

 

[m.f.smith@leeds]

Email a report

DoCmd.SendObject acSendReport, "REPORT NAME", acFormatRTF, "EMAIL ADDRESS", , , "EMAIL SUBJECT", , False

The above code segment can be used to send an Access Report as an attachement. This would run from the onclick event of a command button.
Suggest looking in help for more detailed explanation.

 

[andrewneal]

This is great; how would I phrase it to send as Snap Shot Format with the email address list and subject automatically put in it?

Email: first.last@mody.mil
Subject: Taskers