DoCmd.SendObject fails when IIS Admin Tools is installed.

Question

I have an application that is written in VBA inside of Microsoft Access 2003. We have a form that allows the users to send an automated email message to the development team that uses the following code:

DoCmd.SendObject acSendNoObject, , , _
    "[email protected]", "", "", _
    "Helpdesk Submission", msg, False, ""

This code was working perfectly for all of our users until we gave the application to one of the systems administrators who had IIS Admin Tools installed on his computer. The application simply refused to send a message from the user and would fail silently.

It took us a while to figure out that the problem was IIS Admin Tools, but once we did, Internet Searches turned up nothing of value. This is basically a shot in the dark, hoping someone has an idea of a solution.

Answer 1

Does IIS Admin Tools have it's own mail server on it that might be conflicting.

Have you confirmed that it is IIS Admin Tools by removing it?

What about IIS?

Answer 2

I don't have a solution, but possibly a work around. If Outlook is installed on each users computer, you could add a reference to the outlook library and use the outlook.application object to send mail. There's a function someone has developed here to do just that.

Answer 3

While SendObject is an awfully easy way to send email, it's not very flexible (you can't attach a document, for instance). Tony Toews's Email FAQ has lots of options for sending email from Access.