Multiple attachments with docmd.sendobject

[Russ]

Hi all

I have a simple problem I'm using the docmd.sendobject to send a report as an rtf file attachment to email addresses ... It send the email fine ... But some times it will send Muliple attachments ie 3 rtf's that had quite different data on them.. This is not good.

Does anyone know why ... It;s access 2000 on winxp pr

Thanks in advance Russ

 

[Bruce M. Thompson]

I have a simple problem I'm using the docmd.sendobject to
send a report as an rtf file attachment to email addresses ... It send the
email fine ... But some times it will send Muliple attachments ie 3 rtf's that
had quite different data on them.. This is not good.

Does anyone know why ... It;s access 2000 on winxp pro

In order to attach multiple documents to an email message using VBA, you will
need to implement some form of automation - the SendObject method only supports
a single filename being passed as an argument. Depending on what email software
is being used, you might be able to use Outlook automation or, if the email
client software is not Outlook or may vary from workstation to workstation, you
may need to use MAPI which is a little more complicated.

See the following page at Tony Toews' web site for some information and links
that might get you started:

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

 

[Russ]

Hi Bruce

Thanks for the reply.. My problem is that 'I am' getting multiple attachments being sent from time to time with different data on them...

What I want is sendobject to only send the one attachment as it should do

As you can imagine it doing my nut. because it should not screw up like this.

Any ideas why it is doing it

Thanks in advance Russ

 

[tambrocio]

I do not know the answer to your problem, but I am in dire straits about a small problem with Access 97

One of the things I am trying to do is to create an e-mail after certain actions have been done
I need to talk with someone about this. Would you be able to help me

 

[Bruce M. Thompson]

Thanks for the reply.. My problem is that 'I am' getting
multiple attachments being sent from time to time with different data on them...

What I want is sendobject to only send the one attachment as it should do.

As you can imagine it doing my nut. because it should not screw up like this.


Any ideas why it is doing it?

Are you saying that you are getting multiple documents being attached to the
same email message or that some of the messages have a document attached with
different information in it when they should all be the same? With SendObject, I
can only imagine the latter being the case. You must keep in mind that the same
report must be "run" each time you use the SendObject method, so if the data or
any criteria affecting the contents of the report changes during the course of
generating your mailing, the data in the report is apt to change also.

 

[konveyance]

Russ wrote on 02/06/2004 10:36 ET

Hi al

I have a simple problem I'm using the docmd.sendobject to send a report as a
rtf file attachment to email addresses ... It send the email fine ... Bu som
times it will send Muliple attachments ie 3 rtf's that had quite differen dat
on them.. This is not good

Does anyone know why ... It;s access 2000 on winxp p

Thanks in advance Rus

He is obviously saying that he has ONE sendObject command in the macro
and ONE attachment is expected. but MS-ACCESS is attaching multiple version o
the query with varying results in them. and there are no criteria changes

We are getting the same issue happening where I work
It started yesterday. There were no changes to the beforehand
Well, automatic updates is turned on. so obviously this is Microsoft messin
up
I have ONE SendObject command. One Macro and am expecting ONE attachment
That's not what I get... and it varies... some macros setup like that get tw
attachments, some get more. I expect more than just a run around answer lik
that VP gave.