Sending Access reports via email

Retrum

New Member
Joined
Aug 10, 2006
Messages
27
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?
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

MyBoo

Board Regular
Joined
Aug 9, 2006
Messages
217
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

New Member
Joined
Aug 10, 2006
Messages
27
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

Board Regular
Joined
Aug 9, 2006
Messages
217
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.
 

Forum statistics

Threads
1,136,518
Messages
5,676,324
Members
419,619
Latest member
jalme

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top