Sending Email with Outlook

ivanotto

New Member
Joined
Aug 25, 2002
Messages
6
How do you disable the alert messages in Outlook "A Program is trying to Access email addresses you have stored in Outlook...." and then "A Program is trying to send messages automatically on your behalf ....." either from Excel VBA or Outlook?
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Just a quick guess but this generally stops alerts showing in Excel, not suer about OUtlook but maybe it might help

application.DisplayAlerts = False
 
Upvote 0
ivanotto,

This is by default since MS decided to pay some interest in securities issues.

MS Outlook generate this messages and I believe it´s not possible to override them.

Kind regards,
Dennis
 
Upvote 0
On 2002-08-27 00:34, XL-Dennis wrote:
ivanotto,

This is by default since MS decided to pay some interest in securities issues.

MS Outlook generate this messages and I believe it´s not possible to override them.

Kind regards,
Dennis

Hi Dennis
You actually can overide this, if you do use Outlook2K then you will be
warned of out going mail. The work around for this is
to get "Outlook Redemption" it works around limitations imposed by the Outlook Security Patch and Service Pack 2 of MS Office 2000 (which includes Security Patch) plus provides a number of functions to work with the properties and functionality not exposed through the Outlook object model.

For more information see http://www.dimastr.com/redemption


Set SafeItem = CreateObject("Redemption.SafeMailItem")
would be the command to use to send without warning.
 
Upvote 0
Ivan,

Excellent!
This give us new and great opportunities :smile:

Next time You´re round my town I will buy You some swedish beers :smile:

Thanks,
Dennis

Ds I should by now realize to never say never!Ds
_________________
"Windows was not able to find any keyboard. Press F1-button to try again or F2-button for cancel."
This message was edited by XL-Dennis on 2002-08-27 05:30
 
Upvote 0
On 2002-08-27 05:26, XL-Dennis wrote:
Ivan,

Excellent!
This give us new and great opportunities :smile:

Next time You´re round my town I will buy You some swedish beers :smile:

Thanks,
Dennis

Ds I should by now realize to never say never!Ds
_________________
"Windows was not able to find any keyboard. Press F1-button to try again or F2-button for cancel."
This message was edited by XL-Dennis on 2002-08-27 05:30

Hi Dennis, I just might take you up on that :smile:

I learnt a while ago to never say never there is always someone somewhere who may have a work around :smile:
 
Upvote 0

Forum statistics

Threads
1,226,456
Messages
6,191,144
Members
453,643
Latest member
adamb83

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top