Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rating: Thread Rating: 12 votes, 5.00 average. Display Modes
Old 06-22-2009, 02:19 PM   #1
mjwlaz
Registered User
 
Join Date: Jun 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
mjwlaz is on a distinguished road
SendObject Isn't Available Now

Since I've started upgrading computers on my network I get a new error from our Access system: "The command or action 'SendObject' isn't available now.

The error comes up when we attempt to email from within our Access program. On the PCs where it works a report is generated and then Outlook Express opens up with the report included. On the PCs that don't work, the report is generated but Outlook Express doesn't load.

Our access database is on the server and each workstation has the Access 2000 runtime installed on it (rather than a full copy of Access) and a shortcut to the program on the server. All PCs run Microsoft Office 2000 with one exception where Office 97 is installed, and Windows XP Pro or Home SP2.

I'm not really sure what's changed but I suspect a Windows update might have tightened down security. Is there anyone who has experienced this before or might otherwise have an idea as to how to get it working again?

Thanks for the help.

MJ

mjwlaz is offline   Reply With Quote
Old 06-25-2009, 06:17 AM   #2
ncarlblom
Registered User
 
Join Date: Jun 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
ncarlblom is on a distinguished road
Re: SendObject Isn't Available Now

I am having the same problem with Access XP due to updates. Did you find a fix/workaround?
ncarlblom is offline   Reply With Quote
Old 06-25-2009, 11:52 AM   #3
mjwlaz
Registered User
 
Join Date: Jun 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
mjwlaz is on a distinguished road
Re: SendObject Isn't Available Now

No. I can't seem to find help with this anywhere. Hanging in there, keeping my fingers crossed.

mjwlaz is offline   Reply With Quote
Old 06-25-2009, 11:57 AM   #4
SOS
Registered Lunatic
 
SOS's Avatar
 
Join Date: Aug 2008
Location: Somewhere between here and there
Posts: 3,517
Thanks: 2
Thanked 59 Times in 54 Posts
SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light
Re: SendObject Isn't Available Now

Do all of the computers that don't work have an email profile created?
SOS is offline   Reply With Quote
Old 06-25-2009, 01:01 PM   #5
ncarlblom
Registered User
 
Join Date: Jun 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
ncarlblom is on a distinguished road
Re: SendObject Isn't Available Now

I was finally able to fix it. We use Thunderbird for our email, Windows XP SP3, Office XP SP2/XP3. When Access quit working for SendObject, it was also brought to my attention by other users that Word, Excel and even Adobe Reader were all unable to attach a document to an email from within the respective program. Creating a new message from within Thunderbird and then attaching the saved file still worked...obviously no help for the access problem.

I ended up repairing my Office installation and that led me to have to go into "Set Program Access and Defaults" to change Thunderbird to the default. Under the "Custom" section, I changed "Choose a default e-mail program" from "Use my current e-mail program" to "Mozilla Thunderbird" and now it works fine. Apparently it needed to be specified and not defaulted to "current e-mail program."

When I had installed Thunderbird on each machine, I had set the email default in the Internet Options ->Program section (which never changed), but it appears that I also needed to set it in Program Access and Defaults. I read that a bunch of times in my searching and assumed that because I had set it in Internet Options that it was the same. It was not.

I'm still interested to find out why this happened. I assume it was some Windows Update, but don't know for sure. If anyone knows, it'd be greatly appreciated.

Sorry for the long-winded reply, but it baffles me. I hope this helps.

Nathan
ncarlblom is offline   Reply With Quote
Old 06-25-2009, 01:06 PM   #6
SOS
Registered Lunatic
 
SOS's Avatar
 
Join Date: Aug 2008
Location: Somewhere between here and there
Posts: 3,517
Thanks: 2
Thanked 59 Times in 54 Posts
SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light
Re: SendObject Isn't Available Now

Well, thanks for posting back with the answer. Hopefully it will help some other poor soul down the line who ends up with a similar problem
SOS is offline   Reply With Quote
Old 06-30-2009, 08:04 AM   #7
mjwlaz
Registered User
 
Join Date: Jun 2009
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
mjwlaz is on a distinguished road
Re: SendObject Isn't Available Now

This didn't do it for me.
I was really hopeful. Any other ideas?

MJ

mjwlaz is offline   Reply With Quote
Old 06-30-2009, 09:09 AM   #8
SOS
Registered Lunatic
 
SOS's Avatar
 
Join Date: Aug 2008
Location: Somewhere between here and there
Posts: 3,517
Thanks: 2
Thanked 59 Times in 54 Posts
SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light
Thumbs down Re: SendObject Isn't Available Now

Quote:
Originally Posted by mjwlaz View Post
This didn't do it for me.
I was really hopeful. Any other ideas?

MJ
revised - ignore... I didn't realize that you were the original poster on this.

Last edited by SOS; 06-30-2009 at 09:11 AM. Reason: error
SOS is offline   Reply With Quote
Old 08-10-2009, 09:39 AM   #9
thedirtyfix
Registered User
 
Join Date: Aug 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
thedirtyfix is on a distinguished road
Re: SendObject Isn't Available Now

Thanks, setting Thunderbird specifically in Windows fixed my email SendObject problem for Access 2007. I had gone into Thunderbird's options to set it as the default mail client, but that wasn't enough.
thedirtyfix is offline   Reply With Quote
Old 02-05-2010, 04:04 PM   #10
drumstruck
Registered User
 
Join Date: Feb 2010
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
drumstruck is on a distinguished road
Re: SendObject Isn't Available Now

Sorry for posting this in an old thread - it came up via Google.
I spent 2 days troubleshooting the same MS Access SendObject issue. Our email client is Lotus Notes. The solution was that my win.ini file was somehow messed up (in C:\WINNT or C:\Windows).

This code was missing...
[Mail]
MAPI=1
CMC=1
CMCDLLNAME=mapi.dll
CMCDLLNAME32=mapi32.dll
MAPIX=1
MAPIXVER=1.0.0.1
OLEMessaging=1

drumstruck is offline   Reply With Quote
The Following User Says Thank You to drumstruck For This Useful Post:
hudaz (05-28-2014)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Limitation Of SendObject? shuff Macros 0 04-14-2005 06:51 AM
[SOLVED] Help with Macro Action SendObject dkuntz Macros 1 12-01-2003 11:24 AM
SendObject macro mura Macros 0 06-09-2003 12:14 PM
[SOLVED] SendObject and Send To Problems... davecripps Modules & VBA 0 11-19-2002 07:18 AM
SendObject command Erik Modules & VBA 1 07-31-2000 05:21 AM




All times are GMT -8. The time now is 01:26 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World