Extract DL members to individual contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Judy F - 05 Nov 2007 21:31 GMT

We have a distribution list that consists of all employees. They are not in
the Contacts folder as an individual. As new employees are hired, they would
like to not only use the DL, but also enter each employee individually in
their Contacts folder. Can you think of a way to extract members from a
distribution list to add to Contacts? Is there another way to share a group
of individuals' name & e-mail addresses without a distribution list?

Thank you.

Reply to this Message

Russ Valentine [MVP-Outlook] - 05 Nov 2007 23:20 GMT

Save the DL as RTF, convert to CSV, and import.

Signature

Russ Valentine
[MVP-Outlook]

> We have a distribution list that consists of all employees. They are not
> in
[quoted text clipped - 7 lines]
>
> Thank you.

Reply to this Message

Brian Tillman - 06 Nov 2007 13:29 GMT

> We have a distribution list that consists of all employees. They are
> not in the Contacts folder as an individual. As new employees are
[quoted text clipped - 3 lines]
> Is there another way to share a group of individuals' name & e-mail
> addresses without a distribution list?

Open the DL and click File>Save As. Choose "Text" as the save-as type.
This will create a Tab Separated Values file. Use Excel to change that to a
CSV and import that.

Signature

Brian Tillman [MVP-Outlook]

Reply to this Message

Judy F - 06 Nov 2007 17:28 GMT

Thank you Brian. I did as you suggested and have a .csv file of the DL in
Excel. Closed Excel, went into Outlook and clicked File - Import & Export.
Choose Import from another program or file, then selected Comma Separated
Values (Windows) as the file type to import from, then choose the .csv file
in Excel to import from (allow duplicates to be created). Under Select
destination folder, I clicked on Contacts. When the Import a File dialog box
appears, "Next" is grayed out so I am unable to complete the import. Any
thoughts about where I went wrong? Thanks for your help.

Judy

> > We have a distribution list that consists of all employees. They are
> > not in the Contacts folder as an individual. As new employees are
[quoted text clipped - 7 lines]
> This will create a Tab Separated Values file. Use Excel to change that to a
> CSV and import that.

Reply to this Message

Brian Tillman - 06 Nov 2007 22:09 GMT

> Thank you Brian. I did as you suggested and have a .csv file of the
> DL in Excel. Closed Excel, went into Outlook and clicked File -
[quoted text clipped - 5 lines]
> "Next" is grayed out so I am unable to complete the import. Any
> thoughts about where I went wrong?

Sorry, no. I tried it myself and it worked fine. When you converted it to
CSV in Excel, did you remove the top rows that did not contain name/address
pairs before saving?

Signature

Brian Tillman [MVP-Outlook]

Reply to this Message