ILL Contact Lookup Spreadsheets
These Excel spreadsheets allow users to enter basic information for an ILL request, including the 4-digit HSA code(s) for the potential lender(s), and then click a single button to create an email to the lender(s).
1. The following spreadsheet accepts multiple library HSA codes so a single ILL request can be sent to multiple recipients with one click:
The spreadsheet relies on a macro to do its work, so you’ll probably see a security warning when you open the file. It’s safe to click Enable Macros. Depending on your security settings, however, you may need an Administrator to do this.
2. For those for whom the macro results in security warnings that you’re not able to work around, I’ve created a macro-free version as well available here:
Owing to limitations with Excel’s hyperlink function, this is not a multiple-recipient version. Note, too, that the function crashes if you try to cram too much text into an email. Accordingly, the formatting of the email is bare bones & you may have to eliminate characters, use abbreviations, etc. before the hyperlink function works properly.
If you use Gmail & the spreadsheets aren’t opening, either of these fixes should work:
1. http://support.google.com/mail/bin/answer.py?hl=en&answer=10966 (installs Google Notifier on systems other than Vista)
2. http://lifehacker.com/5883372/set-gmail-as-your-browsers-default-email-client-with-a-simple-hack (Google Chrome hack)
If email addresses need to be corrected, feel free to do this on Sheet2 of either spreadsheet, and to correct them for everyone else with the State Library (firstname.lastname@example.org) and here:
Any questions about the spreadsheets should be directed to:
NHLA IT Section
Plaistow Public Library