A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

HELP HELP - Importing Contacts from Excel List



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old February 20th 06, 02:55 PM posted to microsoft.public.outlook.contacts
TotallyConfused
external usenet poster
 
Posts: 14
Default HELP HELP - Importing Contacts from Excel List

I have imported a Contact list of Excel. But when I look in my address book
under Contacts my list is not complete. Is there a limit to how many
contacts you can import? I have over 2000. Also is there a way to eliminate
the "file" version of the contact I just want the name, ph and fx number to
show. My Excel sheet consists of three columns Name, ph and fx number. I
would like to get this rights others will need to import the same list to
their address book. Thank you.
Ads
  #2  
Old February 20th 06, 03:02 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default HELP HELP - Importing Contacts from Excel List

No such limit. It appears you did not import correctly.
Look in your Contacts Folder and see.
Are the email addresses mapped to the correct field? Are they valid and
resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message ...
I have imported a Contact list of Excel. But when I look in my address
book
under Contacts my list is not complete. Is there a limit to how many
contacts you can import? I have over 2000. Also is there a way to
eliminate
the "file" version of the contact I just want the name, ph and fx number
to
show. My Excel sheet consists of three columns Name, ph and fx number.
I
would like to get this rights others will need to import the same list to
their address book. Thank you.



  #3  
Old February 20th 06, 03:35 PM posted to microsoft.public.outlook.contacts
TotallyConfused
external usenet poster
 
Posts: 14
Default HELP HELP - Importing Contacts from Excel List

I mapped the field correctly. I did not use an email address on these
contacts we do not need only need name, ph and fax numbers. If the list is
not showing when I open the address book and go to contacts then where would
they be? Is there somewhere where I can see an example or walks you through
step by step? Any help will be greatly appreciated.

"Russ Valentine [MVP-Outlook]" wrote:

No such limit. It appears you did not import correctly.
Look in your Contacts Folder and see.
Are the email addresses mapped to the correct field? Are they valid and
resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message ...
I have imported a Contact list of Excel. But when I look in my address
book
under Contacts my list is not complete. Is there a limit to how many
contacts you can import? I have over 2000. Also is there a way to
eliminate
the "file" version of the contact I just want the name, ph and fx number
to
show. My Excel sheet consists of three columns Name, ph and fx number.
I
would like to get this rights others will need to import the same list to
their address book. Thank you.




  #4  
Old February 20th 06, 04:12 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default HELP HELP - Importing Contacts from Excel List

Only electronic addresses appear in the Outlook Address Book.
Did you store your fax numbers in a fax field and are they resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message news
I mapped the field correctly. I did not use an email address on these
contacts we do not need only need name, ph and fax numbers. If the list
is
not showing when I open the address book and go to contacts then where
would
they be? Is there somewhere where I can see an example or walks you
through
step by step? Any help will be greatly appreciated.

"Russ Valentine [MVP-Outlook]" wrote:

No such limit. It appears you did not import correctly.
Look in your Contacts Folder and see.
Are the email addresses mapped to the correct field? Are they valid and
resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message ...
I have imported a Contact list of Excel. But when I look in my address
book
under Contacts my list is not complete. Is there a limit to how many
contacts you can import? I have over 2000. Also is there a way to
eliminate
the "file" version of the contact I just want the name, ph and fx
number
to
show. My Excel sheet consists of three columns Name, ph and fx
number.
I
would like to get this rights others will need to import the same list
to
their address book. Thank you.






  #5  
Old February 20th 06, 05:19 PM posted to microsoft.public.outlook.contacts
TotallyConfused
external usenet poster
 
Posts: 14
Default HELP HELP - Importing Contacts from Excel List

yes I stored the fax numbers in the business fax field. What do you mean are
they resolved. Thank you.

"Russ Valentine [MVP-Outlook]" wrote:

Only electronic addresses appear in the Outlook Address Book.
Did you store your fax numbers in a fax field and are they resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message news
I mapped the field correctly. I did not use an email address on these
contacts we do not need only need name, ph and fax numbers. If the list
is
not showing when I open the address book and go to contacts then where
would
they be? Is there somewhere where I can see an example or walks you
through
step by step? Any help will be greatly appreciated.

"Russ Valentine [MVP-Outlook]" wrote:

No such limit. It appears you did not import correctly.
Look in your Contacts Folder and see.
Are the email addresses mapped to the correct field? Are they valid and
resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message ...
I have imported a Contact list of Excel. But when I look in my address
book
under Contacts my list is not complete. Is there a limit to how many
contacts you can import? I have over 2000. Also is there a way to
eliminate
the "file" version of the contact I just want the name, ph and fx
number
to
show. My Excel sheet consists of three columns Name, ph and fx
number.
I
would like to get this rights others will need to import the same list
to
their address book. Thank you.






  #6  
Old February 20th 06, 05:35 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default HELP HELP - Importing Contacts from Excel List

Underlined. That indicates Outlook recognizes them as valid electronic
addresses. If they're not underlined, they won't show up.
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message ...
yes I stored the fax numbers in the business fax field. What do you mean
are
they resolved. Thank you.

"Russ Valentine [MVP-Outlook]" wrote:

Only electronic addresses appear in the Outlook Address Book.
Did you store your fax numbers in a fax field and are they resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message news
I mapped the field correctly. I did not use an email address on these
contacts we do not need only need name, ph and fax numbers. If the
list
is
not showing when I open the address book and go to contacts then where
would
they be? Is there somewhere where I can see an example or walks you
through
step by step? Any help will be greatly appreciated.

"Russ Valentine [MVP-Outlook]" wrote:

No such limit. It appears you did not import correctly.
Look in your Contacts Folder and see.
Are the email addresses mapped to the correct field? Are they valid
and
resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message ...
I have imported a Contact list of Excel. But when I look in my
address
book
under Contacts my list is not complete. Is there a limit to how
many
contacts you can import? I have over 2000. Also is there a way to
eliminate
the "file" version of the contact I just want the name, ph and fx
number
to
show. My Excel sheet consists of three columns Name, ph and fx
number.
I
would like to get this rights others will need to import the same
list
to
their address book. Thank you.








  #7  
Old February 20th 06, 06:27 PM posted to microsoft.public.outlook.contacts
Mark R Penn
external usenet poster
 
Posts: 16
Default HELP HELP - Importing Contacts from Excel List

Russ,

I've always been confused by this issue of address book vs. Outlook
contacts. You're right that Outlook contacts that don't have valid
electronic addresses don't appear in the address book, but I'm left
wondering what the address book is used for when you have Outlook contacts?

I guess the question for TotallyConfused has to be; do the contacts that
don't appear in the address book appear in the Outlook contacts folder? If
they do, then you did import them correctly, but as Russ says, some of them
don't have resolved electronic addresses.

Mark

"Russ Valentine [MVP-Outlook]" wrote in message
...
Underlined. That indicates Outlook recognizes them as valid electronic
addresses. If they're not underlined, they won't show up.
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message ...
yes I stored the fax numbers in the business fax field. What do you mean
are
they resolved. Thank you.

"Russ Valentine [MVP-Outlook]" wrote:

Only electronic addresses appear in the Outlook Address Book.
Did you store your fax numbers in a fax field and are they resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message news I mapped the field correctly. I did not use an email address on these
contacts we do not need only need name, ph and fax numbers. If the
list
is
not showing when I open the address book and go to contacts then where
would
they be? Is there somewhere where I can see an example or walks you
through
step by step? Any help will be greatly appreciated.

"Russ Valentine [MVP-Outlook]" wrote:

No such limit. It appears you did not import correctly.
Look in your Contacts Folder and see.
Are the email addresses mapped to the correct field? Are they valid
and
resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote
in
message ...
I have imported a Contact list of Excel. But when I look in my
address
book
under Contacts my list is not complete. Is there a limit to how
many
contacts you can import? I have over 2000. Also is there a way to
eliminate
the "file" version of the contact I just want the name, ph and fx
number
to
show. My Excel sheet consists of three columns Name, ph and fx
number.
I
would like to get this rights others will need to import the same
list
to
their address book. Thank you.










  #8  
Old February 20th 06, 07:03 PM posted to microsoft.public.outlook.contacts
TotallyConfused
external usenet poster
 
Posts: 14
Default HELP HELP - Importing Contacts from Excel List

okay what I am understanding is if I do not have an email and it is not
underscored then my contact will not appear in my contact folder? Then how
do you explain the contacts that did make it to my contacts folder. Is there
anyway around this? I just need to have Name, phone number and fax number.
What I am doing with these contact's fax numbers, I am faxing from Outlook.
So only fax numbers and names are important right now. Any help will be
greatly appreciated. thank you.

"Russ Valentine [MVP-Outlook]" wrote:

Underlined. That indicates Outlook recognizes them as valid electronic
addresses. If they're not underlined, they won't show up.
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message ...
yes I stored the fax numbers in the business fax field. What do you mean
are
they resolved. Thank you.

"Russ Valentine [MVP-Outlook]" wrote:

Only electronic addresses appear in the Outlook Address Book.
Did you store your fax numbers in a fax field and are they resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message news I mapped the field correctly. I did not use an email address on these
contacts we do not need only need name, ph and fax numbers. If the
list
is
not showing when I open the address book and go to contacts then where
would
they be? Is there somewhere where I can see an example or walks you
through
step by step? Any help will be greatly appreciated.

"Russ Valentine [MVP-Outlook]" wrote:

No such limit. It appears you did not import correctly.
Look in your Contacts Folder and see.
Are the email addresses mapped to the correct field? Are they valid
and
resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message ...
I have imported a Contact list of Excel. But when I look in my
address
book
under Contacts my list is not complete. Is there a limit to how
many
contacts you can import? I have over 2000. Also is there a way to
eliminate
the "file" version of the contact I just want the name, ph and fx
number
to
show. My Excel sheet consists of three columns Name, ph and fx
number.
I
would like to get this rights others will need to import the same
list
to
their address book. Thank you.









  #9  
Old February 20th 06, 07:08 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default HELP HELP - Importing Contacts from Excel List

Actually there is very little use for the Address Book in Outlook. It is
simply a listing of all the electronic addresses in the Contacts Folder. It
is usually better to use the Contacts Folder directly to access Contacts
data. That's the way Outlook was designed. The Address Book view is created
for those users who cannot wean themselves from the address book concept.
--
Russ Valentine
[MVP-Outlook]
"Mark R Penn" wrote in message
...
Russ,

I've always been confused by this issue of address book vs. Outlook
contacts. You're right that Outlook contacts that don't have valid
electronic addresses don't appear in the address book, but I'm left
wondering what the address book is used for when you have Outlook
contacts?

I guess the question for TotallyConfused has to be; do the contacts that
don't appear in the address book appear in the Outlook contacts folder? If
they do, then you did import them correctly, but as Russ says, some of
them don't have resolved electronic addresses.

Mark

"Russ Valentine [MVP-Outlook]" wrote in message
...
Underlined. That indicates Outlook recognizes them as valid electronic
addresses. If they're not underlined, they won't show up.
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message ...
yes I stored the fax numbers in the business fax field. What do you
mean are
they resolved. Thank you.

"Russ Valentine [MVP-Outlook]" wrote:

Only electronic addresses appear in the Outlook Address Book.
Did you store your fax numbers in a fax field and are they resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message news I mapped the field correctly. I did not use an email address on these
contacts we do not need only need name, ph and fax numbers. If the
list
is
not showing when I open the address book and go to contacts then
where
would
they be? Is there somewhere where I can see an example or walks you
through
step by step? Any help will be greatly appreciated.

"Russ Valentine [MVP-Outlook]" wrote:

No such limit. It appears you did not import correctly.
Look in your Contacts Folder and see.
Are the email addresses mapped to the correct field? Are they valid
and
resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote
in
message ...
I have imported a Contact list of Excel. But when I look in my
address
book
under Contacts my list is not complete. Is there a limit to how
many
contacts you can import? I have over 2000. Also is there a way
to
eliminate
the "file" version of the contact I just want the name, ph and fx
number
to
show. My Excel sheet consists of three columns Name, ph and fx
number.
I
would like to get this rights others will need to import the same
list
to
their address book. Thank you.












  #10  
Old February 20th 06, 07:10 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 9,348
Default HELP HELP - Importing Contacts from Excel List

Do not confuse the Contacts Folder with the address book. All data is stored
in the Contacts Folder. No data is stored in an address book. The address
book is simply a view of the electronic addresses that in your Contacts
Folder.
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message ...
okay what I am understanding is if I do not have an email and it is not
underscored then my contact will not appear in my contact folder? Then
how
do you explain the contacts that did make it to my contacts folder. Is
there
anyway around this? I just need to have Name, phone number and fax
number.
What I am doing with these contact's fax numbers, I am faxing from
Outlook.
So only fax numbers and names are important right now. Any help will be
greatly appreciated. thank you.

"Russ Valentine [MVP-Outlook]" wrote:

Underlined. That indicates Outlook recognizes them as valid electronic
addresses. If they're not underlined, they won't show up.
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message ...
yes I stored the fax numbers in the business fax field. What do you
mean
are
they resolved. Thank you.

"Russ Valentine [MVP-Outlook]" wrote:

Only electronic addresses appear in the Outlook Address Book.
Did you store your fax numbers in a fax field and are they resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote in
message news I mapped the field correctly. I did not use an email address on
these
contacts we do not need only need name, ph and fax numbers. If the
list
is
not showing when I open the address book and go to contacts then
where
would
they be? Is there somewhere where I can see an example or walks you
through
step by step? Any help will be greatly appreciated.

"Russ Valentine [MVP-Outlook]" wrote:

No such limit. It appears you did not import correctly.
Look in your Contacts Folder and see.
Are the email addresses mapped to the correct field? Are they valid
and
resolved?
--
Russ Valentine
[MVP-Outlook]
"TotallyConfused" wrote
in
message ...
I have imported a Contact list of Excel. But when I look in my
address
book
under Contacts my list is not complete. Is there a limit to how
many
contacts you can import? I have over 2000. Also is there a way
to
eliminate
the "file" version of the contact I just want the name, ph and fx
number
to
show. My Excel sheet consists of three columns Name, ph and fx
number.
I
would like to get this rights others will need to import the same
list
to
their address book. Thank you.











 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing addresses from Excel into Outlook --can't install transl in-over-his-head-bill Outlook - Installation 0 February 25th 06 03:34 PM
Pls Help!! New Contacts from Excel List TotallyConfused Outlook - Using Contacts 3 February 15th 06 09:31 AM
importing from Excel - getting one field per record KevinHenck Outlook - Using Contacts 1 February 11th 06 07:03 PM
Import contact list from excel Sue Mosher [MVP-Outlook] Outlook - Using Contacts 0 January 20th 06 05:45 PM
Importing a simple Contacts list that wasn't exported properly Albert Chen Outlook - Using Contacts 1 January 9th 06 09:19 PM


All times are GMT +1. The time now is 06:25 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.