Extract DL members to individual contacts

[Guest]

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.

 

[Russ Valentine [MVP-Outlook]]

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

 

[Brian Tillman]

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?

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.

 

[Guest]

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

 

[Brian Tillman]

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?

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?