Learn IT

Updating Outlook Groups from Excel Lists

Question: I created contact groups some time ago with around 100 names each, since Outlook won’t allow personal group with 300 names (1A, 1B, 1C) I keep the master list in Excel but it has been quite a long time since I updated the groups, and I can’t remember how I can get them updated.

Answer: The easiest way to do this is to have your Excel list open, along with your Outlook contacts.

  1. Open the first group 1A, and remove the names (use Ctrl or Shift keys to select more than one at a time).
  2. In Excel, click and drag the list of email addresses that you plan to include in 1A, and copy (Ctrl C).
  3. Go to your Outlook group and select Add members …from Address Book, and then in the Members field at the bottom of the window, paste (Ctrl V) and click okay. It may appear that the list doesn’t match, because Outlook will probably sort by email address.
  4. Continue this for the remaining groups you need to set up.

Leave a Reply