sconly
08-10-2010, 09:01 AM
Before anyone says, I have done a search on this forum.
I was wondering if anyone has any (vba) code example for creating/sending an email using a SMTP server from Excel?
is CDO the only way? I only ask because part of the cdo code i've found has the following in it and when i put any of the web addresses into my address bar all i get back is an error page.
Dim Flds As Variant
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
Thanks!
I was wondering if anyone has any (vba) code example for creating/sending an email using a SMTP server from Excel?
is CDO the only way? I only ask because part of the cdo code i've found has the following in it and when i put any of the web addresses into my address bar all i get back is an error page.
Dim Flds As Variant
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
Thanks!