Cannot Send Object at this time; trying to send email

I have code that send email using DoCmd.SendObject that works on one computer but not on another.  I get error Cannot Send Object at this time.  MSAccess librarys appear to be the same and both use Outlook Express.
PJEODAsked:
Who is Participating?
 
PJEODConnect With a Mentor Author Commented:
I looked at these 3rd party options - they do attachments but not signatures.  I found another computer that didn't give me the SendObject error and moved the program to that one instead
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Can you show the code you're using?
0
 
PJEODAuthor Commented:
   DoCmd.SendObject acSendNoObject, , acFormatTXT, _
        Me.ThisEmailAddr, , _
        "staff@Endry.Org", _
        Me.ThisSubject, _
        Me.ThisMessage & vbCrLf & Me.ThisTrailer, True
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Try removing the acFormatTXT ...
0
 
PJEODAuthor Commented:
i left the field empty, still doesn't work getting error
2046 The command or action Send Object isn't available now

This sendobject function works on another computer without error, just not on the one I need it on.
0
 
PJEODAuthor Commented:
Anybody with any ideas on this?  Its not related to Admin status or VBasic coding
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Are you using this in a Loop? SendObject is known to fail in 2000 when used in a loop.
0
 
PJEODAuthor Commented:
Good question - but No.  Staffer clicks on command button to send email and it goes to Docmd.sendobject.  
0
 
PJEODAuthor Commented:
How about if I install Mozilla?  will Docmd.Sendobject run Mozilla instead of OE?  Will I have to uninstall OE first or make Mozilla primary somehow?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
SendObject works with whatever is the default mail client.

Try this instead of SendObject:

    Application.FollowHyperlink "mailto:" & Me.ThisEmailAddr & "?subject=" & Me.ThisSubject & "&body=" & Replace(Me.ThisMessage & vbCrLf & Me.ThisTrailer, "&", "%26")

I've had odd instances where I had to use this construct in order to make this work.
0
 
PJEODAuthor Commented:
YES! It works!  However, it the new mail message it opens doesn't use the signature, which is contains our logo, address, hours, etc.  Normally when we start a new message from OE it has this at the bottom.  Any ideas?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I don't think you'll be able to use the signature ... but I'm not sure. The Followhyperlink method is a failsafe method, and you can't really automate it too much.

You could try automating Outlook Express with this 3rd party control:
http://www.efextra.com/oelib.htm

Or just use vbSendMail:
www.freevbcode.com/ShowCode.Asp?ID=109
0
 
PJEODAuthor Commented:
Followhyperlink will not send office hours, address, disclaimer that we'd like to send at bottom of email; can't even get it to send vbCrLf.  One of the links gives "page not found" error and the other is over my head.  I would really just like the one computer to accept the SendObject like my other computer.  Are there unset options that might explain it?  Both are Admin users, same version and dll files in Office Express.  
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Outlook Express really isn't "automatable" ... in other words, while there are some workarounds, they're flaky (at best) and are prone to issues. This is why I suggested you look into vbSendMail, but if it's too complex then you may want to stick with other methods.

The SendObject command in Access relies entirely on the default email client on your machine. If your code works on MachineA, which is setup exactly like MachineB, but your code does NOT work on MachineB then you have some issues on MachineB which need to be addressed. These aren't Access issues, but almost certainly are issues with your email client. Have you made sure that your email client is fully up to date? What about Office, Windows, etc etc ...
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Also: If you want a full-featured, easily handled email solution then SendObject is most definitely not the path to take. I use the Internet Mail Library from Codestone (www.codestone.co.uk) with very good results, but there are plenty of other 3rd party controls you can use as well.

0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The third party options most certainly do signatures, they just don't use the same sig you use in Outlook or OE, since those are specific to the program. You just use the HTML format and add your own signature.

Thanks for the 0 points ... I enjoy using up my time on this ALL VOLUNTEER forum with questions like this ... good luck with future questions, you'll get no further assistance from me.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.