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
Prev Previous Post   Next Post Next
  #7  
Old May 9th 08, 04: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 03:53 PM
Send mail using MAPI and not get a prompt Sanjay_S Outlook and VBA 1 November 8th 06 02:46 PM
Automatically prompt email address Shel Outlook - Using Contacts 2 August 27th 06 02:19 AM
automatically send e-mail when closing a custom outlook form Keefo Outlook - Using Forms 1 May 27th 06 02:22 PM
Outlook send automatically mail from sended folder [email protected] Outlook - General Queries 0 January 17th 06 09:06 AM


All times are GMT +1. The time now is 11:36 PM.


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.