Sending Access reports via email

[Retrum]

In the past I create some nice reports in Access but couldn't find a way to send them with out the formatting getting screwed up or putting it in Excel and the formatting not looking the same.

I have heard that they can be sent in outlook. But how do you attach just a report and how is it view by the person on the other end of the email if they don't have the database the report is created in?

 

[MyBoo]

Open HELP and search on SendObject. Select Example... you want to do something like...

DoCmd.SendObject acSendReport

As for the person viewing the report at the other end. What you send is a snapshot, just as if you sent the report to the printer then sent the printout to the user.

 

[Retrum]

Thanks I will try it.

 

[Retrum]

Is there a way to group multiple reports and send them so they open all together? It would be nice for others to open up just one file instead of 10 or 20. Is that possible?

 

[MyBoo]

Not sure... never tried it.
Best answer to that would be to try it.

Dim MyReport

MyReport = ReportName1 & ReportName2
DoCmd.SendObject.acSendReport MyReport.....

Like I said, I've never tried it, so I'm not sure if this will work.