problem with sendobject command button

[Special Access]

I have a simple database that I use for eBay auctions. I built it
under Access 97 and it worked very well. On one form, I have a
command button that runs the sendobject method to create an email
messasge using info from the form. Up until a little while ago, this
worked great.
First question is what has changed... I installed Access 2000 during
a recent rebuild of my computer (last time I installed Office 2000 but
used Access 97). Now the function will only work once. If I have
multiple messages I want to send, I have to completely exit the
database and reopen it for the button to function properly. I have
walked through it and I don't get any error messages... but I don't
get an email message either (not after the first one anyway). In
fact, it steps straight through and never hits the error subs at all.
I even went as far as to make a copy of the database and upgrade it to
Access 2000 format, but that didn't cure the problem.

Here is the command line:
DoCmd.SendObject , , , Me.Email, , , "eBay Auction " & Me.Auction,
stContent

me.email is the email address from the form, and me.auction is the
auction number. stContent is a string built on the fly that contains
the description of the auction and some other simple test.

I have tried it with Outlook 2000 open, and with it closed. Same
same.
Other than uninstalling Access 2000 and installing Access 97 (which I
haven't tried yet), are there any other suggestions? Is there another
way to trigger an email message from within Access? (yea, I'm still
learning VBA)

Thanks!

 

[Rick Brandt]

I have a simple database that I use for eBay auctions. I built it
under Access 97 and it worked very well. On one form, I have a
command button that runs the sendobject method to create an email
messasge using info from the form. Up until a little while ago, this
worked great.
First question is what has changed... I installed Access 2000 during
a recent rebuild of my computer (last time I installed Office 2000 but
used Access 97). Now the function will only work once. If I have
multiple messages I want to send, I have to completely exit the
database and reopen it for the button to function properly.

Out of the box SendObject is essentially "broken and useless" in Access
2000. Some report that Service Pack 3 solved the problems, but I can't
vouch for that myself. Silent failures after the first usage is one of the
common problems reported.

 

[Special Access]

Out of the box SendObject is essentially "broken and useless" in Access
2000. Some report that Service Pack 3 solved the problems, but I can't
vouch for that myself. Silent failures after the first usage is one of the
common problems reported.

Thanks... it figures. Looks like time to regress to Access 97 <g>