Need help ASAP with SendObject error when emailing report

D

Debbie H

I have an Access 2002 database which is accessed by multiple users at
different locations. The SendObject command, (DoCmd.SendObject acSendReport,
stDocName, acFormatSNP, stToName & ", ", "John Doe" & ", ", , stMailTxt, ,
False), is used to email a Snapshot format of reports via Lotus Notes. It has
worked fine for the last two years with users running Access 2002 version
(10.6501.6817 SP3) and Lotus Notes version 6.5.2. Recently, some users at a
remote location have received new pcs which upgraded them to a newer version
of Microsoft Office (Access 2002 version 10.6771.6830 SP3) and Lotus Notes
version 6.5.5. Now, they are all getting the error, "The command or action
'SendObject' isn't available now.", when they hit the button to automatically
email reports from Microsoft Access. The only information I have found says
that it is because Microsoft Outlook is the only email software recognized by
the newer version of Microsoft Office and that Registry changes must be made
for it to communicate properly with other vendors’ email software (Lotus
Notes). I did have one of the affected users try the suggested “fixâ€, but he
is still receiving the same error message. This database is critical to our
daily operations and I would GREATLY APPRECIATE your expertise in helping me
find a solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top