|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
October 5th 06, 02:18 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
import xls or csv into new Dist List
I need to import a 500 item list which I have as a xls and csv file
into a Distribution List and not the general Contacts address book. If I try as a xls file, it asks for a range. I read the help file but it makes no sense. If I try with a csv file, I have to Map before the import will happen but nothing coincides. My excel file has 4 columns, first name, middle initial, last name, email address. How do I do the above? 
|
| Ads |
|
#2
October 5th 06, 02:46 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
import xls or csv into new Dist List
You can't, and I don't see why you would want to. The chances of being able
to maintain and use a DL of 500 members are next to 0. Import the entries into your Contacts Folder and then use a reliable way to group those Contacts, such as categories or a separate Contacts subfolders. -- Russ Valentine [MVP-Outlook] "Scott" wrote in message ... I need to import a 500 item list which I have as a xls and csv file into a Distribution List and not the general Contacts address book. If I try as a xls file, it asks for a range. I read the help file but it makes no sense. If I try with a csv file, I have to Map before the import will happen but nothing coincides. My excel file has 4 columns, first name, middle initial, last name, email address. How do I do the above?
|
|
#3
October 5th 06, 04:33 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
import xls or csv into new Dist List
Scott wrote:
I need to import a 500 item list which I have as a xls and csv file into a Distribution List and not the general Contacts address book. No need to ask more than once. -- Brian Tillman
|
|
#4
October 5th 06, 01:22 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
import xls or csv into new Dist List
Ok, but how do you make a separate contacts sub folder?
Is that something you can do with the Outlook Address book or in the Folders view where you see Contacts, you click on the Contacts folder and make a new folder underneath it? On Wed, 4 Oct 2006 20:46:23 -0400, "Russ Valentine [MVP-Outlook]" wrote: You can't, and I don't see why you would want to. The chances of being able to maintain and use a DL of 500 members are next to 0. Import the entries into your Contacts Folder and then use a reliable way to group those Contacts, such as categories or a separate Contacts subfolders.
|
|
#5
October 5th 06, 08:55 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
import xls or csv into new Dist List
Never do anything in the Address Book view. Always use Contacts Folder view.
File New Folder.... -- Russ Valentine [MVP-Outlook] "Scott" wrote in message ... Ok, but how do you make a separate contacts sub folder? Is that something you can do with the Outlook Address book or in the Folders view where you see Contacts, you click on the Contacts folder and make a new folder underneath it? On Wed, 4 Oct 2006 20:46:23 -0400, "Russ Valentine [MVP-Outlook]" wrote: You can't, and I don't see why you would want to. The chances of being able to maintain and use a DL of 500 members are next to 0. Import the entries into your Contacts Folder and then use a reliable way to group those Contacts, such as categories or a separate Contacts subfolders.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Import XLS file into newly created Group in the Contacts folder | Scott | Outlook - Using Contacts | 1 | October 5th 06 04:32 AM |
| SAVE A .csv ATTACHEMENT AS A NETWORK .xls FILE | WhytheQ | Outlook and VBA | 1 | July 7th 06 07:07 AM |
| Export and Import Dist list | Casper | Outlook - Using Contacts | 7 | May 11th 06 02:43 AM |
| Import XLS database to Outlook Calender | rhummngbird | Outlook - Calandaring | 2 | April 8th 06 10:31 AM |
| email form data exported out to .csv or .xls? | Mr . . | Outlook - Using Forms | 1 | February 1st 06 12:54 AM |
Linear Mode
