Using Excel to Create an Email List from Rutgers NetIDs - Canvas

As of this evening, Friday, May 8, Canvas is accessible to Rutgers users. OIT will continue to monitor closely as we work to restore our normal operations following the Canvas global outage. If you have any questions or concerns, please call 833-OIT-HELP and choose option 7.

View IT Alert
Skip to main content

Using Excel to Create an Email List from Rutgers NetIDs

Emails sent to Rutgers faculty, staff, or students with the format netid@rutgers.edu will be delivered to their delivery address, regardless of whether they receive email in ScarletMail or Rutgers Connect. To quickly create a list of email addresses, you can use your Rutgers roster. 

  1. Download the class roster with emails from REGIS.
  2. Copy the NetID column to a new worksheet.
  3. In column B, type = to begin a formula. Do not press the Enter key so the cell remains active.
    MS Excell cell with an equal sign
  4. Click the cell with the first netid using your mouse.  This is cell A2 in this example. Your formula will update to =A2. Do not press Enter to keep the cell active.
    MSExcel cell with an equal sign and refence to the neighboring cell in ii as =A2
  5. Type &”@rutgers.edu”.

    MS Excel cell with netid highlighted in Blue. in cell =A2&"@rutgers.edu" with A2 in blue

  6. Press the enter key.
  7. With your mouse, hover over the lower-right corner of the cell so your cursor turns into a cross.
    ms excel with mouse cross hair at lower right corner
  8. Drag down to fill the formula into the adjacent cells. The column will contain email addresses in the netid@rutgers.edu format.
    spreadsheet with netid in column a and email addresses as netid@rutgers.edu in column b
  9. You may now copy and paste the email addresses into your email program.
    email addresses in to field