This is what worked for me. Save the Excel file to a .csv, e.g. File, Save
As, Save As Type: CSV(Comma delimited). Let’s say you called your .csv file
TEST. To keep this format etc. click Yes. Close down Excel, do you want to
save changes to .csv file, click No.
In Outlook 2003, in Contacts view, go to File, New, Folder, select to place
your new folder (say you also call it TEST) as a sub-folder of Contacts.
While still in Contacts view, select the new TEST folder you just made. Then
File, Import and Export, Import from another program or file, Next, Comma
Separated Values (Windows), Next, select file to import which is the TEST.csv
file, check Options to replace duplicates with items imported, Next.
In the resulting window, select destination folder TEST, Next. In resulting
window, Import a File, check “Import “TEST.csv” into folder: TEST.
While still in same Import A File window, click on Map Custom Fields. In Map
Custom Fields window, click on Clear Map to remove any defaults. Then drag
your headers from the Value field across to whatever Fields you need
opposite. Click OK.
This takes you back to the Import A File window, this time click Finish.
You’ll see the result where it has imported.
To make a Distribution List, while in Contacts view, click on TEST folder,
File, New, Distribution List.
In this window, give your Distribution List a name, e.g. you might call it
the same name as your .csv file, TEST. Click Select Members, in the Select
Members window, in dropdown box, find your TEST Contacts folder, and select
the names from there.
However, rather than make DLs, you could sort by Category, select a
Category, Actions, New Message To Contact.
As an aside: A work colleague asked me to make several Distribution Lists
from her Excel file, so in Excel, I inserted a column named e.g. AAAA, for
the relevant categories she wanted as separate DLs, saved the Excel file as
..csv, imported as outlined above, having dragged the AAAA Value/Field to the
Categories field in the Map Custom Fields window.
Once I had the .csv file imported, say I called it TEST same as earlier
steps above, I right-clicked on its folder, Select Copy “TEST”, click on
Contacts folder, OK. This gave me a duplicate TEST folder (You will
understand why I made a duplicate if you read further). I right-clicked on
one of them to rename it TEST2.
I viewed TEST2 by Category, one category of which was CONSTRUCTION. I made
a new (temporary) sub-folder named CONSTRUCTION under Contacts, then dragged
the CONSTRUCTION Category into it. This removed it from TEST2 completely (so
now you’ll know why I made the duplicate).
The CONSTRUCTION folder was only temporary, and once I’d made a DL from it,
I deleted its folder. I continued to follow the same steps for all other
Categories in the TEST2 until it was empty. It is a bit of a process but it’s
the only way I could work out how to make DLs from Categories. If you have
700 email addresses to sort into DLs, this is worth the bother.
Lindy
"Versailes" wrote:
> i have a very large list in Excel of emails that i want to to go in a
> distribution list. is this possible without entering each one in at a time?
Similar Threads
