Adding all message recipients as Contacts

As a responds to Creating distribution list from email recipients the following question was asked;

Instead of creating a Distribution List, I want to add everyone the message was sent to as a separate contact. Is that possible as well without having to right click each recipient and then choose “Add to Outlook Contacts?

With a few additional steps, you can quite easily create separate contacts from the list of recipients of a message or any existing Distribution List.

Saving every recipient as a separate contact has the added benefit of easily contacting just that specific contact or to use a Mail Merge instead of a Distribution List to contact the entire group while also being able to personalize each email automatically.

Note: Due to completeness, the instructions below may suggest that it is a long and complicated process. In reality, you’ll click through it in about 2-3 minutes (or less than 1 if you’ve had a bit of practice).

Create a Distribution List first
Before you begin, you must first add the recipients to a Distribution List (or Contact Group in Outlook 2010) as discussed in;
Creating distribution list from email recipients

Save the Distribution List as a txt-file
Once you have created the Distribution List, you must save it as a txt-file. This will create a structured file which lets you easily import the members as separate contacts.

  1. Select the Distribution List in your Contacts folder.
  2. Click; File-> Save As…
  3. At the bottom of the Save As dialog, set  the “Save as type” dropdown list to; Text Only (*.txt)
  4. Save the distribution list to the Desktop or another convenient location.

Modify the txt-file
Before you can import the txt-file as contacts, headers must be added and some additional comments need to be removed.

  1. Double click on the saved txt-file to open it in Notepad.
  2. Remove the first few lines which contain the name of the Distribution List/Contact Group and the word “Members”.
  3. Above the first email address type the following;
    Full Name    E-mail Address
  4. Save the file.

Example of modified txt-file.

Import the txt-file
The last step is to import the created txt-file into the Contacts folder.

  1. Open the Import and Export Wizard;
    • Outlook 2007 and previous
      File-> Import and Export…
    • Outlook 2010
      File-> Open-> Import
  2. Select; Import from another program or file
  3. Click Next.
  4. Select; Tab Separated Values (Windows)
  5. Click Next.
  6. Browse to the location of the modified txt-file.
  7. Set your duplicate handler option as you please.
  8. Click Next.
  9. Select the Contact folder you want to import the contacts to.
  10. Click Next.
  11. Select the “Import” checkbox if it hasn’t been selected already.
  12. Press the “Map Custom Fields…” if the dialog doesn’t open automatically already.
  13. In the left column you’ll now see two values; “Full Name” and “E-mail Address”.
    Click on the “Full Name” value and hold down you mouse button. Now move it onto the “Name” field in the right column. Once “Name” gets highlighted, release your mouse button to complete mapping the field.
  14. Repeat the process for the “E-mail Address” value but this time drop it on the “E-mail” field in the right column.
    (this goes easier when you first scroll down to “E-mail” in the right column.
  15. Press OK to close the “Map Custom Fields” dialog.
  16. Press Finish to complete the Import process.

You can use "Drag & Drop" to map the custom fields when importing. (click on image to enlarge)
You can use "Drag & Drop" to map the custom fields when importing.
(click on image to enlarge)

Using an add-in
If you find the above process a bit too long or you need to do this on a regular basis, then using the Add E-mail Address add-in by Sperry Software might come in handy for you (discount code "BH93RF24").
Amongst its feature list is an option to to save all addresses from a message to a Contacts folder of choice with just 1 click.

Use "PFHTO781" to get a discount when ordering!