Attach "Snapshot Format" Report to Outlook?

[firebirdta84]

Is there a way where I can put a button on my Access form that, when pressed, will automatically open Outlook, open a blank new email, and attach an Access report? Currently, the user must save the report as "Snapshot Format" to their computer, and then open Outlook and attach that file. Just looking for a way to automate that. Thanks in advance for your help!

Joe

 

[PHV]

Have a look at the DoCmd.SendObject method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[firebirdta84]

It doesn't appear that the SendObject method allows for an attachment in a snapshot format. I tried the other methods such as HTML but the formatting is completely off. Thanks.

 

[orna]

snapshot format = acFormatSNP