Hi all,
I am trying to send an Acess report in the email message body instead of as an attachment. One time, I was able to accomplish that just by using the acFormatHTML as the format. I got a nicely formatted report directly in the body of the message.
Today, when I tried it again, I got a Excel attachment instead of the in-message report with the same SendObject... code. I even tried it manually, Display the report, click File, send to, mail recepient, select HTML. Same result, Excel attachment. If I wanted to attach the report, I would use .snp instead, which worked fine by the way. But I really want to put the report in the message body. Is it possible? I use Lotus Notes Email.
I suppose another option is to build the message body line by line to a text string, but I don't really want to do that unless there is no other way.
Thanks.
2  3936  MMcCarthy 14,534
Recognized Expert Moderator MVP
Hi all,
I am trying to send an Acess report in the email message body instead of as an attachment. One time, I was able to accomplish that just by using the acFormatHTML as the format. I got a nicely formatted report directly in the body of the message.
Today, when I tried it again, I got a Excel attachment instead of the in-message report with the same SendObject... code. I even tried it manually, Display the report, click File, send to, mail recepient, select HTML. Same result, Excel attachment. If I wanted to attach the report, I would use .snp instead, which worked fine by the way. But I really want to put the report in the message body. Is it possible? I use Lotus Notes Email.
I suppose another option is to build the message body line by line to a text string, but I don't really want to do that unless there is no other way.
Thanks.
Check your setting in Lotus Notes. Are your emails set to text format only?
No. I can read other HTML format email without problem.
I just had someone else try it and it worked just fine. I guess it is my Lotus Notes setup.
Thanks
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: alessia |
last post by:
Hi, i'm sorry for my bad english but ..i'm italian..
I have a big problem that I don't succeed in resolving on the command
sendobjet.
I have a query that as resulted a list of addresses e-mail it
furnishes me
with send object I would like to automatically send a mail to all you
address him present in the query.. as I can do??
I use outlook express... and the object and the text of the mail I
have to compile me..
I would like that is...
|
by: Jay Bienvenu |
last post by:
I'm having a very strange problem that currently defies explanation. I
use the code below to send a status report to a client. The intent is
to send the user the report via fax using WinFax and/or email it using
Outlook. The problem is that after executing the DoCmd.OpenReport
command (fax) or DoCmd.SendObject command (email), the code simply
stops running. No error message, no indication that there is a logical
reason for this code to...
|
by: Bret Shortall |
last post by:
Using the SENDOBJECT action command in a Macro works fine if you hard
code in their email address.
SENDOBJECT TO bret@emailaddress.com
SUBJECT This is the Subject line of the email
My problem is that the email address is stored in a field in a table.
In a MACRO, how can I put the field name in the TO value? For
|
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 take the Info in a
html or word document and to use it as the body of the email message.
Is this possible. How can I do this.
Thanks Alfred
|
by: Lauren Quantrell |
last post by:
I am using the following to attach a report, in HTML format to an
e-mail using Access2K:
DoCmd.SendObject acSendReport, "myReportName", acFormatHTML, , , ,
"mySubject", "myTExtBody", True, "myTemplateName"
However, when the e-mail is created, the attachment is named
"Users.HTML"
How can I change it?
| | |
by: Andy Kasotia |
last post by:
Warning message in Outlook 2003 while using SendObject.
When i try to use sendobject to send an email, a warning massage pops
up, saying that "Outlook is trying to send an email.......if this is a
virus, you should choose no."
Can I do away with this message and have it send the email without user
intervention?
I wasn't able to find any optional parameters for the SendObject that
|
by: Fred Zuckerman |
last post by:
Hello All,
I had written a quick email procedure for a client that uses
DoCmd.SendObject. However they have the SR-1 version of Access 2K. They do
not have the SP-3 upgrade. The procedure does not work all of the time (it
seems to fail on long emails). The procedure works fine on my computers that
have the SP-3 upgrade. I read about the SP-3 upgrade and it evidently
repairs some SendObject bugs.
Unfortunately, the client has another...
|
by: Andy_Khosravi |
last post by:
I posted this question about two days ago, but for some reason it never
actually got put up. I couldn't' find it with searches, so I am
re-posting it now. I apologize if this is a double post.
Hello,
I've a bit of a problem with the SendObject command in VBA. On my
computer when I execute the below code, a new memo is generated in
Lotus Notes with an attachment labeled "Benefit Issues Log.rtf".
(Benefit Issues Log is the name of the...
|
by: (PeteCresswell) |
last post by:
Another thread got me going on SendObject.
Works like a champ for emailing somebody a .SNP of a report as
in:
DoCmd.SendObject acSendReport, "rptMaturities", "Snapshot
Format", "pCresswell", , , "Maturities", "Maturities Report
attached...", False
But I do lot of so-called "reports" where I'm actually creating
|
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: 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...
| | |
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: 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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
