Very Simple Script that I can not fugure out

[JayT]

Extreme Noob! Please help me. I am trying to do the simplest thing with Autoit and can not find any help or create the script myself. Here is what I need: I have 500 users that need to have a second email account added to there outlook 2010 client. What I wanted the scrip to do was have the users enter there username into a input box then it will do a search from the "master" excel file and if there name was found it autopopulate the information into outlook with password then delete the cell in the excel file. Here is what I wrote (please be nice)Any help would be very much appreciated. Please remember I am sooo not a programer but need this for work ASAP. Search.au3

[wraithdu]

General Help and Support forum is for you.

[CodyBarrett]

i agree, wrong forum section. maybe the mods will move this topic?

[jaberwacky]

I cleaned up the syntax errors and added some error detecting code. Run it and see what it says.

#include <Excel.au3>
#include <Array.au3>

$sFilePath1 = "C:\DOT.xls"

$oExcel = _ExcelBookOpen($sFilePath1)

If Not $oExcel Then
    MsgBox( 32 , "@error: " & @error , "_ExcelBookOpen() FAIL" )
    Exit
EndIf

$Select_Col = 1

$sCellValue = _ExcelReadCell($oExcel, $Select_Col)

If Not $sCellValue Then
    MsgBox( 32 , "@error: " & @error , "_ExcelReadCell() FAIL" )
    Exit
EndIf

$sSearch = InputBox("Enter name:", "find Name")

If $sCellValue = $sSearch Then
    MsgBox(0, "GAOL", "Name Found")
Else
    MsgBox(0, "FAIL", "Name Not Found")
    Exit
EndIf