DiabolicNerd Posted November 5, 2010 Share 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) Link to comment Share on other sites More sharing options...
Necromorph Posted November 5, 2010 Share 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. Link to comment Share on other sites More sharing options...
iamtheky Posted November 5, 2010 Share Posted November 5, 2010 the outlook UDF may be helpful as well ,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-. |(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/ (_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_) | | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) ( | | | | |)| | \ / | | | | | |)| | `--. | |) \ | | `-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_| '-' '-' (__) (__) (_) (__) Link to comment Share on other sites More sharing options...
DiabolicNerd Posted November 5, 2010 Author Share 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 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