Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 12-01-2009
Member
 
Join Date: Jan 2009
Posts: 9
MsAccess VBA to the outlook outbox

I am trying to send an automatic mail from MsAccess VBA to the outlook outboxes, when this message is sent, this error appears.

A program is trying to automatically send e-mail on your behalf.

The help button says:

A program is trying to send mail using Item.Send
A program is trying to automatically send e-mail using a Microsoft Outlook Visual Basic Application command, Item.Send. If you want this program to send this e-mail, click Yes. To stop the program, click No.
If you are unsure which program is sending the e-mail or why, you may want to click No to avoid any possible spread of viruses.

Note When this message is displayed, the Yes button is not available for 5 seconds.

How can I disable this protection as we use MS Outlook for only sending email?
Reply With Quote
  #2  
Old 12-01-2009
Member
 
Join Date: Apr 2008
Posts: 2,139
Re: MsAccess VBA to the outlook outbox

It's a safety feature of Microsoft Outlook. it helps to prevent unwarranted use of the email system, particularly by viruses. Since you are activating it, you need a third party work-around.

Download Express Clickyes. If you are using a program that causes Outlook to generate the prompt, you ll find this tiny tool very handy.
Reply With Quote
  #3  
Old 12-01-2009
Member
 
Join Date: Jan 2009
Posts: 9
Re: MsAccess VBA to the outlook outbox

Thank you for your note:

A - I will try some code this week
B - If the code we try does not work I will spend the $40.00 on the product you suggest.
Reply With Quote
  #4  
Old 12-01-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
ThumbsUp Re: MsAccess VBA to the outlook outbox

  1. Create or buy an ActiveX/DLL that uses Extended MAPI to manage the creation of e-mails. The Outlook Security Model only effects 'Simple MAPI' functions not 'Extended MAPI' ones but unfortunately you can't directly interface with Extended MAPI functions from VB/VBA - hence the need for an ActiveX control or a DLL that would be written in a lower level language. Outlook Redemption is a popular DLL solution that uses Extended MAPI.

  2. Create or buy an application that simply presses the 'Yes' button after the elapsed 5 second delay. In my opinion this is a bad idea - but if you want to follow this route, have a search around the net.

  3. If using Outlook 2003, the VBA code stored inside of the VBA Project of Outlook is assumed to be "Trusted" - this then bypasses the warning messages - then you can call this VBA code using automation of Outlook.

Requirements :

Outlook 2003 (earlier versions of Outlook do not "trust" the VBA code inside the Outlook VBA Project)

Advantages :
  • Doesn't need any DLLs or external libraries.

Disadvantages :
  • You need to add some code to the VBA project inside of Outlook
  • Outlook 'Macro Security' level must be set to LOW or MEDIUM

Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "MsAccess VBA to the outlook outbox"
Thread Thread Starter Forum Replies Last Post
Mail Stuck in Outlook 2007 Outbox - Caused by Deleting Outlook Express? TropicanaMorgana Windows Software 1 14-05-2011 09:14 AM
Microsoft Outlook outbox send problem Lares Windows Software 5 30-11-2010 07:34 AM
Outlook 2010 - Emails will not leave outbox Ranter Windows Software 5 19-10-2010 01:02 AM
Outlook 2007 messages have got Stuck in Outbox Lapentti Windows Software 7 10-06-2010 01:46 AM
Emails stay in outlook express outbox PhantomBruce Windows Software 2 12-09-2009 07:56 AM


All times are GMT +5.5. The time now is 07:33 AM.