JayT Posted April 27, 2011 Share Posted April 27, 2011 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 Link to comment Share on other sites More sharing options...
wraithdu Posted April 27, 2011 Share Posted April 27, 2011 General Help and Support forum is for you. Link to comment Share on other sites More sharing options...
CodyBarrett Posted April 27, 2011 Share Posted April 27, 2011 i agree, wrong forum section. maybe the mods will move this topic? [size="1"][font="Tahoma"][COMPLETED]-----[FAILED]-----[ONGOING]VolumeControl|Binary Converter|CPU Usage| Mouse Wrap |WinHide|Word Scrammbler|LOCKER|SCREEN FREEZE|Decisions Decisions|Version UDF|Recast Desktop Mask|TCP Multiclient EXAMPLE|BTCP|LANCR|UDP serverless|AIOCR|OECR|Recast Messenger|AU3C|Tik-Tak-Toe|Snakes & Ladders|BattleShips|TRON|SNAKE_____________________[u]I love the Helpfile it is my best friend.[/u][/font][/size] Link to comment Share on other sites More sharing options...
jaberwacky Posted April 28, 2011 Share Posted April 28, 2011 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 Helpful Posts and Websites: AutoIt3 Variables and Function Parameters MHz | AutoIt Wiki | Using the GUIToolTip UDF BrewManNH | Can't find what you're looking for on the Forum? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now