Jump to content

SendMail doesn't work with RunWait on Windows 2003


Recommended Posts

Hi,

My First thread....Yeah.

First I want to thank the AutoIT team for a great job, I have become a fan and I use it on a daily bases.

Here is my issue ....

I have an AutoIT script, which generate a VBS script, Executes the "RunWait" and Executes that VBS scripts to send an Email to a user. This scripts works on 24 hosts that are 2008, Windows7 but Windows 2003.

TIn Windows 2003, If I double click on "C:SendEmail.VBS" in Windows Explorer, it will successfully send the email. However, if I run it with my AutoIT Script(C;SendEmail.Au3), no errors is returned, and no Email is sent either.

I have included my autoit and vbs script code in here. any thoughts??

The VBS Script:

'___________SendEmail.vbs____________________

On Error Resume Next

Set objShell = Wscript.CreateObject("Wscript.Shell")

Dim strEventText

LogFile "Sending an Email Started..........."

sendMail "Site Admin<Administrator@site.com>", admin@site.com, "Testing.....blah blah", "Attention, Your Host blah blah...1403"

' ----- Success exit ------'

WSscript.Quit(0)

' ----- Local Subroutines ------'

Function sendMail(strFrom, strTo, strSubject, strMail)

On Error Resume Next

oMailServer = "myex.site.com"

Set objEmail = CreateObject("CDO.Message") '<--- I think the issue happens here, doesn't create the CDO object.

objEmail.From = strFrom

objEmail.To = strTo

objEmail.Subject = strSubject

objEmail.Textbody = strMail

If strMailFile = 1 Then

objEmail.AddAttachment strAttachment

End If

If Err.Number <> 0 Then

WScript.StdOut.Write "ERROR: Unable to create CD Object." & vbCrLf & "Error Number [" & Err.Number & "]"& vbCrLf & "Error description: [" & Err.Description & "]"

WSscript.Quit(-1)

End If

objEmail.Configuration.Fields.Item _

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

objEmail.Configuration.Fields.Item _

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

oMailServer

objEmail.Configuration.Fields.Item _

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

= 25

objEmail.Configuration.Fields.Update

objEmail.Send

If Err.Number <> 0 Then

WScript.StdOut.Write "ERROR: Unable to send Email." & vbCrLf & "Error Number [" & Err.Number & "]"& vbCrLf & "Error description: [" & Err.Description & "]"

WSscript.Quit(-1)

Else

WScript.StdOut.Write("Sent Email Successfully.") & vbCrLf

End If

End Function

'----------------------- End of SendEmail.VBS -------------------

The SendEmail.Au3

Global $strTaskScriptPath = "C:TempSendEmail.vbs > C:TempSendEmail.log 2>&1"

;Execute The VBS

Local $retStr = RunWait(@ComSpec & " /c " & Chr(34) & $strTaskScriptPath& Chr(34), "C:Temp", @SW_SHOW, $STDERR_CHILD + $STDOUT_CHILD)

Thanks in advance,

MrAutomationGuy

;

Edited by MrAutomationGuy
Link to comment
Share on other sites

Why do you use a VBS? AutoIts builtin function _INetSmtpMail should do the same without the need to use RunWait plus return additional error information.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Good Suggestion, I will try it. But how do you send Attachments with INetSmtpMail? Isn't that just a simple SMTP Mail protocal? unless I'm missing something.

But my question was mostly on using "RunWait" On 2003. Is there any issues with it?

Edited by MrAutomationGuy
Link to comment
Share on other sites

There is a modified version of INetSmtpMail available that lets you send attachments -

I don'tbelieve there is a problem with RunWait on Windows 2003.

@SW_SHOW isn't a valid flag according to the docu. $STDERR_CHILD + $STDOUT_CHILD aren't allowed with RunWait - only with Run.

Could you please try this modified version?

Global $strTaskScriptPath = "C:\Temp\SendEmail.vbs > C:\Temp\SendEmail.log 2>&1"
;Execute The VBS
Local $retStr = RunWait(@ComSpec & " /c " & $strTaskScriptPath, "C:\Temp", @SW_MAXIMIZE)

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

I would open a thread to discuss the issue. I'm not sure if such a thread belongs in the General Help and Support or the Developer Chat forum.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...