Lars Nielsen's Discoveries

May 1, 2012

Easy way to move, copy or add bulk multiple accounts in SharePoint groups

Filed under: Administration,SharePoint — Lars Nielsen @ 7:10 pm
Tags: ,

Have you ever wanted to work with a bunch of users in a SharePoint group? For example:

  • Move multiple users from one SharePoint group to another?
  • Export the details of users within a SharePoint group?
  • Get a list of accounts to populate a SharePoint group?

Here’s an easy way to work with the members of a SharePoint group in bulk. Suppose for example you want to move or copy a load of users from one group to another, if you have Outlook 2007 or higher.

First browse to the membership of the SharePoint group in Site Settings – People and Groups.

Then click the “Select All” checkbox on the top left. Or select the users you want.

Select Actions – Email Selected Users

Email Selected Users

Outlook will open a new e-mail message with the e-mail addresses of those accounts you selected.

Outlook Message

Copy the e-mail addresses in the Send To text area and paste them into Notepad

Close the new e-mail message (don’t send it!!)

Browse to the SharePoint group that you want to add those users into

Select New – Add Users

In the text area paste the e-mail addresses you copied from the Outlook message

Add New Users

Click the “Check Names” icon and they should all resolve to actual AD accounts

Resolve New Users

Click OK and the users will be added to the group.

This is a great way to harvest a list of accounts for membership of a group.  If you’ve ever asked customers or colleagues to send you a list of people who should be made members of a group, what do you get?  An e-mail with a list of people names, nicknames, shortened names…   And what’s the betting that those names translate to 3 people in your corporate AD with the same name and you can’t work out which one it is?  Or it’s “William” instead of “Bill”, etc.

Solve all those problems by asking your customer to create an e-mail message with all the appropriate people in the “To” box, copy the e-mail addresses out of the box, and paste them into the body of an e-mail.  Then all you need to do is to copy and paste the list of e-mail addresses into the Add Users box as above.



  1. Thank you! Found this very useful =)

    Comment by Joe — August 26, 2013 @ 6:00 pm

  2. Hello,

    I’m being told by our IS_SharePoint team that Microsoft has removed the ‘copy-and-paste’ functionality from SharePoint 2013. I was able to copy and paste to 2007, but trying to do the same thing in 2013 results in ONE name (the first name in the list I’ve copied) being pasted. That has to be done via CTRL-V as the PASTE option is greyed out. There are no AD groups for the people I have to add, and I can’t believe that the solution would be to add users one-by-one. Is there a better way to do it?



    Comment by Mike Kimmel — January 19, 2017 @ 6:56 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a free website or blog at

%d bloggers like this: