Send A Report Attachment Via SafeMail

[WB786]

Here is what I need to do:

1 - Already have a button called Send Email.
2 - Need to be able to send a report as an attachment using SafeMail.myAttachments method.

I know how to use DoCmd.SendObject property but how do I combine the two togather so the report gets attached to the email and is sent to the TO address I have coded. I don't want the user to see the email popping up at all. The only thing they will see is your EMail Request Has Been Sent.

Thanks,

WB

 

[JerryKlmns]

Export your report as snapshot and use your SafeMail object.

 

[WB786]

That is exactly what I end up doing. Thanks for the tip though.

WB