> From: Code for Libraries [mailto:[log in to unmask]] On Behalf Of
> Jill Ellern
> Sent: Monday, May 18, 2009 3:52 PM
> To: [log in to unmask]
> Subject: [CODE4LIB] A simple windows macro program?
> 
> Hey Code4Lib folks,
> 
> Not sure if there are any Clio ILL software users in the Code4Lib
> group...but we are interested in getting Clio to pull emails from the
> ClioAdvanced email more often.  We are thinking there must be a windows
> macro/scripting program on top of Clio (which is an MS Access
> application for those not familiar with it) would be the best idea.
> Right now, it needs human intervention to run the menu option to pop
> these requests into Clio...and they only do it once or twice a day.  We
> want this menu option in Clio to run every 15-20 minutes all day.
> However, we are not familiar with what programs are out there that
> would be good to look at.  Can you folks make a suggestion?  Has anyone
> done this already with Clio?

I'm not familiar with Clio, but have used MS Access extensively over
the years.  It is quite possible, since Clio is using MS Access that
they have VBA macros to accomplish various tasks.  If the macros are
not encrypted, you might be able to modify them to suit your needs.

Alternately, you could write a VB.NET or C# application that uses 
ADO.NET to open the Clio MS Access database every 15-20 minutes pull 
the information from ADO.NET and push it to your e-mail solution.  
Microsoft Express tools, e.g., VB.NET Express, C# Express, etc. can 
be freely downloaded and used.


Hope this helps, Andy.