email list to contact help

B

Blue_Beard

Hello all,
I have outlook2002 and have a list of emails that I need to put in my
contacts.
How can I go about this faster that entering them one by one.
All I need for now, is that these emails get into my contacts and don't
really need any other info entered.

thanks in advance,
-r
 
B

Brian Tillman

Blue_Beard said:
I have outlook2002 and have a list of emails that I need to put in my
contacts.

Do you mean you have a list of email addresses? In what form is this list?
Test file? Access database? Excel spreadsheet?
 
L

Lanwench [MVP - Exchange]

Blue_Beard said:
Hello all,
I have outlook2002 and have a list of emails that I need to put in my
contacts.

What format are they in?
How can I go about this faster that entering them one by one.
All I need for now, is that these emails get into my contacts and
don't really need any other info entered.

You can import - but you'll need to make sure the file/list is in a format
Outlook can use, and that the column headers/field names match up.
Try doing an export from contacts to .csv - look at the column headings in
that file, and you should have an easier time matching things up.
 
B

Blue_Beard

Hello,

Brian Tillman said:
Do you mean you have a list of email addresses? In what form is this
list? Test file? Access database? Excel spreadsheet?

The list of my email addresses are in a word file separated by semicolons
[;].
thanks for looking into this,

-r
 
B

Brian Tillman

Blue_Beard said:
The list of my email addresses are in a word file separated by
semicolons [;].

What else, besides the email addresses, does this list contain? Does it
contain first and last names, phone numbers, mailing addresses, or anything
like that? Please be complete in your description. I'm confident that a
format you can use is available if you specify just how the data looks.
 
B

Blue_Beard

hello,

Brian Tillman said:
Blue_Beard said:
The list of my email addresses are in a word file separated by
semicolons [;].

What else, besides the email addresses, does this list contain? Does it
contain first and last names, phone numbers, mailing addresses, or
anything like that? Please be complete in your description. I'm
confident that a format you can use is available if you specify just how
the data looks.

Only email addresses, nothing else.
thanks again,
~r
 
B

Brian Tillman

Blue_Beard said:
Only email addresses, nothing else.
thanks again,

Turn that list into an Excel spreadsheet or a text file with one address per
row (i.e., all addresses listed one per line), each address encosed in
quotes, with the first row containing "E-mail Address" (also including the
quotes) and it will be easy to import.
 
B

Blue_Beard

Brian Tillman said:
Turn that list into an Excel spreadsheet or a text file with one address
per row (i.e., all addresses listed one per line), each address encosed in
quotes, with the first row containing "E-mail Address" (also including the
quotes) and it will be easy to import.

Thanks, I'll give it a try.

-r
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top