anyone willing to help me with a script tonight

[Daferra]

Hi All,

I there someone that will help me with to build a script tonight, its a little script (i think) that needs to do the following:

From a excel list i need to import a two column with email addresses and codes.

After the import a visual list of wat I've imported and a button to do a next action

The next action needs to create a email with the codes and a text messages that can created from within de gui.

This will save me a lot of time tomorrow and maybe even my job.

So any help is welcome,

Greetz

Ferdi

[Daferra]

Ok, this a start i think

The main GUI and a peace of code that i found on this forum thanks to AL3X.

expandcollapse popup

#Include<file.au3>
#include <GUIConstants.au3>
Global $oMyError = ObjEvent("AutoIt.Error", "MyErrFunc")
;##################################
; Include
;##################################
#Include<file.au3>
;##################################
; Variables
;##################################
$s_SmtpServer = "smtp.gmail.com"                ; address for the smtp-server to use - REQUIRED
$s_FromName = "Nombre"                          ; name from who the email was sent
$s_FromAddress = "email@gmail.com"            ;address from where the mail should come
$s_ToAddress = "youremail@gmail.com"            ;destination address of the email - REQUIRED
$s_Subject = "Hi!"                            ;subject from the email - can be anything you want it to be
$as_Body = ""                                   ;the messagebody from the mail - can be left blank but then you get a blank mail
$s_AttachFiles = ""                         ;the file you want to attach- leave blank if not needed
$s_CcAddress = ""                               ;address for cc - leave blank if not needed
$s_BccAddress = ""                            ;address for bcc - leave blank if not needed
$s_Username = "youremail@gmail.com"             ;username for the account used from where the mail gets sent  - Optional (Needed for eg GMail)
$s_Password = "yourpassword"                    ;password for the account used from where the mail gets sent  - Optional (Needed for eg GMail)
$IPPort = 465                                   ;port used for sending the mail
$ssl = 1                                        ;enables/disables secure socket layer sending - put to 1 if using httpS
;~ $IPPort=465                                  ;GMAIL port used for sending the mail
;~ $ssl=1                                   ;GMAILenables/disables secure socket layer sending - put to 1 if using httpS

;##################################
; GUI
;##################################

#Region GUI
$Form1 = GUICreate("Send new codes", 633, 454, 393, 164)
$Edit1 = GUICtrlCreateEdit("", 16, 24, 281, 409)
GUICtrlSetData(-1, "Edit1")
$Edit2 = GUICtrlCreateEdit("", 320, 64, 289, 273)
GUICtrlSetData(-1, "Edit2")
$Label1 = GUICtrlCreateLabel("Text to send with imported codes", 320, 24, 36, 17)
$Import = GUICtrlCreateButton("Import XLS", 328, 400, 81, 33, 0)
$BSend = GUICtrlCreateButton("Send", 424, 400, 73, 33, 0)
GUISetState(@SW_SHOW)
#EndRegion GUI


While 1
    $nMsg = GUIGetMsg()
    Switch $nMsg
        Case $GUI_EVENT_CLOSE
            Exit
        Case $Import
            Exit
        Case $Bsend
            _INetSmtpMailCom()
    EndSwitch
WEnd



;##################################
; Script
;##################################
Global $oMyRet[2]
Global $oMyError = ObjEvent("AutoIt.Error", "MyErrFunc")
$rc = _INetSmtpMailCom($s_SmtpServer, $s_FromName, $s_FromAddress, $s_ToAddress, $s_Subject, $as_Body, $s_AttachFiles, $s_CcAddress, $s_BccAddress, $s_Username, $s_Password, $IPPort, $ssl)
If @error Then
    MsgBox(0, "Error sending message", "Error code:" & @error & "  Rc:" & $rc)
EndIf
;

Func _INetSmtpMailCom($s_SmtpServer, $s_FromName, $s_FromAddress, $s_ToAddress, $s_Subject = "", $as_Body = "", $s_AttachFiles = "", $s_CcAddress = "", $s_BccAddress = "", $s_Username = "", $s_Password = "",$IPPort=25, $ssl=0)
    $objEmail = ObjCreate("CDO.Message")
    $objEmail.From = '"' & $s_FromName & '" <' & $s_FromAddress & '>'
    $objEmail.To = $s_ToAddress
    Local $i_Error = 0
    Local $i_Error_desciption = ""
    If $s_CcAddress <> "" Then $objEmail.Cc = $s_CcAddress
    If $s_BccAddress <> "" Then $objEmail.Bcc = $s_BccAddress
    $objEmail.Subject = $s_Subject
    If StringInStr($as_Body,"<") and StringInStr($as_Body,">") Then
        $objEmail.HTMLBody = $as_Body
    Else
        $objEmail.Textbody = $as_Body & @CRLF
    EndIf
    If $s_AttachFiles <> "" Then
        Local $S_Files2Attach = StringSplit($s_AttachFiles, ";")
        For $x = 1 To $S_Files2Attach[0]
            $S_Files2Attach[$x] = _PathFull ($S_Files2Attach[$x])
            If FileExists($S_Files2Attach[$x]) Then
                $objEmail.AddAttachment ($S_Files2Attach[$x])
            Else
                $i_Error_desciption = $i_Error_desciption & @lf & 'File not found to attach: ' & $S_Files2Attach[$x]
                SetError(1)
                return 0
            EndIf
        Next
    EndIf
    $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
    $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = $s_SmtpServer
    $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = $IPPort
;Authenticated SMTP
    If $s_Username <> "" Then
        $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
        $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusername") = $s_Username
        $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendpassword") = $s_Password
    EndIf
    If $Ssl Then
        $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = True
    EndIf
;Update settings
    $objEmail.Configuration.Fields.Update
; Sent the Message
    $objEmail.Send
    if @error then
        SetError(2)
        return $oMyRet[1]
    EndIf
EndFunc;==>_INetSmtpMailCom
;
;
; Com Error Handler
Func MyErrFunc()
    $HexNumber = Hex($oMyError.number, 8)
    $oMyRet[0] = $HexNumber
    $oMyRet[1] = StringStripWS($oMyError.description,3)
    ConsoleWrite("### COM Error !  Number: " & $HexNumber & "   ScriptLine: " & $oMyError.scriptline & "   Description:" & $oMyRet[1] & @LF)
    SetError(1); something to check for when this function returns
    Return
EndFunc;==>MyErrFunc