![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
How can I turn Outlook alerts off?
When I try to send an email from my Excel VBA program I get the following alert. "A program is trying to automatically send e-mail on your behalf. Do you want to allow this?" Yes, No or Cancel. Is there a way to either turn off the alert or automatically answer Yes. Relevent part of program: --------------------------------------------- Set appOL = CreateObject("Outlook.Application") Set appMess = appOL.CreateItem(olMailItem) For cnt = 1 To 99 If ISLIKE(Cells(cnt, 12).Value, "*@*") Then 'does cell contain email address? appMess.To = "Valid.e-mail@address" appMess.Subject = "tester" appMess.Body = "test" appMess.Send ------ this causes alert to show End If Next cnt appMess.Quit appOL.Quit Set appOL = Nothing Set appMess = Nothing --------------------------- Henry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
alert for outlook 2003 Calendar | joe | Outlook - Calandaring | 1 | June 19th 08 03:24 AM |
New email sound and desktop alert? OL 2003 | 99XJ | Outlook - General Queries | 1 | August 17th 07 12:19 PM |
Outlook 2003 lost show new mail alert | Beemer | Outlook - General Queries | 7 | March 6th 07 11:03 PM |
Outlook 2003: No alert for conflicts with recurring meetings | James.Brown | Outlook - Calandaring | 0 | May 23rd 06 07:11 PM |
outlook 2003 new mail desktop alert not working after reboot | [email protected] | Outlook - General Queries | 0 | May 4th 06 08:23 PM |