ITS

The Information Technology Section of NHLA
  • About ITS
    • Meeting Minutes
  • Resources
    • ILL Contacts Spreadsheets
  • Join ITS Listserv
  • NHLA home

ILL Contacts Spreadsheets

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:

https://docs.google.com/open?id=0B0Mjzn_MpwTlNEYwRlVHbFQwLW8

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:

https://docs.google.com/open?id=0B0Mjzn_MpwTlaE1GcERQY0t3MUU

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 (nhu-pac@dcr.nh.gov) and here:

https://docs.google.com/spreadsheet/ccc?key=0AkMjzn_MpwTldHkteXo4Q19TVjhYTEJ0UFhCdWE0ZWc

Any questions about the spreadsheets should be directed to:

Cab Vinton
NHLA IT Section
Plaistow Public Library
Plaistow, NH

Contact ITS

Kate Thomas, ITS President


Mailing Address:
New Hampshire Library Association - ITS
c/o New Hampshire State Library
20 Park Street
Concord, NH 03301-6314

ITS Calendar

February 9, 2021
  • NHLA Executive Board Meeting

    February 9, 2021  7:00 pm - 9:00 pm
    NH Local Government Center, 25 Triangle Park Drive, Concord, NH 03301, United States

    See more details

Copyright © 2021 · Refined theme by Restored 316