Solved

VB Script to send e-mail

Posted on 2009-04-10
4
438 Views
Last Modified: 2012-06-27
I need a VB Script that will send e-mail, that is not dependent on CDO.  The script will run from desktops that have Outlook...I just do not want to depend on CDO.

Here is the current script:

I just want similar functionality without CDO.
strEmailDomainPos = instr(mailAdr, "@")

		GetEmailDomain = mid(mailAdr , strEmailDomainPos)

	End Function
 
 

	Sub GetSMTPServer 

		set cn = createobject("ADODB.Connection")

		set cmd = createobject("ADODB.Command")

		set rs = createobject("ADODB.Recordset")
 

		set objRoot = getobject("LDAP://RootDSE")

		configurationNC = objRoot.Get("configurationnamingcontext")
 

		cn.open "Provider=ADsDSOObject;"

		cmd.activeconnection = cn
 

		cmd.commandtext = "<LDAP://" & configurationNC & _

              ">;(objectCategory=msExchExchangeServer);name;subtree"

		set rs = cmd.execute
 

		while rs.eof<>true and rs.bof<>true

		      	strSMTPServer = rs(0)

			'msgbox rs(0)

		     	rs.movenext

		wend

	

		cn.close

	End sub
 

	Function GetEmail(strAccountName, strDomainName)
 

		Dim adoLDAPCon, adoLDAPRS, strLDAP
 

		Set adoLDAPCon = CreateObject("ADODB.Connection")

		adoLDAPCon.Provider = "ADsDSOObject"

		adoLDAPCon.Open "ADSI"

		strLDAP = "'LDAP://" & strDomainName & "'"

		Set adoLDAPRS = adoLDAPCon.Execute("select mail from " _

		 & strLDAP & " WHERE objectClass = 'user'"& _

		 " And samAccountName = '" & strAccountName & "'")

		With adoLDAPRS

			If Not .EOF Then

				GetEmail = .Fields("mail")

			Else

			        GetEmail = ""

			End If

		End With

		adoLDAPRS.Close

		Set adoLDAPRS = Nothing

		Set adoLDAPCon = Nothing

	End Function
 

	

	sub sendEmail
 

		Set objEmail = CreateObject("CDO.Message")

		objEmail.From = mailAdr

		objEmail.To = strEmailTo & strEmailDomain 

		msgbox objEmail.To

		objEmail.Subject = Summary.Value

		GetUserAddedInfo()

		objEmail.Textbody = Details.Value & vbCr & vbLf & strbaseInfo & vbCr & vbLf & GetUserAddedInfo 

		objEmail.Configuration.Fields.Item _

		 ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2

		objEmail.Configuration.Fields.Item _

		 ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = _

		     strSMTPServer

		objEmail.Configuration.Fields.Item _

		 ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25

		objEmail.Configuration.Fields.Update

		objEmail.Send

                ExitProgram

	End Sub

Open in new window

0
Comment
Question by:bbanis2k
  • 3
4 Comments
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 24118855
Hello bbanis2k,

        outlookMail strSubject:="Subject String", _
        strBody:="Body data is :", _
        strTo:="fred@fred.com", _
        SendYN:=False, _
        AttachYN:=attach <> "", _
        Attach1:=attach

Note:
    sendYN if true will send otherwise it will display the email
    attach is a comma seperated string of the filepaths for any attachmnets.

Any Help?

Regards,
Chris
Function outlookMail(strSubject As String, strBody As String, Optional strTo As String, _
                            Optional strCC As String, Optional strBCC As String, Optional SendYN As Boolean, _
                            Optional AttachYN As Boolean = False, Optional Attach1 As String) As Boolean
Dim olApp As Object
Dim olMsg As Object
Dim str() As String
Dim att As Variant 
    Set olApp = CreateObject("Outlook.Application")
    Set olMsg = olApp.CreateItem(0)
    With olMsg
        .To = strTo
        .CC = strCC
        .BCC = strBCC
        .subject = strSubject
        .body = strBody
        If AttachYN And Attach1 <> "" Then
            Attach1 = Replace(Attach1, ",", ";")
            str = Split(Attach1, ";")
            For Each att In str
                .Attachments.Add att
            Next
        End If
        If SendYN Then
            .Send
        Else
            .Display
        End If
    End With 
Set olMsg = Nothing
Set olApp = Nothing
End Function

Open in new window

0
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 500 total points
ID: 24120930
Apologies just realised you asked for script.

See as modified

Chris
attach = ""

outlookMail "Subject String", _

        "Body data is :", _

        "fred@fred.com", _

        "", _

        "", _

        False, _

        attach <> "", _

        attach

        

Sub outlookMail(strSubject, strBody, strTo, _

                            strCC, strBCC, SendYN, _

                            AttachYN, Attach1)

    Set olApp = CreateObject("Outlook.Application")

    Set olMsg = olApp.CreateItem(0)

    With olMsg

        .To = strTo

        .CC = strCC

        .BCC = strBCC

        .subject = strSubject

        .body = strBody

        If AttachYN And Attach1 <> "" Then

            Attach1 = Replace(Attach1, ",", ";")

            str = Split(Attach1, ";")

            For Each att In str

                .Attachments.Add att

            Next

        End If

        If SendYN Then

            .Send

        Else

            .Display

        End If

    End With 

Set olMsg = Nothing

Set olApp = Nothing

End Sub

Open in new window

0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 24903106
bbanis2k

What is the status of this Q from your perspective?

Chris
0
 

Author Closing Comment

by:bbanis2k
ID: 31569043
Thank you!
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Welcome to part one of a multi-part tutorial series, VBScript for Windows System Administrators.  The goal of this series is to teach non-programmers how to write useful VBS code to automate their environment, and perform tasks faster, and in a more…
In this article we want to have a look at the directory attributes which are used by Microsoft to store the so called Security Identifiers (SID). These SIDs plays an important role in delegating and granting permissions and in authentication of trus…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now