Sending a report (generated by MS/ACCESS) as an email attachment

[Susan Bricker]

I would like to generate a report (I have the report working already)
using MS/ACCESS 2000 and then have the ability to send the report as an
email attachment to my colleagues. I have looked around in the
MS/ACCESS Help facility and found that I can click on FILE (on the Menu
Bar) and then click on SEND TO. This will generate, either, a 'Snapshot
format' or 'Rich Text Format' file and send an email.

Two problems:
1. Is it possible to create a button on a customized tool bar to do this
function? If so, how?

2. And more importantly ... the report in RTF or SNP format does not get
generated exactly as it appears in the MS/ACCESS report format.
Specifically, there is a horizontal line that I have placed after EVERY
detail line. However, this line only appears SOMETIMES in the RTF or
SNP format. Does anyone have any suggestions for me to get the report
to be replicated with this horizontal line after EVERY detail line in
the RTF or SNP format?
Thanks so much.
Sue

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Rick Brandt]

"Susan Bricker" <sb****@att.net> wrote in message
news:40*********************@news.frii.net...

I would like to generate a report (I have the report working already)
using MS/ACCESS 2000 and then have the ability to send the report as an
email attachment to my colleagues. I have looked around in the
MS/ACCESS Help facility and found that I can click on FILE (on the Menu
Bar) and then click on SEND TO. This will generate, either, a 'Snapshot
format' or 'Rich Text Format' file and send an email.

Two problems:
1. Is it possible to create a button on a customized tool bar to do this
function? If so, how?
Look in help for DoCmd.SendObject
2. And more importantly ... the report in RTF or SNP format does not get
generated exactly as it appears in the MS/ACCESS report format.
Specifically, there is a horizontal line that I have placed after EVERY
detail line. However, this line only appears SOMETIMES in the RTF or
SNP format. Does anyone have any suggestions for me to get the report
to be replicated with this horizontal line after EVERY detail line in
the RTF or SNP format?

Look again and you should see that the RTF version has no lines at all.
Snapshot format is the only export format that supports graphical elements
of any kind. All other will export the Text only.

The lines you see on screen when looking at a Snapshot can be a function of
your video card settings and the current zoom setting. See if the lines
are actually there if you change zoom levels or actually print the file.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Chuck Van Den Corput]

On 18 May 2004 18:16:35 GMT, Susan Bricker <sb****@att.net> wrote:

I would like to generate a report (I have the report working already)
using MS/ACCESS 2000 and then have the ability to send the report as an
email attachment to my colleagues. I have looked around in the
MS/ACCESS Help facility and found that I can click on FILE (on the Menu
Bar) and then click on SEND TO. This will generate, either, a 'Snapshot
format' or 'Rich Text Format' file and send an email.

Two problems:
1. Is it possible to create a button on a customized tool bar to do this
function? If so, how?

2. And more importantly ... the report in RTF or SNP format does not get
generated exactly as it appears in the MS/ACCESS report format.
Specifically, there is a horizontal line that I have placed after EVERY
detail line. However, this line only appears SOMETIMES in the RTF or
SNP format. Does anyone have any suggestions for me to get the report
to be replicated with this horizontal line after EVERY detail line in
the RTF or SNP format?

Further to Rick's comments, there has been discussion in this ng
(accessible via deja news) on going one step further: generating a PDF
version of an Access report and e-mailing that. There are no
formatting issues with PDF's as there are with RTF's and no
readability issues as there are with SNP's (virtually everyone has
Acrobat reader).

Chuck

[Susan Bricker]

Chuck,

How do I view the previous discussions concerning generateing PDF
documents from Access reports? By the way, thank you for your
suggestion.

Sue

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Susan Bricker]

Rick,

Thank you for your reply. Printing the SNP file did reveal that the
horizontal lines after every detail line does exist and appear, just not
when viewing the report online. Too bad. I'll keep looking for a
solution, keeping this one in my back pocket. By the way, I was able to
drag and drop the 'send ..' function onto my customized Tool Bar from
the 'File' option on the Menu Bar. Works like a charm.

Sue
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Chuck Van Den Corput]

On 19 May 2004 17:46:33 GMT, Susan Bricker <sb****@att.net> wrote:

Chuck,

How do I view the previous discussions concerning generateing PDF
documents from Access reports? By the way, thank you for your
suggestion.

Sue

The URL http://groups.google.com takes you into historic posts for all
of Usenet.

The URL
http://groups.google.com/groups?hl=e...ases.ms-access
takes you into historic posts for this ng.

Just key in search words as you would in Google and you will have
access to all historic discussion threads. There are three radio
buttons. Be sure to click the leftmost one.

Chuck

[Tony Toews]

Susan Bricker <sb****@att.net> wrote:

I would like to generate a report (I have the report working already)
using MS/ACCESS 2000 and then have the ability to send the report as an
email attachment to my colleagues.

FWIW 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

[SA]

Sue:

You could look at our PDF and Mail Library for Access. You'll find it on
our web. You need at least one of the supported PDF drivers, but after
that the the code can be as simple as:

Dim objPDF as New PDFClass
Dim objMail as New MailClass
With objPDF
.PDFEngine = 2 'Adobe PDF Printer
.ReportName = "My Report"
.OutputFile = "c:\some dir\some file.pdf"
.PrintImage
End With

With objMail
.MsgSubect = "Monthly Report"
.MsgBody = "Here's this month's report in PDF format"
.RecipientAdd "Joe Recipient", jr********@test.com, , , False
.AttachmentAdd "c:\some dir\some file.pdf"
.SendMail
End With
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg
"Susan Bricker" <sb****@att.net> wrote in message
news:40*********************@news.frii.net...

Chuck,

How do I view the previous discussions concerning generateing PDF
documents from Access reports? By the way, thank you for your
suggestion.

Sue

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!