email using sendobject from access

  • Thread starter Thread starter Linda in Iowa
  • Start date Start date
L

Linda in Iowa

This code works great on my computer to open the email program and input the
email address, subject, and text:

DoCmd.SendObject acSendNoObject, , , Me!EMAIL, , , "subject text", "message
text"

when I run the program from someone else's computer I get an error message
about SendObject not available.

They get mail from MSN and Yahoo. Outlook Express is on the computer and
that is what I use, just don't think they use it. Could it be there isn't a
default email program on the computer? Can I set up Outlook Express to open
when the DoCmd. sendObject is run?
 
Hi Linda...i am afraid i cant help you in this casebut i do find this topic
very interesting since i haev tried for ages to mail a "record".do you hae
any suggestion were i can finde more info about this..very intteresting..

Thanks! P
 
The Do.Cmd SendObject works to send attachments or just an email message in
the body. works well, except I don't know what is missing from my friends
computer to make it work. I have a from that runs from a query showing
those who need to renew their membership. The email address is a text field
that is converted to an email address by running this line of code first:
Me.emailaddress = Replace(Me.emailaddress, "http://", "mailto:")
Then the DoCmd.SendObject code.

It opens the default email program on my computer but can't get it to work
on the computer of the person that needs it in the program.
I am trying to get it to add all the email adresses either in the To: field
or the CC: field but every suggestion I have gotten just doesn't do it.
Linda
 
Back
Top