Importing Contacts from excel, they don't appear in Address Book

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kathleen Maloney - 24 Sep 2006 14:33 GMT

I have been trying to import contacts from an excel spreadsheet and they are
not appearing in contacts after going through the process.

I have checked for troubleshooting on line and confirmed that the show this
folder as an email Address Book has been checked in Contacts Properties.

The fields are all mapping fine, the data just isn't filling in.

Reply to this Message

Russ Valentine [MVP-Outlook] - 24 Sep 2006 15:10 GMT

Clarify whether you mean the data is not appearing in the Contacts Folder or
the address book view.
Can't really tell what you're doing wrong when you haven't told us what you
did.

Signature

Russ Valentine
[MVP-Outlook]

>I have been trying to import contacts from an excel spreadsheet and they
>are
[quoted text clipped - 5 lines]
>
> The fields are all mapping fine, the data just isn't filling in.

Reply to this Message

Kathleen Maloney - 24 Sep 2006 16:29 GMT

Sorry about that. I have an excel spreadsheet that I filled out with Names
address phone etc. I clicked import/export on contacts and clicked import
from file chose excel and do not import duplicate files. I chose to have the
data imported to the contacts file. then finished. I do not get any error
messages but when I look in the address book I do not see any of those
contacts. Thanks.

> Clarify whether you mean the data is not appearing in the Contacts Folder or
> the address book view.
[quoted text clipped - 9 lines]
> >
> > The fields are all mapping fine, the data just isn't filling in.

Reply to this Message

Russ Valentine [MVP-Outlook] - 24 Sep 2006 17:21 GMT

But my question was whether you saw them in your Contacts Folder. We don't
know if this was a problem with your import process or the address book
view. Imported records often fail to resolve their electronic addresses, and
unresolved addresses will not appear in the address book view. Open one of
these Contact Records. Examine the electronic address. Does it appear
correctly and is it resolved (i.e., underlined)? If it is, then save the
Contact and see if that Contact then appears in the address book view.

Signature

Russ Valentine
[MVP-Outlook]

> Sorry about that. I have an excel spreadsheet that I filled out with
> Names
[quoted text clipped - 22 lines]
>> >
>> > The fields are all mapping fine, the data just isn't filling in.

Reply to this Message