How can I make the members of a distribution list into contacts?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gcarls - 08 Sep 2004 04:17 GMT

I made up distribution lists for Outlook by importing names and email
addresses. I gather that I should have started by making individual
"Contact" files for each. Now I have a set of DL's whose members I would
like to make into individual contacts. Can't I get Outlook to do that for
me? How? I would appreciate help.

Reply to this Message

Russ Valentine [MVP-Outlook] - 08 Sep 2004 11:19 GMT

Save the DL in RTF format. Use Word to convert it to a plain text file and
Excel to convert that to a CSV file. Make sure the file has clear headers
that Outlook can recognize as Field Names, then import it into Outlook.

Signature

Russ Valentine
[MVP-Outlook]

>I made up distribution lists for Outlook by importing names and email
> addresses. I gather that I should have started by making individual
> "Contact" files for each. Now I have a set of DL's whose members I would
> like to make into individual contacts. Can't I get Outlook to do that for
> me? How? I would appreciate help.

Reply to this Message

Sue Mosher [MVP-Outlook] - 08 Sep 2004 14:08 GMT

Easier -- save it as a plain text file, then edit it in Notepad to remove
the first few lines that contain the DL name and description. Save and
import as a tab-delimited file.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Save the DL in RTF format. Use Word to convert it to a plain text file and
> Excel to convert that to a CSV file. Make sure the file has clear headers
[quoted text clipped - 5 lines]
>> for
>> me? How? I would appreciate help.

Reply to this Message

Russ Valentine [MVP-Outlook] - 08 Sep 2004 21:05 GMT

Both methods are pretty convoluted if you ask me ;)

Signature

Russ Valentine
[MVP-Outlook]

> Easier -- save it as a plain text file, then edit it in Notepad to remove
> the first few lines that contain the DL name and description. Save and
[quoted text clipped - 11 lines]
>>> for
>>> me? How? I would appreciate help.

Reply to this Message