Solved

Extract address from a distribution list to the contacts folder

Posted on 2006-11-22
8
1,723 Views
Last Modified: 2008-03-10
I have imported a (.pst) file that contains one distribution list of contacts into outlook 2003. I would like to extract all the entries and put them in the contacts folder individually, as opposed to just putting in the one entry for the distribution list. Is there a way to get the contacts out of the distribution list and into the contacts folder?
0
Comment
Question by:freedom22
  • 3
  • 3
  • 2
8 Comments
 
LVL 97

Expert Comment

by:war1
Comment Utility
Greetings, freedom22 !

Save the DL as a text file. Open it in Notepad to remove the few lines at the top that are not names and addresses. Import into Oultook as a tab-delimited text file.

Best wishes!
0
 

Author Comment

by:freedom22
Comment Utility
Thanks for your quick reply. I was able to save the DL as a text file. It has two columns: the first one has the person's name and the second column has the email address.

However, when I try to import it as a tab delimited file, i can browse to it, but then the "next" button is greyed out when i try to proceed with the import, so I can't import it.

Any ideas?

Thanks
Mark
0
 
LVL 97

Expert Comment

by:war1
Comment Utility
freedom22,

Change the text file extension to .csv and see if you can import the data as tab deliminated or comma separated value.

If no joy, copy the distribution list to an Excel spreadsheet. Save it as a CSV file. Then import the comma separated value file into Outlook contacts list.
0
 
LVL 18

Expert Comment

by:meintsi
Comment Utility
Why the hard way?

Simply send an email to youself with distribution list as an attachment. (INSERT - ITEM)
(This option will not be availible if you are using Word as your editior - turn it off)

Then, open the email, double click the attachment, and select FILE - COPY TO FOLDER.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:freedom22
Comment Utility
this is to war1 and meintsi.

I tried both of your techniques but I couldn't get either to work.
war1: I tried changing the text file extension to csv and I still couldn't get past that point in the dialog box that I mentioned earlier. The "next" button is greyed out. I also tried opening the file as an excel worksheet and saving it as an xls file. Still I could not get past the critical point.

meintsi:
When I send the email to myself, I double click the attachment and I get the list of names/email addresses. However, when I try to copy them to another folder, e.g., my Contacts folder, it just copies in the DL, and not the individual names.


0
 
LVL 97

Accepted Solution

by:
war1 earned 500 total points
Comment Utility
>> I also tried opening the file as an excel worksheet and saving it as an xls file. Still I could not >> get past the critical point.

Save the file as a CSV file. Then choose to import the contacts from comma, separated value file. Go to File > Import and Export > Import from another program or file. Select "Comma Separated Values (Windows)" and hit Next. You may need to install this feature if not installed.
0
 
LVL 18

Expert Comment

by:meintsi
Comment Utility
Forgot the last step.

Yes. The Dl should be added to your contacts.
Now double-click each name and a 'Properties' dialog box will appear where you can select "Add to contacts"

This probally can be done programmatically if the list is really large.
0
 

Author Comment

by:freedom22
Comment Utility
More responses: (Still not solved)

war1: I have saved the file as a CSV and went through the import steps. I select "Comma Separated Values (Windows)" and hit Next. but then when i get to the "Import this file" dialog box, the "Next" button is still greyed out. (Is there a feature that I have to install that I am missing?)

meintsi: When I double click each name, the "Add to Contacts" box does NOT appear. It DOES appear if I click the button to "Add a new contact" but not for the existing entries in the list.

Mark
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Granting full access permission allows users to access mailboxes present in their database. By giving full access permission one can open and read the content of any mailbox but cannot send emails from that mailbox.
Sometimes Outlook might have problems sending a message. There may be various causes- corrupted PST, AV scanner etc. The message, instead of going to the Sent Items folder, sits in the Outbox indefinitely. To remove it you can use a free tool cal…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now