Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Not working with gmail as far as I know.
Ask the name of the smtp server of the Internet provider on your work -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Luis" wrote in message oups.com... Ron, Sorry for mi persistence, but now i have the error "Run-time error -2147220973(80040213): Error in the connection to the carrier off the server".! The code that i use is _____________________ Sub CDO_Mail_Small_Text() Dim iMsg As Object Dim iConf As Object Dim strbody As String 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/ smtpauthenticate") = 1 .Item("http://schemas.microsoft.com/cdo/configuration/ sendusername") = "lmbarre***************" .Item("http://schemas.microsoft.com/cdo/configuration/ sendpassword") = "*******" .Item("http://schemas.microsoft.com/cdo/configuration/ smtpserver") _ = "smtp.gmail.com" .Item("http://schemas.microsoft.com/cdo/configuration/ smtpserverport") = 25 .Update End With strbody = "Hi there" & vbNewLine & vbNewLine & _ "This is line 1" & vbNewLine & _ "This is line 2" & vbNewLine & _ "This is line 3" & vbNewLine & _ "This is line 4" With iMsg Set .Configuration = iConf .To = "lmbarreiro*****" .CC = "" .BCC = "" .From = """Ron"" " .Subject = "Important message" .TextBody = strbody .Send End With End Sub _____________________ Can you help me? Like I said before, my pc use the outlook 2003 in exchange mode, with Windows NT, and i“m not the admin (is for my office use), can I in any way transposed the prob? Thank“s Luis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
how do you email a portion of a worksheet (range) as an insert into the body of an email? | Excel Programming | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel |