I would like to email multiple reports in one e-mail

[Guest]

I have reports that provide financial data on cost centers. One manager is in
charge of multiple cost centers. I would like to put all reports in one
e-mail rather than sending multiple emails. Any suggestions?

 

[Ron2005]

Export each of the reports to a single Spreadsheet. Be sure to have
meaningful names for the "output" range name for each of the different
exports. Each export will create a separate Tab within the spreadsheet.


And then send 1 email with that spreadsheet as an attachment.

 

[Guest]

Ron2005,

Thanks for your response but when I exported the report to Excel I lose all
of my formatting. The way I would like to send out the reports is in the
Snapshot viewer format using a macro. I am trying to avoid having to having
to run the reports manually.

lpdc

 

[Ron2005]

For formated reports I have followed two types of processing depending
on the types of formatting.

approach 1
1) create a master spreadsheet that has all the formatting and tabs,
etc
2) in module copy the master to this to-be emailed version.
3) export all required data.
4) from access open the tobemailed version, and move the data portion
of the exported tabs to the data portion of the base tab. (you can also
then delete the exported tabs)
5) save and continue as I mentioned.

Approach 2
1) export all required data.
2) from access open the spreadsheet and go to each of the tabs and
perform the formatting that was necessary. About 90% of the formating
that excel allows can be executed from within access.
Note: (I usually start the process by doing the export, then manually
open the spreadsheet and create a macro that performs the formatting.
Then copy the code from the macro back into access and add the
additional modifiers to the instructions to execute it from access.)

Ron

 

[Tony Toews]

I have reports that provide financial data on cost centers. One manager is in
charge of multiple cost centers. I would like to put all reports in one
e-mail rather than sending multiple emails. Any suggestions?

You can do that but you can't use SendObject as that's one of it's
many limitations.

For alternatives to suit your situation see Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Ron2005]

And that is why I don't use sendobject but always code everything like
that in the module.

 

[Tony Toews]

And that is why I don't use sendobject but always code everything like
that in the module.

But that's only one of twenty reasons. <smile> See SendObject's
twenty limitations
http://www.granite.ab.ca/access/email/sendobject.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm