Jump to content
Sign in to follow this  
JenniferMurphy

Considering AutoIt, application questions

Recommended Posts

JenniferMurphy

Hi,

I am looking for a way to automate a bunch of routine tasks that I have to deal with frequently. I am hoping that someone here can tell me if these are appropriate applications for AutoIt. I have many such tasks, but will only bother you with a couple of representative ones.

Attaching Emails to a Case. I get a hige number of emails from clients. I have a case management program that has an Outlook module that will allow me to "attachg" the emails to the appropriate case. The problem is it requires several steps to complete the task and these have to be repeated for each email. I am working on a case today that has over 300 emails messages. It it only takes me 10 seconds for each email, it will take nearly an hour to attach them all and that assumes that I don't make any mistakes.

I'd like to be able to invoke a script, have it ask me for the case name, and then have it attach all of the emails in the current Outlook folder to that case, then move the emails to a different Outlook folder. Ideally, it would go to the case management program and let me select the case from the case list first.

Save Statements from Email Attachments. I get a lot of statements from various clubs, associations, and other institutions. I would like to be able to run a script that would save the attachments in the appropriate folder and assign a file name in accordance with my usual naming convention.

Archive VBA Modules. I have a bunch of VBA modules for Word and Excel. I like to archive them from time to time. I'd like a script that would handle the task of executing the Export function from the VBA IDE for each active module assigning each one a custom name according to a naming convention I use.

Make Backup Copies of Files. I have a practice of making dated backup copies of important files and documents (versions) before making major changes. I typically make a copy, then edit the copy to remove the "Copy of " added by Windows and add the date. Sometimes I also move them to a separate folder (Old) so they don't clutter up the production folder. It would be helpful to be able to have a keyboard shortcut (Ctrl-B or Ctrl-V) that would do the whole process in a single step.

Are these the types of tasks that AutoIt can handle?


I am using Office 2007 on Windows XP.

Share this post


Link to post
Share on other sites
JenniferMurphy

Nice, concise answer. I love it. :thumbsup:

Thanks for the tutorial. I'll give it a shot.


I am using Office 2007 on Windows XP.

Share this post


Link to post
Share on other sites
JohnOne

I don't know anything about outlook, but I know AutoIt3 can work nicely with it from topics past.

Next, you should start a few basic scripts to test things.

If you need help, be as clear and thorough as you can with your specific problems, and always accompany with your code.


AutoIt Absolute Beginners    Require a serial    Pause Script    Video Tutorials by Morthawt   ipify 

Monkey's are, like, natures humans.

Share this post


Link to post
Share on other sites
water

I think points 1 & 2 can be solved using my OutlookEX UDF (for download please check my signature).


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-01-27 - Version 1.3.3.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
JenniferMurphy

I don't know anything about outlook, but I know AutoIt3 can work nicely with it from topics past.

Next, you should start a few basic scripts to test things.

If you need help, be as clear and thorough as you can with your specific problems, and always accompany with your code.

 

Just finished installing AutoIt and the editor and reading your Absolute Beginner tutorial. It was certainly accurately named. :) I found the tutorial page, so I'm off to read a few and try some things. Thanks.


I am using Office 2007 on Windows XP.

Share this post


Link to post
Share on other sites
JenniferMurphy

I think points 1 & 2 can be solved using my OutlookEX UDF (for download please check my signature).

 

Thanks. I'm going to get my hands dirty with a few simple scripts, then I'll check out your code.


I am using Office 2007 on Windows XP.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×