DiabolicNerd 0 Posted November 5, 2010 I work on a helpdesk, when service or incident e-mails come in we have to manually create incident tickets in a system known as "Frontrange." I'm trying to eliminate as much manual labor as possible by utilizing AutoIT to extract information from incoming e-mails and enter the data into the Frontrange system. I've very new to AutoIT and really the only thing I can think of is creating a macro to perform some basic mouse clicks, drags, and copying and pasting data. Anyone have any suggestions? Experience with this? Here's what I have so far...it works but..i'm wondering if theres a more efficient way of doing things. expandcollapse popup;Open Outlook WinActivate ( "Inbox - Microsoft Outlook") ;Highlight e-mail subject MouseClick ( "left", 766, 125, 3, 0 ) Sleep (1000) ;Copy the e-mail subject Send("^c") Sleep (1000) ;Open ITSM Window WinActivate ( "FRS Application") Sleep (1000) ;Create a new Incident MouseClick("left", 122, 62, 1, 0) Sleep (5000) ;Select the Summary field to insert e-mail subject and priority MouseClick("left", 369, 325, 1, 0) Sleep (1000) ;Default to priority 2 Send("2 - ") Sleep (1000) ;Begin pasting MouseClick("left", 375, 325, 1, 0) Sleep (1000) ;Paste Send("^v") Sleep (1000) ;Back to Outlook WinActivate ( "Inbox - Microsoft Outlook") Sleep (1000) ;Select e-mail body text MouseClickDrag("left", 1454, 977, 772, 243) Sleep (1000) ;Copy highlighted text Send ("^c") Sleep (1000) ;Back to ITSM WinActivate ( "FRS Application") Sleep (1000) ;Select description MouseClick ( "left", 379, 369, 1, 0) Sleep (1000) ;Paste e-mail contents Send ("^v") Sleep (1000) ;Select source MouseClick ( "left", 324, 433, 1, 0) Sleep (1000) ;Select e-mail MouseClick ( "left", 171, 461, 1, 0) Sleep (1000) ;Select type incident MouseClick ( "left", 325, 291, 1, 0) Sleep (500) ;Select type incident MouseClick ( "left", 158, 305, 1, 0) Share this post Link to post Share on other sites
Necromorph 1 Posted November 5, 2010 Have you tried uising the "AutoIt Window Info" tool to get better ctrl info? then you can use $hText = GUICtrlRead($hCtrl) and then ControlSetText($sCtrl, $hText) just so you don't have to do "mouseclick", and "Send" to do you actions. just a thought. Share this post Link to post Share on other sites
iamtheky 927 Posted November 5, 2010 the outlook UDF may be helpful as well ,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-. |(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/ (_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_) | | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) ( | | | | |)| | \ / | | | | | |)| | `--. | |) \ | | `-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_| '-' '-' (__) (__) (_) (__) Share this post Link to post Share on other sites
DiabolicNerd 0 Posted November 5, 2010 Thanks for the speedy responses guys Let me go ahead and do my research on what you've provided and see what I can come up with and put togther. I knew there would be a better way. I couldn't share this with my co-workers either becuase their resolution and X Y coordinates would more then likely be off. Thanks again, any more suggestions, tips are welcome Share this post Link to post Share on other sites
