Only Administrators in MCR can add New Members. 


When you have a large group of New Members to add to MCR it is easier and more accurate to add those Members from an existing list you have such as pulling from a recruitment tool or a list distributed from the Fraternity and Sorority Life Office. 


Adding New Members into MCR is as simple as copy and pasting, but you will need to do these few additional steps to create a column of data in your spreadsheet that can simply be pasted into MCR. 


The spreadsheet you download will look something like this:

 


You will need to follow these simple steps to input data for MCR: 


  1. Delete the header row that labels the columns of data and any additional columns of data other than Member name and email address. 

    1. For spreadsheets with first and last name in the same column:  

      1. In the first row of data, in a new column, copy and paste the following formula and press “Enter”  

        1. =A1&"  "&B1&","


    1. For spreadsheets with first and last name in separate columns use this formula: 

      1. In the first row of data, in a new column, copy and paste the following formula and press “Enter”  

        1. =A1&" "&B1&" "&C1&","


  1. You should have a new column with the Members first and last Name followed by their email address and a comma 

  1. Copy (Command C) the cell with the information you just created 

  1. Select the blank cells in the column next to remaining names and press paste (Command V)



  2. Each row will have translated the data from each line to have your Members First & Last Name followed by their email address and a comma

  3. Delete the comma from the last row next to the Members name (this insures your data copy & pastes correctly)





  4. Copy this newly created column and follow the directions here to add these New Members to MCR!