Automate Helpdesk Software

[DiabolicNerd]

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)

[Necromorph]

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.

[iamtheky]

the outlook UDF may be helpful as well

[DiabolicNerd]

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