Runtime Error 2293

[vic]

I have an Access 2002 Application that uses Send Object to send email which
has stopped working. When I Googled this it seems to have something to do
with a Security Patch that MS distributed. It also seems that if I'm using
PST files that I'm stuck!

If I convert this database to Access 2007 it works but I'm not ready to do
this at this point. I find it hard to believe that there is not a solution
to this problem. I read where 1 user had placed "Mail Recipient" on the
toolbar and solved the porblem. It wasn't clear on what toolbar as I don't
find this in Access 2002 toolbars.

Can someone provide some guidence on solving this problem.

Thanks,

Vic

 

[Pete D.]

There are solutions to the issue but the best ones usually cost money. See
below for information on outlook security.
http://www.slipstick.com/index.htm

 

[vic]

Pete -

I didn't see anything here that specifically addresses this problem. What I
did not mention is that it works ok on my XP machine but is failing on my
Vista machine. Maybe the Vista Newsgroup would be a more suitable place to
post this problem.

Vic

 

[Pete D.]

Are you in an exchange server environment or using pst?
http://support.microsoft.com/kb/263084/en-us?spid=2509&sid=251

I don't know if it will help, I didn't realize you were in 2007 and although
I have it my experience is limited. Until my office upgrades to it I have
no reason to really get into it. Pete D.

 

[vic]

Pete,

I'm using Access 2002 and Outlook 2007. As mentioned previously it works
with Access 2007 but fails with Access 2002 and Vista. Works with Access
2002 and Windows XP

Vic

 

[vic]

Hello,

Maybe this will help! I've discovered that if Outlook is closed I get the
message that someone is trying to send an email etc. and I can then allow
it. When I restart Outlook the message is sent. There must be a fix for
this!

Help anyone?

Vic

 

[Pete D.]

This is a problem with security update but at this time I cannot duplicate
it or find a solution. Might be time to ask MS if they have solution.

 

[vic]

Pete,

The problem occurs only in Access 2002, Outlook 2007 and Vista environment
which I don't think you're on. It works by changing to Access 2007 or on an
XP machine.

I don't know how much help I am going to get from MS since they don't offer
much support for Access 2002 and longer.



Vic

 

[vic]

Well it seems the parameter "EditMessage" is the problem. I had this set to
true so the message would come up in Outlook where I could complete the
addressing and add any additional comments if required. Changing this to
false will at least send the email and I can do any any further editing of
the message which is ok. Hope this helps someone else who runs into this
problem.

strMessage = "Put the body of your email here ..."
strEmail = InputBox("Email Address where you want the Financial
report sent:", "Show Secretary")
DoCmd.SendObject ObjectType:=acSendReport, _
ObjectName:=stDocName, outputformat:=acFormatRTF, _
To:=strEmail, Subject:="Show Financial Report",
MessageText:=strMessage, EditMessage:=False


Vic