Access 2002 and SendObject

[Merlin]

Anybody know anything about why Access 2002 will only
allow you to use the SendObject action once during a
session? You have to close and reopeb Access in order to
send another email. Is this a bug? Is there a fix?

Thanks
Merlin

 

[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

For more ideas take a look at this site:

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

 

[david epsom dot com dot au]

send another email. Is this a bug? Is there a fix?

Only listed as fixed in A2K at November 2002, so I would
be checking Office XP service pack 1 and 2.

(david)