Automating the collection of Reports from Remedy

I am trying to automate the collection of remedy reports. I have already created a macro in remedy to collect the data and export it to 4 different files.

Then I use a windows script to combine all 4 files into one report.

Finally I post this report to an email and send it. I need to do this everyday. Is there anyway to automate this process?
bbcacAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

souseranCommented:
Can you use Windows Task Scheduler? Assuming you're in Windows XP, see this Microsoft article:

How To Schedule Tasks in Windows XP

http://support.microsoft.com/kb/308569
0
souseranCommented:
You could use a "mailto" URL like the following, to open an e-mail window with a file attached:

mailto:recipient@location.net?subject="remedy report"&body="see attachment"&attachment="\\servert\folder\remedyreportfile.ext"

Within the email client, set up a rule, filter, or whatever, to auto-send messages with recipient@location.net in the To line.
0
bbcacAuthor Commented:
My first hurdle is to some how automate the running of the macro... I have to be in remedy and choose Tools > Macro > and then the appropriate macro... is there anyway to do that?
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

souseranCommented:
For that part, you'll want a Windows Macro Recorder utility like AutoIt:

http://www.nonags.com/nonags/auto.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bbcacAuthor Commented:
I am trying to figure out how to use AutoIt. When I do I will let you know if this will work.

With AutoIt do the simulated mouse clicks always click the same spot on the screen, or is it smart enough to see what application window you are choosing?

0
bbcacAuthor Commented:
AutoIt works fine now. My issue is this. What if I want the task to run while the computer is locked? I don't want to have to log in manually to the server every day. The goal is to automate the report production
0
bbcacAuthor Commented:
Works great
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.