4CE53030-CF0C-67E7-7D845E0B5CDEC0DD
A2C9AD92-AE26-5B0A-34EFE7D56325B918

We encourage you to contact us with any questions or concerns.

Burke Library - 3rd Floor
helpdesk@hamilton.edu

859-4181
859-4185 - fax

Creating Email Lists from the Hamilton College Directory

  1. Navigate to the  Hamilton College Directory (http://www.hamilton.edu/search/directory), choose Full Directory, and select whether you are interested in Students, Employees or the Entire Community.
  2. Type the text you wish to search on in the Enter search text field.
  3.  When the list comes up, click on Export.
  4. Open the exported file in Excel.
  5. Look through the fields you have, and delete any "extra" entries.
  6. Create a column, such as Full Address to hold the email address that you will actually use when you email this group of people.
  7.  Use the Excel concatenate function to merge the username with "@hamilton.edu" to create the full address. Here is an example: "=CONCATENATE(F2,"@hamilton.edu")
  8. Use Autofill to copy the function into all the cells in the column by dragging the small dot in the lower right of the cell through all the lower cells.
  9.  Be sure to save this file before continuing.
  10.  Next, copy the Full Address column, and paste it into the To: field of your HillConnect email message.
  11. Click on the Subject field to have HillConnect email automatically comma-separate the list.

Comments

No comments yet.

Cupola