cargonsa.blogg.se

$Username = "" username for the account used from where the mail gets sent - REQUIRED $Importance = "High" Send message priority: "High", "Normal", "Low" $BccAddress = "" address for bcc - leave blank if not needed

$CcAddress = "" address for cc - leave blank if not needed $AttachFiles = "" the file(s) you want to attach seperated with a (Semicolon) - leave blank if not needed $Body = "File not found!" the messagebody from the mail - can be left blank but then you get a blank mail $Subject = "File not found" subject from the email - can be anything you want it to be $ToAddress = destination address of the email - REQUIRED, use commas (,) to add more email addresses $FromAddress = address from where the mail should come $FromName = "Hermes" name from who the email was sent $SmtpServer = "" address for the smtp-server to use - REQUIRED $aArray1 = _WD_ElementAction($sSession, $aArray1, 'text') _WD_WaitElement($sSession, $_WD_LOCATOR_ByXPath, $sElement = _WD_FindElement($sSession, $_WD_LOCATOR_ByXPath, ("mat-table " & $sElement & $aArray1 = _WD_FindElement($sSession, $_WD_LOCATOR_ByXPath, $sElement, True) $sSession = _WD_CreateSession($sDesiredCapabilities)

It will continue to read from the excel file and do the same thing for all the remaining rows. Hello, the script below will read column A from an excel file - and if a value matches in the browser, it will click the corresponding link and click on a specific button to paste the data, then writes "Completed" in Column B.