can't get sendobject to open email


L

Linda in Iowa

I am still trying to get this to work on another computer as it works great
on my computer. WindowsXPhome, Access 2003, OE6
Button on the form uses the next line of code to send email.

DoCmd.SendObject acSendNoObject, , , Me!EMAIL, , , " membership has
expired", "message text is entered here"

When I run the program from my computer it opens Outlook Express with the
email address, subject and message.

When I put this on the computer of the person who will be using the Access
program it shows the following message:
"The command or action 'SendObject' isn't available now." and doesn't open
any email program. Why wouldn't it be available. The program has other VB
code that all works.

The computer I am trying to get this to work on gets email from MSN so we
configured OE to use the MSN account and verified we can send mail from it.
I am assuming you need an email program on your computer to use the
SendObject from Access as it wouldn't know how to open MSN from the internet
to send mail.

Ready to try any new suggestions.
 
Ad

Advertisements

D

Dirk Goldgar

Linda in Iowa said:
I am still trying to get this to work on another computer as it works great
on my computer. WindowsXPhome, Access 2003, OE6
Button on the form uses the next line of code to send email.

DoCmd.SendObject acSendNoObject, , , Me!EMAIL, , , " membership has
expired", "message text is entered here"

When I run the program from my computer it opens Outlook Express with the
email address, subject and message.

When I put this on the computer of the person who will be using the Access
program it shows the following message:
"The command or action 'SendObject' isn't available now." and doesn't
open any email program. Why wouldn't it be available. The program has
other VB code that all works.

The computer I am trying to get this to work on gets email from MSN so we
configured OE to use the MSN account and verified we can send mail from
it. I am assuming you need an email program on your computer to use the
SendObject from Access as it wouldn't know how to open MSN from the
internet to send mail.

Ready to try any new suggestions.


On the failing computer, have you set up Outlook Express as the default
e-mail program?
 
L

Linda in Iowa

Yes, Outlook Express is the default (and only) email program on the
computer. He normally logs into MSN for his email and still does it that
way. OE is only being used to send messages from the database. I wouldn't
think that checking mail through a web based server (MSN) would have any
effect on OE being default. He doesn't intend to use OE to receive any
mail. When you use the SendObject it looks for a default email program on
your computer, correct? As a side note, I was able to get Window Live Mail
to work when it is default on my computer but didn't want to download Live
to his computer just to see if that would work. Assume it wouldn't be any
different than OE. I don't think there is a way to make the SendObject use
MSN as a default email program since it is on the internet and not a local
computer.
 
Ad

Advertisements

J

John Smith

You need to have not only OE as default but also an account configured in it for
it to be able to send mail. If you want to send your database messages from MSN
then set up an account for MSN (you will probably want to use IMAP) in OE and
check that you can send a message from OE. It should then all work from the
database.

HTH
John
##################################
Don't Print - Save trees
 

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