DoCmd.SendObject Problem

[ddevil]

I'm trying to send an email from Access using the code below, but when it's executed, the Internet Connection Wizard comes up. Outlook is our current email client, do you know why this would happen?

DoCmd.SendObject acSendNoObject, , , ToReceiver, , , "Test", "TestData", , False

 

[lameid]

Maybe Outlook EXPRESS is the default mail client on that system and not what you think it is?

To check open up Internet Explorerer.
On the Tools Menu select internet options.
Switch to the Programs tab.
For E-mail make sure the appropriate e-mail program is selected (presumably Microsoft Outlook).

The directions above are for Internet Explorer 7 but they are similar if not the same for version 6.

 

[ddevil]

This was set correctly any other ideas?

 

[lameid]

Same place but the Connections tab instead... You probably want the option that says NEVER DIAL A CONNECTION.

 

[ddevil]

No, that wasn't it either. Is their and add in or something that I need to do in Access?

 

[lameid]

I had been assuming you can send a message from Outlook without error.

Does Outlook send messages ok?

 

[ddevil]

Yes, no problems there.

 

[lameid]

It should more or less just work... Although Outlook is likely to prompt you about another application trying to send mail.

Since you don't get the Internet Connection wizard when you open IE, my gut tells me that the default mail client is not Outlook. Are you absolutely sure it is set to Outlook and not Outlook Express?

 

[ddevil]

I'm absolutely sure. I even followed the instructions from this site

http://www.freeemailtutorials.com/microsoftWindows/settingDefaultEmailClient.cwd

and when I click on the link to test it, Outlook opens. I've tried having outlook open when using the send object function and I still get the same results. I'm stumped. It has to be something with my machine. My next step is to have someone else test the button and see if it does the same thing for them. I'll let you know if I find out anything or if you have more ideas, that would be great. Thanks!

 

[lameid]

I am guessing here but under the file menu in Outlook is Work Offline checked? If so, if you select (uncheck it) does the message go away?

 

[ddevil]

No, work off line, was not selected. It was unchecked.

 

[lameid]

When I test your line of code and substitute a literal string (e-mail address) for the ToReceiver variable, it opens an e-mail ready to be sent just fine.

If you want to send it without seeing it, you need to pass false for the edit parameter. That may be worth a shot to see if it works better. But honestly I am out of ideas why you would get that message.

 

[mp9]

What happens if you try the alternative to DoCmd.SendObject that can be found at

http://www22.brinkster.com/accessory/modules/005.shtml

- that explicitly forces use of Outlook.