Can I import an Excel doc into a distribution list?

  • Thread starter Thread starter Ports
  • Start date Start date
P

Ports

I have an Excel doc with names and email addresses. I would like to make
that into an Outlook distribution list. Is that possible? I tried to follow
the import an Excel doc instructions, but to no avail.

Using: Outlook 2003, Excel 2003, Vista
 
You sound very confused. Excel has spreadsheets and Word has Documents. So
start by explaining what you actually have that you want to import to
Outlook. We aren't looking over your shoulder so it's hard to get advice
here without clearly explaining what's going on.

What have you treid so far and exactly what went wrong?

Here are some tips about how to post questions:
http://support.microsoft.com/?id=555375

Regards

Judy Gleeson
MVP Outlook
Trainer and Consultant www.pragmatix.com.au


..
 
Q: "Can I import an Excel doc into a distribution list?"
A. No. There is no facility to import any kind of data to a PDL - Personal
Distribution List (either new or one that exists) in any version of Outlook

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 
This is possible

Hi Ports
I know where you are coming from on this. Follow these steps :-
1. Save the Excel file as a Comma Separated Values File (e.g.list.csv).
2. In Outlook, go to File | Import and Export. Click Next Button
3. Select Import from another program or file. Click Next Button
4. Select Comma Separated Value (Windows) Click Next Button you might be asked to install a program, if it is the 1st time that you used this option.
5. Browse to the location you saved the csv file Select OK and the Select Do import duplicate items.Click Next Button
6. Select the Contacts folder you want to import to (best to create a subfolder for this lesson. Click Next Button
7. Select Map Custom Fields
8. From the left hand pane drag the required fields to the fields into the right hand pane. e.g. email to email address and phone to business phone Click OK Button.
9. Click Finish and the import starts to run
10. Go to the folder that you just imported and select from the drop down arrow to the right hand side of new and select Distribution List
11. Click Select Members button
12. From the "Show Names From the" drop down list - Select the address list that you importer to.
13. Hold Shift button, and hold the down arrow to select all Click OK and Name the list and save and close
That should be the routine, any queries leave me a reply here.

Daxion
 
Last edited:
Back
Top