SendObject

[Secret Squirrel]

Can anyone tell me if they know of any problems using the "SendObject" code
with Outlook? I have a db set up where emails get automatically sent out when
some controls on my form are triggered with certain values. It works
sometimes but sometimes it doesn't. I've tested it and when I close the db
and reopen it then it works once but then I have to close and open the db
again to get it to work again. Any idea what might be causing this? I've also
tested this out on my home pc and it works fine all the time. I'm using the
same version of Access & Outlook. Can anyone shed some light on this for me?

 

[Rick Brandt]

Can anyone tell me if they know of any problems using the
"SendObject" code with Outlook? I have a db set up where emails get
automatically sent out when some controls on my form are triggered
with certain values. It works sometimes but sometimes it doesn't.
I've tested it and when I close the db and reopen it then it works
once but then I have to close and open the db again to get it to work
again. Any idea what might be causing this? I've also tested this out
on my home pc and it works fine all the time. I'm using the same
version of Access & Outlook. Can anyone shed some light on this for
me?

And those versions are? Access 2000 had serious problems with SendObject when
first released. Whether they were later corrected or not I am not sure. You
should be able to find articles discussing them on Microsoft's web site.

At least one of the problems was "silent failures" after a few succussful uses.

 

[Secret Squirrel]

They are both 2000 versions. I believe these are silent failures because I do
not get any error messages. I do think it is working fine on a few of my pc's
at the office. But some it doesn't work on. Can you shed some more light on
this and maybe a possible fix?

 

[Rick Brandt]

They are both 2000 versions. I believe these are silent failures
because I do not get any error messages. I do think it is working
fine on a few of my pc's at the office. But some it doesn't work on.
Can you shed some more light on this and maybe a possible fix?

IF the problems were fixed then the fix is in one or more of the serivce packs
and updates for Office 2000. I would start by applying ALL of them as that is a
good idea anyway.

I haven't used SendObject for years as I always automate Outlook or CDO (which
was MY fix for the problem).

 

[Secret Squirrel]

All the pc's have the same version of office on them. Why would some work and
some not? You mentioned that you automate outlook or use CDO. Would this be
easier for me than using the sendobject?

 

[Rick Brandt]

All the pc's have the same version of office on them. Why would some
work and some not?

Do they all have the same updates and patches appplied?

You mentioned that you automate outlook or use
CDO. Would this be easier for me than using the sendobject?

Easier? Probably not, but they provide more capabilities like multiple
attachments and attachments of external files (not just Access objects). They
can create HTML mail which is handy in some cases and you have more control over
the FROM and SendorProfile properties.

 

[Secret Squirrel]

Yes they all have the same updates and patches. We are all working with SP1.

All I do with email is send automatic emails when certain controls are
triggered or filled with a value or when new records are created. How hard
would it be to set this up using CDO?

 

[Tony Toews]

And those versions are? Access 2000 had serious problems with SendObject when
first released. Whether they were later corrected or not I am not sure. You
should be able to find articles discussing them on Microsoft's web site.

Yes, it was fixed but I'm not at all sure what SP.
http://support.microsoft.com/?kbid=260819

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

 

[Tony Toews]

Yes they all have the same updates and patches. We are all working with SP1.

SP1 is a bit old. SP3 is out back in Dec 2002
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q266134

Now did SP1 have the SendObject fix I can't recall.

All I do with email is send automatic emails when certain controls are
triggered or filled with a value or when new records are created. How hard
would it be to set this up using CDO?

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

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

 

[Guest]

Now did SP1 have the SendObject fix I can't recall.

No, I used that version for years, and it was not fixed.
until after XP was released.

I think XP SR2/3, 2000 SR3.

It appears to me that Access bug fixes got bundled
into the Office 2000 security update (SR3) because
it was easier than branching the code.

(david)