By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,460 Members | 2,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,460 IT Pros & Developers. It's quick & easy.

Can SendObject be used to send more than a single attachment?

P: n/a
MLH
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?
Nov 12 '05 #1
Share this Question
Share on Google+
13 Replies


P: n/a
"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
Nov 12 '05 #2

P: n/a
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
Nov 12 '05 #3

P: n/a
MLH
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


Nov 12 '05 #4

P: n/a
"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.
Nov 12 '05 #5

P: n/a
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)
Nov 12 '05 #6

P: n/a
MLH
How about just 1 report?
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Nov 12 '05 #7

P: n/a
MLH
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.


Nov 12 '05 #8

P: n/a
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
Nov 12 '05 #9

P: n/a
MLH
One more thing... the results I get are the same
whether I run SendObject from Access 97 or
Access 2.0.
Nov 12 '05 #10

P: n/a
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)
Nov 12 '05 #11

P: n/a
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)
Nov 12 '05 #12

P: n/a
MLH
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?
Nov 12 '05 #13

P: n/a
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.
Nov 12 '05 #14

This discussion thread is closed

Replies have been disabled for this discussion.