Convert distribution list to individual contacts

  • Thread starter Thread starter MemaV
  • Start date Start date
M

MemaV

My husband made a distribution list but didn't choose "add to contacts list"
for each entry. Now he wants to convert the list to individual contacts. I
can't seem to figure out how to do that.
 
My husband made a distribution list but didn't choose "add to contacts list"
for each entry. Now he wants to convert the list to individual contacts. I
can't seem to figure out how to do that.
Click to expand...

Ther's no quick way to do that.

The way I'd do it would be to save the DL as a "Text Only" file, which would
create a tab-separated values file, open that file in Excel, remove the lines
above the name/address pairs, split the first column into separate columns for
first and last name, add a row with the column headers "FirstName",
"LastName", and "EmailAddress" above the appropriate columns, save it as a
comma-separated values file (csv), then import that into Outlook with
FIle>Import and Export>Import from another program or file.
 
I thought I followed the instructions to the letter, but the email addresses
did not populate. Not a problem, however, and thanks for the advice. It was
very useful.
Jim
 
Back
Top