Emailing Access 2003 Reports

[DDrowe]

Is there a way to email a completed Access 2003 report? I have a database
that people enter change requests into. I would like to email the completed
report or form to all that are invovled, including those that may not have
access. Is this possible? Is it possible to email to someone that does have
Access?

 

[Al Campagna]

D,
The SendObject allows for sending reports in the following 2 formats...
acFormatRTF
acFormatTXT
that would need no other application to view, other than say NotePad, or
WordPad, or most word processors.

Or... acFormatHTML, which should be viewable using any web browser

Or... SnapShot Viewer, which is a free Microsoft report viewer. See...
http://tinyurl.com/6tuxp

Or... there are PDF drivers available that will output your reports in
PDF.
http://www.tinypdf.com/
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Daniel Pineault]

You can use the SendObject method to email a report or another solution is to
print it as a PDF an e-mail that.

If you are using access 2003 or prior take a look at lebans'
http://www.lebans.com/reporttopdf.htm

If you google or search this forum for either of these subject you will find
a lot of existing information.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.

 

[DDrowe]

OK - that works and thanks but one problem. I only want it to email, send to
file one of the reports in the database. Right now there are only 5 reports
in the database but eventually there could be thousands or at least hundreds
and I only want to be able to email - send the latest one or the one that I
am on (modifying).

Thanks again.

 

[a a r o n . k e m p f]

yes; I'm 90% sure I've used Access to start an email in notes..

you just need to make sure that Lotus Notes is your default email
client.

-Aaron