Hello to all,
i have a new interesting problem to solve....
i have a report that i would like to email to a list of users,
the report is a full page document and is personalised to each user (basically) more than one user can have the same email address so i will create a recordset to list all of the users (who need the email) and loop through the users and send to the associated email address, i have a few problems
1)currently the report is set up to list all the reports in the same report.... make sense? so i would need to send only the correct page... is that possible? if not then i will have to alter the reprt to build using the info from my aforementioned loop.
2)the biggest obsticle is that i want the report (sent as html) to be the body of the email, i have tried this: -
DoCmd.SendObject acSendReport, "report1", acFormatHTML, EmailAddress, , , "Subject:____", "report1"
-
this opens the email to be edited (which i dont want to do) but the report does send as the body this way
so i tried this (to NOT edit) -
DoCmd.SendObject acSendReport, "report1", acFormatHTML, EmailAddress, , , "Subject:____", "report1", false
-
which does send the email straight away... but sends the report as an attachment... any ideas?
thanks for ya help guys
Dan Out
10  9974 
good luck getting the result you want natively from Access. I send data from Access via email all the time for various purposes but have never been able to do it "the way I want" using Access by itself. More recently I have been building an HTML version of the report in code, then sending that as the body of an email using either the Redemption Outlook DLL or a DLL I wrote in VB.NET.
If you like I will put together some sample VB.NET source code for you...
That would be useful if you could, but it would need some explaining as to how i would implement it (and alter it) and i have no experience with VB.net
if you could help then that is great, if not then can i assume that i will just have to accept the report being sent as an attachment?
Sending it the way you mention in your first post is the easiest by far. If you have no experience with .Net you are going to be in for more than you expected...
That would be useful if you could, but it would need some explaining as to how i would implement it (and alter it) and i have no experience with VB.net
if you could help then that is great, if not then can i assume that i will just have to accept the report being sent as an attachment?
I will work on some sample code for you and get back to you
I have just created a page detailing how to create an SMTP DLL which allows you to specify the entire body of the email as SMTP. In order to fully implement your report as the body you will need to do further research into compiling your data into an HTML page.
The SMTP DLL code is at ** Edit - Removed link to external code **
I hope this helps you out to some small degree...
NeoPa 32,577
Recognized Expert Moderator MVP
Max,
You are welcome to include your code in a post, but linking offsite to code is not allowed.
Admin.
 Denburt 1,356
Recognized Expert Top Contributor
I almost always use CDO for sending email as you stated I like to send my reports via the email body verses an attachment. Using CDO you may find you have to mess around with the configuration a bit to get it to work but it works and quite nicely I might add. Here is a link to a post with some sample code that may help. http://forums.microsoft.com/MSDN/Sho...23601&SiteID=1
To use this you will need to add a reference (in the VBA window under tools/references)
I generally export to HTML like so then read the info and into the email it goes. - strPath = Application.CurrentProject.Path
-
DoCmd.OutputTo acOutputReport, "Rate Division", acFormatHTML, strPath & "\RD.HTML", False
-
Set fso = CreateObject("Scripting.FileSystemObject")
-
Set ts = fso.OpenTextFile(Application.CurrentProject.Path & "\RD.HTML", ForReading, False) '.CreateTextFile(vFile)
-
'Exit Function
-
tsR = ts.ReadAll
-
ts.Close
-
Set ts = Nothing
-
-
-
.HTMLBody = tsR
-
Sometimes exporting a report to HTML can be quite nasty so in those circumstances I XML with an XSL style sheet to produce my desired results then transfer that into the email (again opening it as text then .readall etc.).
Good luck any questions feel free to ask.
Denburt 1,356
Recognized Expert Top Contributor
I posted then I saw your post Neo. I know Microsoft informational pages are O.K. but what about the Microsoft forum? The topic is inline and I thought the thread was informative as well. Please edit my post as you see fit. Thanks
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Shiperton Henethe |
last post by:
Hi
Anyone know how to do a MAILTO: such that
the "BODY=" parameter contains carriage returns ?
e.g.
<A HREF="mailto:brochure@webwindows.co.uk?subject=Brochure
Request&body=Line1 blah blah Line2 blah blah blah Line3 blah ">
|
by: John Dalberg |
last post by:
Hi
I have a form that opens a new window for the results. Because the results
might take a few seconds due to server processing, I would like to display
a message "please wait" in the new window, erase that message when the
processing is done and show the results.
How is this done?
John Dalberg
|
by: Viken Karaguesian |
last post by:
Hello all,
I have a question. I trying to run two Javascripts on my webpage, both
of which need a <body onload> command. They are as follows:
<body onload="runMe()">
<body onload="SwapImgs()">
What would be the proper format to include these on the same line?
would it be:
|
by: chuckdfoster |
last post by:
I am getting a "Could Not Access CDO.Message Object" Error when I try to use
the following code to send an email via ASP.NET. When I run this on one
machine it works, on another one it doesn't. Both have VS.NET installed and
both have MS Outlook installed. What do I need done to the machine that
doesn't work? Or is something wrong with the code?
Dim email as New System.Web.Mail.Message
email.To = "me@me.com"
email.Subject = "Test...
|
by: Chad Dittmer |
last post by:
I'd appreciate anyone's help with this. I'm trying to open an email
window and have it auto fill from vb.net. It works, except I can't
get line breaks in the body. I've tried:
vbLf
vbCrLf
Environment.NewLine
sendkeys
<br>
and multiple "&body="
Nothing happens with the above.
| | |
by: John Draper |
last post by:
In "smtplib" module, the "sendmail" method of function is to be passed a
host, but it is the Domain name
for the SMTP Server as gotten from the "dig" command? IE: dig -tMX
would give me the SMTP
server. In my code I have:
try:
print "Sending message to host: %s" % mailHost
server=smtplib.SMTP(mailHost)
server.sendmail(reply_email,email,body)
|
by: abilashnn |
last post by:
'm attempting to send a mailto: and include a link in the body. Has anyone done this?
I have one problem with this.
One appln have a link to send an email using “mailto:”.
Previosly this funtionality was using with outlook as default email client, recently clients migrated to Lotus Notes and it is not working.
Body part of mail message will get appended to the subject portion.
The problem is with one link in the email body is having ?...
|
by: Mark |
last post by:
Using VB.net 2005, I am trying to send an email with attachments in Outlook.
I have tried using this article from Microsoft,
(http://support.microsoft.com/?kbid=313803), but I can't even get the dim
statements to work. It says it needs to be declared and I have used the
reference 0utlook 11.0. Also, I used Imports
Microsoft.Office.Interop.Outlook. Any ideas?
|
by: GArlington |
last post by:
"G. Morgan" <no_em@il.invalidwrote in message
news:8787770faf30b1bd48f393baa1a89fdbnp@mypost.invalid...
<snap>
<snap>
Did you try <cr><lf combination?
** Posted from http://www.teranews.com **
|
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...
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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...
|
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,...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
