Error 2293 when sending email from Access - Can't Send This E-Mail Message

I am trying to use the inbuilt object within Access VBA to send an email. This has worked in very well over the years but in recent years it has begun to fail. My current setup is:-

Microsoft Access 2013 (full)
Outlook 2013

I'm running the following line of code which is resulting in error 2293 Can't Send This E-Mail Message...

Dim SecurityManager As New AddInExpress.OutlookSecurityManager

    SecurityManager.DisableSMAPIWarnings = True
    Call DoCmd.SendObject(acSendNoObject, , , "support@eskimoepos.com", , , "Test Email", "Email Body Text", True)
    SecurityManager.DisableCDOWarnings = False

Open in new window


Interestingly, if I run this code with Microsoft Outlook closed, nothing happens - there is no error message but no email is sent either. It is only when Outlook is open I get the error message.

Also interesting is that elsewhere in the program I automate Outlook using the CreateObject (or GetObject) methods and these also work fine. The Security Manager should knock any warning messages that look like the following (although at this stage the security warning would be preferable to the error message):-
outlook_security_warning_1.gif
However, now I just get an error regardless of whether the Security Manager is on or off.

I can't quite understand how a suite (such as the Office suite) can have a security issue that stops it from working.

Your input is eagerly sought.

Kind regards,

Jed
LVL 1
JedNebulaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Jed,

 You'll need to buy a 3rd party lib to get around the security messages, or live with them.

 Two are:

http://www.everythingaccess.com/vbMAPI.asp

http://www.dimastr.com/redemption/home.htm

  I use the first one in my apps.

 Outlook has these protections built-in so that malicious software can't work it's way in.

Jim.
0
Jeffrey CoachmanMIS LiasonCommented:
Here is another popular utility:
http://www.contextmagic.com/express-clickyes/

To be on the safe side, when testing, ...I would disable any "Security Manager" code, (to prevent any conflicts...)
0
Luke ChungPresidentCommented:
A more reliable way to send automated emails is with SMTP. SMTP bypasses the security settings of Outlook and MAPI. It eliminates the need to have Outlook running out even installed.

Using something to suppress the Outlook warning messages is risky. It may be okay in your environment, but not good to distribute to everyone.

We offer a Microsoft Access email addin program and VBA library to send personalized emails to everyone in a list and attach filtered reports as PDF files. Check out Total Access Emailer for more information: http://fmsinc.com/MicrosoftAccess/Email.asp

A free trial is available.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Neil RussellTechnical Development LeadCommented:
IF you must use outlook to send and not an SMTP server then I have always found redemption the best way forward. Simple and easy to code with.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
If Sending email is your only goal then you can talk directly to an SMTP server as Luke said. To do that you can also use VB send mail, or BLAT.

Jim
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JedNebulaAuthor Commented:
I used the Outlook method in the end.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

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.