I want to send 2 reports using SendObject.
Something like this would do nicely...
DoCmd SendObject A_REPORT, "rpt1";"rpt2", A_FORMATRTF, MyRecip, , ,
MySubject, MyBodyText, 0
....except for the fact that this syntax won't compile.
Suggestions? 13 7509
"MLH" <CR**@NorthState.net> wrote in message
news:02********************************@4ax.com... I want to send 2 reports using SendObject. Something like this would do nicely...
DoCmd SendObject A_REPORT, "rpt1";"rpt2", A_FORMATRTF, MyRecip, , , MySubject, MyBodyText, 0
...except for the fact that this syntax won't compile.
Suggestions?
You can't use SendObject to do this. You need to use automation of another mail
program. I use Outlook and CDO libraries for this stuff. There is example code at
the link below. http://www.mvps.org/access/modules/mdl0019.htm
MLH <CR**@NorthState.net> wrote: I want to send 2 reports using SendObject.
Can't do it. See the Access Email FAQ at my website for alternatives.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Thx. Is there a way I can adapt this technique to Access Basic in
Access 2.0?
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxx
On Tue, 16 Sep 2003 10:41:06 -0500, "Rick Brandt" <RB*****@Hunter.Com>
wrote: http://www.mvps.org/access/modules/mdl0019.htm
"MLH" <CR**@NorthState.net> wrote in message
news:8g********************************@4ax.com... Thx. Is there a way I can adapt this technique to Access Basic in Access 2.0?
Sorry, I have no idea.
On Tue, 16 Sep 2003 13:19:32 -0400 in comp.databases.ms-access, MLH
<CR**@NorthState.net> wrote: Thx. Is there a way I can adapt this technique to Access Basic in Access 2.0? xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxx
Sorry but you're stuck in a time warp, the methods available to you in
Access 2.0 are limited to the methods available when Access 2.0 was
the current version, unless you have a 16 bit mail program to interact
with then you're scuppered.
Are you running Access 2.0 on Windows 3.x or in a 32 bit OS? If the
latter then you might consider wirting a little 32 bit VB app that you
can shell out to from Access 2.0 that will interact with all the 32
bit DLLs now in use.
--
A)bort, R)etry, I)nfluence with large hammer.
(replace sithlord with trevor for email)
How about just 1 report?
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I seem to remember people successfully sending email
using SendObject in the old Access 2.0 days. I'm able
to do it. I just can't seem to get Access 2.0 to properly
format a WordPad document as an RTF that shows up
when the mail arrives and the attachment is opened.
Its zero problem from WordPad itself. Clicking File, Send
there creates the proper attachment and the attachment
to the email is reliably opened and is readable. Maybe I
don't know the secret.
What products would I need to purchase in order to do
what you've suggested?
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxx
On Tue, 16 Sep 2003 19:51:50 +0100, Trevor Best <bouncer@localhost>
wrote: On Tue, 16 Sep 2003 13:19:32 -0400 in comp.databases.ms-access, MLH <CR**@NorthState.net> wrote:
Thx. Is there a way I can adapt this technique to Access Basic in Access 2.0? xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxx
Sorry but you're stuck in a time warp, the methods available to you in Access 2.0 are limited to the methods available when Access 2.0 was the current version, unless you have a 16 bit mail program to interact with then you're scuppered.
Are you running Access 2.0 on Windows 3.x or in a 32 bit OS? If the latter then you might consider wirting a little 32 bit VB app that you can shell out to from Access 2.0 that will interact with all the 32 bit DLLs now in use.
MLH <CR**@NorthState.net> wrote: I want to send 2 reports using SendObject.
Can't do it. See the Access Email FAQ at my website for alternatives.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
One more thing... the results I get are the same
whether I run SendObject from Access 97 or
Access 2.0.
On Tue, 16 Sep 2003 16:48:24 -0400 in comp.databases.ms-access, MLH
<CR**@NorthState.net> wrote: I seem to remember people successfully sending email using SendObject in the old Access 2.0 days. I'm able to do it. I just can't seem to get Access 2.0 to properly format a WordPad document as an RTF that shows up when the mail arrives and the attachment is opened.
Reports to RTF was never a strong point in Access 2.0 (or any version
since really), you never get what you see in the report, most
noticably lines will disappear.
Its zero problem from WordPad itself. Clicking File, Send there creates the proper attachment and the attachment to the email is reliably opened and is readable. Maybe I don't know the secret.
What products would I need to purchase in order to do what you've suggested?
VB6.
--
A)bort, R)etry, I)nfluence with large hammer.
(replace sithlord with trevor for email)
On Tue, 16 Sep 2003 16:52:20 -0400 in comp.databases.ms-access, MLH
<CR**@NorthState.net> wrote: One more thing... the results I get are the same whether I run SendObject from Access 97 or Access 2.0.
I think my bracketed comment in my last post answers that one <g>
--
A)bort, R)etry, I)nfluence with large hammer.
(replace sithlord with trevor for email)
On Tue, 16 Sep 2003 23:46:23 +0100, Trevor Best <bouncer@localhost>
wrote: On Tue, 16 Sep 2003 16:48:24 -0400 in comp.databases.ms-access, MLH <CR**@NorthState.net> wrote:
I seem to remember people successfully sending email using SendObject in the old Access 2.0 days. I'm able to do it. I just can't seem to get Access 2.0 to properly format a WordPad document as an RTF that shows up when the mail arrives and the attachment is opened. Reports to RTF was never a strong point in Access 2.0 (or any version since really), you never get what you see in the report, most noticably lines will disappear.
Hey, tell me about it! I get nothing but a hard return on ALL
the lines. Its zero problem from WordPad itself. Clicking File, Send there creates the proper attachment and the attachment to the email is reliably opened and is readable. Maybe I don't know the secret.
What products would I need to purchase in order to do what you've suggested?
VB6.
Here's what I found on MS site. searching for "VB6"...
Downloads for Visual Basic (MSDN)
Code samples and downloads for Visual Basic .NET and previous versions
of Visual Basic. http://msdn.microsoft.com/vbasic/downloads/
Visual Basic 6.0 Service Pack 5: Run-Time Redistribution Pack
vbrun60sp5.exe is a self-extracting executable file that installs
versions of the Microsoft Visual Basic run-time files required by all
applications created with Visual Basic 6.0. The files include the
fixes shipped with Visual Studio 6.0 Service Pack 5. http://www.microsoft.com/downloads/r...eleaseid=28337
Download VBRun60sp5.exe to Install Visual Basic 6.0 SP5 Run-Time Files
VBRun60sp5.exe installs the latest versions of the Microsoft Visual
Basic run-time files required by all applications created with Visual
Basic 6.0. The files include the fixes shipped with Visual Studio 6.0
Service Pack 5. http://support.microsoft.com/support.../Q290/8/87.ASP
Should I order Visual Basic 6.0 - or - Visual Studio 6.0??? And, one
other thing... are Visual Basic 6.0 and VBA one and the same?
On Wed, 17 Sep 2003 10:49:59 -0400 in comp.databases.ms-access, MLH
<CR**@NorthState.net> wrote: Should I order Visual Basic 6.0 - or - Visual Studio 6.0??? And, one other thing... are Visual Basic 6.0 and VBA one and the same?
In order to write a 32 bit program to shell out to, you will need to
order Visual Basic 6.0 or similar as there's many languages on the
market. Visual Studio 6.0 contains VB6 and more (Interdev, C++, J++,
etc).
As for the other thing, no, VBA is the language used behind the scenes
in Access, Excel, Word, etc, VB6 is an actual product, using the same
language but it creates stand alone[1] executable files.
[1] In the sense that nearly all windows programs require a DLL or two
to run, it's not "stand alone" in the true sense.
--
A)bort, R)etry, I)nfluence with large hammer. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: jmr |
last post by:
Hi
- I made a macro to send a report as an attachment to an e-mail in Access
97
- I got the macro to work on WinMe with Netscape as long as the To: field
was not filled in.
- I just...
|
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...
|
by: D.Tulenson |
last post by:
The following module, which works just fine, is designed to mass
e-mail info to individual projects but the attachment is always
"rptexpendituredetail.xls".
Is there any way to change the...
|
by: Wayne Aprato |
last post by:
Can anyone please help me with the following madness in Access 2003
(2000 file format). I am using 2 similar funtions, the first which
works fine to save reports as snapshots:
On Error Resume...
|
by: John Taylor |
last post by:
I have finally got "SendObject" to work but now have a filter problem.
I have a database set up that I generate orders and print them as a single
page report. I've set up a filter so that when I...
| |
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...
|
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...
|
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...
|
by: tngster |
last post by:
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...
|
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...
|
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...
| |
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...
|
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,...
|
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: 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...
|
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.
| |
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...
| |