How can I attach two reports to the same Email?

Barry Edmund Wright

Hi,
I have two reports that I want to attach to the same email:
rptBugReport
rptBugLog

I can sent the one using:
DoCmd.SendObject acOutputReport, "rptBugReport", acFormatSNP

How can I add the second?
I've tried:
DoCmd.SendObject acOutputReport, "rptBugReport" & "rptBugLog", acFormatSNP
Thanks
Barry

Nov 13 '05 #1

Subscribe Post Reply

2021

Rick Brandt

Barry Edmund Wright wrote:

Hi,
I have two reports that I want to attach to the same email:
rptBugReport
rptBugLog

I can sent the one using:
DoCmd.SendObject acOutputReport, "rptBugReport", acFormatSNP

How can I add the second?
I've tried:
DoCmd.SendObject acOutputReport, "rptBugReport" & "rptBugLog",
acFormatSNP
Thanks
Barry

You cannot do this with SendObject unless you embed both reports as
subreports inside of a single "container" report.

You could use automation of a messaging library like CDO or Outlook and then
have as many attachments as you want. Example code found at link below.

http://www.mvps.org/access/modules/mdl0019.htm

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #2

Barry Edmund Wright

Thanks Rick, I'll put both reports as subrpt into a rpt as you suggest.

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:GX****************@newssvr12.news.prodigy.com ...

Barry Edmund Wright wrote:
Hi,
I have two reports that I want to attach to the same email:
rptBugReport
rptBugLog

I can sent the one using:
DoCmd.SendObject acOutputReport, "rptBugReport", acFormatSNP

How can I add the second?
I've tried:
DoCmd.SendObject acOutputReport, "rptBugReport" & "rptBugLog",
acFormatSNP
Thanks
Barry

You cannot do this with SendObject unless you embed both reports as
subreports inside of a single "container" report.

You could use automation of a messaging library like CDO or Outlook and
then
have as many attachments as you want. Example code found at link below.

http://www.mvps.org/access/modules/mdl0019.htm

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #3

by: tabonni | last post by:

Hi I try to grab the checked files from HTML page and then send those PDF files as attachments. It can just send email, there are no PDF files attached. Can anybody point out my error? My...

ASP / Active Server Pages

Unable to attach file

by: bmcelhany | last post by:

I have a windows service that monitors a directory for newly created files. When one is found, an e-mail is generated and the new file is added as an attachment. In order to avoid trying to attach...

.NET Framework

Problem sending Report as EMail - wrong attach. name "untitled.txt"

by: Matthias Haberkorn | last post by:

Hello, I haved used VS2003 and send some Reports as EMail attachmend with vb.net. The code looks like this: Dim pdfOpts As PdfRtfWordFormatOptions = _...

Visual Basic .NET

Best way to construct an email - attach a html file and send

by: a | last post by:

What is the best way to construct an email in python and also attach a html file the html file to be attached is not on disk, but should be dynamically constructed in the python script I want...

Python

MS Access Reports and VB.NET Program

by: JoeW | last post by:

I'm utilizing a database that I created within MS Access within a program I've created in VB.NET. I am using the VB front end to navigate the information, but want to be able to print a report,...

Visual Basic .NET

How to attach 2 reports to e-mail

by: Chilly1600 | last post by:

Hi. Can anybody help with this small problem. I'm currently using Access 2003 and from within the database i need to e-mail 2 x different reports on the same e-mail. I've managed to do...

Microsoft Access / VBA

Generate and Attach a file to email.

by: sreemathy2000 | last post by:

My requirement is to generate and attach a file and send in an email automatically. i have a existing functionality where i using the code below to write a CSV file in my local system. ...

.NET Framework

Copy 2000 database to 2005 - cannot detach/attach

by: dpatel75 | last post by:

I am trying to copy a database from a SQL 2000 SP3 Windows 2000 server to a 2005 SP2 Windows 2003 server. I am trying to use detach and attach method (have tried both within Management Studio and...

Microsoft SQL Server

Attach to Process

by: GaryDean | last post by:

I see some references on debugging by attaching to a process. There are MSDN articles that show how to attach to a process for debugging. However, I can find no info on how exactly to get the...

ASP.NET

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

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,...

General

Changing the language in Windows 10

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...

Windows Server

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...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

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,...

Career Advice

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...

Microsoft Access / VBA

How can I attach two reports to the same Email?

Similar topics