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!

Nov 12 '05 #1

Subscribe Reply

16580

Rick Brandt

"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

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

Nov 12 '05 #3

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!

Nov 12 '05 #4

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!

Nov 12 '05 #5

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

Nov 12 '05 #6

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

Nov 12 '05 #7

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

Similar topics

5376

Sending file via email.

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 attachment? Thanks a lot in advance.

Microsoft Access / VBA

5518

Access 97: Sending Report as Email Body not Attachment

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. attachment is in order to make the message easier to view for the reader/receipent.

Microsoft Access / VBA

2587

Report - Output to Snapshot ... then Email as Attachment using Outlook Express !

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 want to place a button which emails the above generated report using

Microsoft Access / VBA

3550

Sending email with atachments in Access 2003 (vb)

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 Access 2003?? Thank you in advance

Microsoft Access / VBA

1482

Sending more than one attachment

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 System.Web.Mail.LateBoundAccessHelper.CallMethod(Object obj, String methodName, Object args) at...

ASP.NET

2736

Sending Mails

by: Anuradha | last post by:

Dear All How can i send mails using vb.net Thanx all

Visual Basic .NET

2866

Sending Email Attachment, wrong Outlook Version

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.

Microsoft Access / VBA

3002

HELP QUERY to return email add in REPORT when combo box is selected in a FORM

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

Microsoft Access / VBA

2393

Error sending mail in .net

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 System.Collections; using System.ComponentModel; using System.Data; using System.Drawing;

.NET Framework

8272

What is ONU?

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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8713

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8644

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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 captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8370

The easy way to turn off automatic updates for Windows 10/11

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 most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

6126

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5579

Couldn’t get equations in html when convert word .docx file to html file in C#.

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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4094

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4208

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2632

transfer the data from one system to another through ip address

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

C# / C Sharp