473,398 Members | 2,404 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,398 software developers and data experts.

How to attach documents using SendObject function

I have a database that I would like to print out 2 seperate documents, which I have done and I also want to e-mail the same 2 documents. I am using the SendObject function, but I can't seem to get the 2 documents to attach, is this even possible? If so, what am I missing?

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenReport "rptCommunication"
  2.     DoCmd.OpenReport "rptCommunicationCoverSheet"
  3.     DoCmd.SendObject acSendReport, "rptCommunicationCoverSheet" also "rptCommunication", "Rich Text Format", , , , "IDP - Communication for the month of" + " " + [Month]
  4.     DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
  5.     DoCmd.GoToRecord , , acNewRec
  6.     DoCmd.Close
Thank you again
May 27 '10 #1

✓ answered by patjones

You might be interested in this thread which I recently participated in, and which I believe speaks directly to your issue: How to send email with a report as an attachment

Pat

2 1676
ChipR
1,287 Expert 1GB
SendObject appears to be limited to one file at a time. You'll have to call it twice.
May 28 '10 #2
patjones
931 Expert 512MB
You might be interested in this thread which I recently participated in, and which I believe speaks directly to your issue: How to send email with a report as an attachment

Pat
May 28 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: connie | last post by:
I have an E-mail ASP Web form that is using a CDO Mail Object. This form has to be filled out before the customer can download our demo. Currently, the customer fills out the form, clicks to...
2
by: brazilnut | last post by:
Hi. Let me explain the setup. I am using Visual Studio .NET to develop a sort of add-in (COM class) for Excel called SQLAddin. It basically queries a SQL server and pulls in data. Now within my...
2
by: Stephen | last post by:
I am trying to compare the tables in two similar environments using the SQLDMO object. I am able to use this object to access different SQL servers and choose two different databases. The versions...
2
by: Joe | last post by:
Dear All, Can anyone help me with these two questions? Thank you. I am using MSXML 4.0 SP2 and VC++ .NET.
2
by: Steve Bishop | last post by:
I have an application that sends a query by e-mail in Excel format using a DoCmd.SendObject statement in VBA. I need to delete the column headings now before I send it. Help appreciated. Thanks....
4
by: Ranganath Udupa | last post by:
I need to include a mail to a concerned person whenever a button is clicked in an Access form. So I used the DoCmd.SendObject command. However, it seems like I cannot send a long message text. Is...
2
by: jt | last post by:
I have a com object that I don't know how to expose its methods and insert it events. I've been using this activex control in VB6 and now learning VB.NET. I've added the activex control to my...
0
by: BG | last post by:
Can anyone explain how to create a macro to send a report to a person/group by using the input values entered in a report query? I generate a report by inputting date and ID # and each report...
2
by: boloi | last post by:
Now, I want to write script PHP for send mail:"after 30 seconds send 10 email".Help me? :) :)
2
by: Benny | last post by:
I have a distributed application that everyone will be running the same core application, but some may have a different interface they use because of different roles. I need to send a complex (yet...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...
0
Oralloy
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,...
0
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...
0
tracyyun
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...
0
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,...
0
isladogs
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...

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.