SendObject problem

[Anton Greffrath]

I have recently upgraded to Windows XP profesional (from
and Windows XP release upgraded from Windows 98) I develop
applications using Access 2000.
Before the upgrade, I could send emails from my
applications to external users without any problem. After
the upgrade to Windows XP profesional, ALL Sendobject
commands are ONLY EXECUTED THE FIRST TIME THE ACCESS 2000
App is run. From then on the command is seen during
execution (I cheked this by stepping through the code) but
nothing is sent. It seems as the system "skips" over the
SENDOBJECT commands. This is of course causing great
problems with my users and for the life of me, I cannot
get a solution anywhere. Is there someone out there that
can assist? PLease respond to my Email address above.

Kind regards

Anton Greffrath

 

[Sandra Daigle]

Have a look at the following Knowledge Base article:

ACC2000: SendObject Method Fails in Access 2000 (Q260819)
http://support.microsoft.com/?id=260819

This might explain what is happening - there's a followup article that will
give you an alternative method for sending emails using Outlook automation.

Q161088 Using Automation to Send a Microsoft Outlook Message
http://support.microsoft.com/?id=161088

HOW TO: Use Automation to Send a Microsoft Outlook Message using Access 2000
http://support.microsoft.com/?id=209948

ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple Recipients
http://support.microsoft.com/?id=318881

Outlook for the Summer - (Programming Microsoft Outlook Objects)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office071299.asp

For more ideas take a look at this site:

Tony Toew's Email FAQ
http://www.granite.ab.ca/access/email.htm