A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Automatically Send e-mail prompt



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 1st 08, 05:54 PM posted to microsoft.public.outlook.program_vba
Terry@tescom
external usenet poster
 
Posts: 1
Default Automatically Send e-mail prompt

I am using the sendObject action in an autoexec macro to send emails
automatically. My goal is to not have to interact with the email process,
unfortunately have not been able accomplish this because of the following
MSOutLook prompt:
A program is trying to automatically send an e-mail on your behalf.
Do you want to allow this?
If this is unexpected it may be a virus and you should choose no.

In MSOutlook I have set the Macro security to Low and I still get the prompt.
Ads
  #2  
Old May 1st 08, 06:30 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Automatically Send e-mail prompt

Outlook's macro security setting has nothing to do with the "object model guard" prompt. See http://www.outlookcode.com/article.aspx?ID=52 for your options.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Terry@tescom" wrote in message ...
I am using the sendObject action in an autoexec macro to send emails
automatically. My goal is to not have to interact with the email process,
unfortunately have not been able accomplish this because of the following
MSOutLook prompt:
A program is trying to automatically send an e-mail on your behalf.
Do you want to allow this?
If this is unexpected it may be a virus and you should choose no.

In MSOutlook I have set the Macro security to Low and I still get the prompt.

  #3  
Old May 6th 08, 03:06 PM posted to microsoft.public.outlook.program_vba
Robert Martim, Excel
external usenet poster
 
Posts: 4
Default Automatically Send e-mail prompt

You can use CDO to bypass Outlook. But if you want to use Outlook, you may
want to use Redemption to do that.

Here's how: http://www.msofficegurus.com/gshowtip.asp?IDTip=51

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/

  #4  
Old May 9th 08, 08:38 AM posted to microsoft.public.outlook.program_vba
shiva
external usenet poster
 
Posts: 1
Default Automatically Send e-mail prompt

Hi

Iam using outlook api to send emai lfrom my VB application.
Is this redemption library is only available option to get throgh the
security dialogs or is there any microsoft libraries available
Please let me know

Thanks in advance

Sivakumar

"Robert Martim, Excel" wrote:

You can use CDO to bypass Outlook. But if you want to use Outlook, you may
want to use Redemption to do that.

Here's how: http://www.msofficegurus.com/gshowtip.asp?IDTip=51

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/

  #5  
Old May 9th 08, 04:05 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Automatically Send e-mail prompt

As Robert suggested, using CDO for Windows to create and send the message would avoid any security prompts. That and other options are covered at http://www.outlookcode.com/article.aspx?ID=52

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"shiva" wrote in message ...
Hi

Iam using outlook api to send emai lfrom my VB application.
Is this redemption library is only available option to get throgh the
security dialogs or is there any microsoft libraries available
Please let me know

Thanks in advance

Sivakumar

"Robert Martim, Excel" wrote:

You can use CDO to bypass Outlook. But if you want to use Outlook, you may
want to use Redemption to do that.

Here's how: http://www.msofficegurus.com/gshowtip.asp?IDTip=51

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/

  #6  
Old May 9th 08, 04:53 PM posted to microsoft.public.outlook.program_vba
Suleman
external usenet poster
 
Posts: 1
Default Automatically Send e-mail prompt

how to use it please help me i don,t know this coding just give me a simple
solution
how i send mail automatic?


Sub Mail_CDO()
Dim iMsg As Object
Dim iConf As Object
' Dim Flds As Variant
Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
' iConf.Load -1 ' CDO Source Defaults
' Set Flds = iConf.Fields
' With Flds
'
..Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
'
..Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "Fill in
your SMTP server here"
'
..Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
' .Update
' End With
With iMsg
Set .Configuration = iConf
.To = "
.CC = ""
.BCC = ""
.From = """Ron"" "
.Subject = "Important message"
.TextBody = "Hi there" & vbNewLine & vbNewLine & _
"Cell A1 is changed"
.Send
End With
Set iMsg = Nothing
Set iConf = Nothing
End Sub


"Sue Mosher [MVP-Outlook]" wrote:

As Robert suggested, using CDO for Windows to create and send the message would avoid any security prompts. That and other options are covered at http://www.outlookcode.com/article.aspx?ID=52

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"shiva" wrote in message ...
Hi

Iam using outlook api to send emai lfrom my VB application.
Is this redemption library is only available option to get throgh the
security dialogs or is there any microsoft libraries available
Please let me know

Thanks in advance

Sivakumar

"Robert Martim, Excel" wrote:

You can use CDO to bypass Outlook. But if you want to use Outlook, you may
want to use Redemption to do that.

Here's how: http://www.msofficegurus.com/gshowtip.asp?IDTip=51

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/


  #7  
Old May 9th 08, 05:23 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Automatically Send e-mail prompt

Replace this statement:

Set iConf = CreateObject("CDO.Configuration")

with

Set iConf = iMsg.Configuration

Uncomment the configuration section, and add your SMTP server address.

See http://www.paulsadowski.com/WSH/cdo.htm for more examples.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Suleman" wrote in message news
how to use it please help me i don,t know this coding just give me a simple
solution
how i send mail automatic?


Sub Mail_CDO()
Dim iMsg As Object
Dim iConf As Object
' Dim Flds As Variant
Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
' iConf.Load -1 ' CDO Source Defaults
' Set Flds = iConf.Fields
' With Flds
'
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
'
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "Fill in
your SMTP server here"
'
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
' .Update
' End With
With iMsg
Set .Configuration = iConf
.To = "
.CC = ""
.BCC = ""
.From = """Ron"" "
.Subject = "Important message"
.TextBody = "Hi there" & vbNewLine & vbNewLine & _
"Cell A1 is changed"
.Send
End With
Set iMsg = Nothing
Set iConf = Nothing
End Sub


"Sue Mosher [MVP-Outlook]" wrote:

As Robert suggested, using CDO for Windows to create and send the message would avoid any security prompts. That and other options are covered at http://www.outlookcode.com/article.aspx?ID=52

"shiva" wrote in message ...
Hi

Iam using outlook api to send emai lfrom my VB application.
Is this redemption library is only available option to get throgh the
security dialogs or is there any microsoft libraries available
Please let me know

Thanks in advance

Sivakumar

"Robert Martim, Excel" wrote:

You can use CDO to bypass Outlook. But if you want to use Outlook, you may
want to use Redemption to do that.

Here's how: http://www.msofficegurus.com/gshowtip.asp?IDTip=51

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i allow sap BO to send mail from outlook w/o prompt ofer Outlook and VBA 1 April 8th 08 04:53 PM
Send mail using MAPI and not get a prompt Sanjay_S Outlook and VBA 1 November 8th 06 03:46 PM
Automatically prompt email address Shel Outlook - Using Contacts 2 August 27th 06 03:19 AM
automatically send e-mail when closing a custom outlook form Keefo Outlook - Using Forms 1 May 27th 06 03:22 PM
Outlook send automatically mail from sended folder [email protected] Outlook - General Queries 0 January 17th 06 10:06 AM


All times are GMT +1. The time now is 10:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.