473,581 Members | 2,488 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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


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!
Nov 12 '05 #1
7 16577
"Susan Bricker" <sb****@att.net > wrote in message
news:40******** *************@n ews.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.SendObjec t
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
Nov 12 '05 #2
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
Nov 12 '05 #3
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!
Nov 12 '05 #4

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!
Nov 12 '05 #5
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
Nov 12 '05 #6
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
Nov 12 '05 #7
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******** *************@n ews.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!

Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
5372
by: BillLin | last post by:
I am new to MS Access VBA. I am doing an Access porject with the function of generating funding files in a required format in a folder and then attaching it to an email (with the number of transactions and their totals) and sending it to a number of receipiants. Can anybody give me a hints on how to use Access VBA to send email with...
2
5515
by: Lee | last post by:
As the subject states, I have been playing in the system trying to figure out a method of using a report as the email body text. So far, the closest I have come is the acFormatHTML. However, when the report is more than one page, it autoformats the report to multiple pages. I need one document. Reason for doing this as text vs....
3
2585
by: Prakash Wadhwani | last post by:
Hi !! I have been browsing around but have not been able to find a simple, lucid solution ... or maybe I'm just too confused. I know this has been asked before by many ... but pls bear with me. Step 1: I want to place a button which outputs my report as a snapshot to a specific folder. What is he VBA code to acomplish this ? Step2: I...
7
3548
by: Marcin | last post by:
Hello all! A few years ago I created a form with button which let me send an email with an attachment. It was created in Access 97. Now I would like to move this application into Access 2003. But when I did it, sending email code doesn`t work. Can you be so kind and give me the code how to send email with and without attachment in vb in...
0
1482
by: Dragos Marian Barbu | last post by:
Recently I tried to develop a function to help me sending e-mail messages with more than one attachment. Everything is working OK when I am sebding messages with one attachment, but when I try to send more than one file as attachment I get the following error: -------- Error ----------------- Could not access 'CDO.Message' object. at...
6
2732
by: Anuradha | last post by:
Dear All How can i send mails using vb.net Thanx all
5
2865
by: J-P-W | last post by:
I have some code, from this group (many thanks) that sends an attachment to an email. The following: Dim objNewMail As Outlook.MailItem Dim golApp As Outlook.Application Dim initializeOutlook As Boolean requires Microsoft Outlook xx Object Library in the references.
3
2998
by: jambonjamasb | last post by:
Hi I have two tables: email_tbl Data_table Data table is is used to create a Form Data_form
3
2392
by: raj200809 | last post by:
when i m sending mail i received error from symantec Antivirus" Your email message was unable to be sent because your mail server rejected the message 550-5.7.1 the ip you’re using to send mail is not authorized" i have configure smtp server put 127.0.0.1 ip in relay and also put 127.0.0.1 ip in connection. using System; using...
0
7873
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7800
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8309
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7902
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6558
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5365
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3830
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2304
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1141
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.