Solved

Cannot Send Object at this time; trying to send email

Posted on 2008-09-30
16
287 Views
Last Modified: 2013-12-17
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.
0
Comment
Question by:PJEOD
  • 8
  • 8
16 Comments
 
LVL 84
ID: 22604968
Can you show the code you're using?
0
 

Author Comment

by:PJEOD
ID: 22607430
   DoCmd.SendObject acSendNoObject, , acFormatTXT, _
        Me.ThisEmailAddr, , _
        "staff@Endry.Org", _
        Me.ThisSubject, _
        Me.ThisMessage & vbCrLf & Me.ThisTrailer, True
0
 
LVL 84
ID: 22609633
Try removing the acFormatTXT ...
0
 

Author Comment

by:PJEOD
ID: 22610083
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
 

Author Comment

by:PJEOD
ID: 22614639
Anybody with any ideas on this?  Its not related to Admin status or VBasic coding
0
 
LVL 84
ID: 22614806
Are you using this in a Loop? SendObject is known to fail in 2000 when used in a loop.
0
 

Author Comment

by:PJEOD
ID: 22615771
Good question - but No.  Staffer clicks on command button to send email and it goes to Docmd.sendobject.  
0
 

Author Comment

by:PJEOD
ID: 22616001
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
Integrate social media with email signatures

Is your company active on social media? Do you also use email signatures? Including social media icons in your email signature is a great way to get fans for free. Let all your email users know you’re on social media quickly and easily, in a single click.

 
LVL 84
ID: 22617080
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
 

Author Comment

by:PJEOD
ID: 22619444
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
 
LVL 84
ID: 22619538
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
 

Author Comment

by:PJEOD
ID: 22662885
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
 
LVL 84
ID: 22663361
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
 
LVL 84
ID: 22663381
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
 

Accepted Solution

by:
PJEOD earned 0 total points
ID: 22724000
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
 
LVL 84
ID: 22739055
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There was an incident about the POP3 issue for the double read receipts and delivery receipts in Exchange 2013.  There was huge research been done and found solution for the duplicate mails. Especially when the user gets  duplicate mails.
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now