473,320 Members | 1,848 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,320 software developers and data experts.

how to send two reports in one email via DoCmd.SendObject acSendReport,

RobH
56
i currently send a report to a reciepient using the Docmd.Sendobject acSendReport which works really well - now my customer wants two reports sent in the same email..

Any thoughts???
Feb 14 '08 #1
1 3835
i currently send a report to a reciepient using the Docmd.Sendobject acSendReport which works really well - now my customer wants two reports sent in the same email..

Any thoughts???
You could use:

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OutputTo acOutputReport, "ReportName", acFormatRTF, "C:\ReportName.rtf"
twice to output your two reports and then use a function to access your email client, attach the two files and send.

I use this very successfully at the moment to send multiple reports via Lotus Notes and can give you the function I use to do this. I'm afraid if it's not Notes I can't really help with this bit, but the theory's the same!

Just a thought.
Feb 14 '08 #2

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

Similar topics

1
by: Alfred | last post by:
Hi I am using access 2002 1.0 I want to email a word or html file using the docmd.sendobject The document must be send as a attachment. 2.0 Second I would like to tell the Docmd.Sendobject to...
3
by: Lauren Quantrell | last post by:
I get the prompt from Outlook Express when trying to send an e-mail using DoCmd.SendObject in MS Access2000: "A program is attempting to send the following e-mail message on your behalf:" To:...
5
by: Tom Louchbaum | last post by:
When I preview my Access 2000 Report it looks fine. When I Email the report using DoCmd.SendObject acSendReport, "Report", acFormatRTF, "To Address", , , "Subject", , False the resulting...
1
by: Lauren Quantrell | last post by:
This works in my Access2000 MDB but not in the MDE created from the same file (on the same workstation): DoCmd.SendObject acSendReport, "myReportName", acFormatRTF, "someone@somewhere.com", , ,...
1
by: jerry.ranch | last post by:
I collect information from my clients with an xls file I import the xls data into my access table. I don't have them put info directly into Access, because, despite the drop downs I have for...
2
by: John Taylor | last post by:
I have created a command button on a form that prints a filtered report and e-mails the report to three people when "clicked". The three email addresses are selected on the form by three combo...
1
by: bgreer5050 | last post by:
I am using Access 2000 and need a little help writing the code the proper way to do the following: I have a form with the following fields: "Requestor" and "RequestorEmailAddress" I have a...
1
by: Filips Benoit | last post by:
Dear All, DoCmd.SendObject acSendReport, "RPT_ITEM", acFormatTXT, Me.CNT_EMAIL, , , "testEmail", "test", False The report is converted to RPT_ITEM.txt before sending as attachment. Is the...
5
by: neosam | last post by:
Hey all, I am not able to integrate these 2 actions in one command. What i am doing is... A button which sends a report with only specific data to a particular person (via outlook). I am able to...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.