I want to transfer contacts form excel to outlook contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nmixf - 27 Jun 2006 10:17 GMT

I have some contacts in Microsoft Excel like for example: Maria +351 96 777
55 66, and I want to transfer this contact to my contact list in the outlook .

Reply to this Message

Sue Mosher [MVP-Outlook] - 27 Jun 2006 12:10 GMT

Use the File | Import and Export command in Outlook for this.

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I have some contacts in Microsoft Excel like for example: Maria +351 96 777
> 55 66, and I want to transfer this contact to my contact list in the outlook .

Reply to this Message

nmixf - 28 Jun 2006 03:29 GMT

> I have some contacts in Microsoft Excel like for example: Maria +351 96 777
> 55 66, and I want to transfer this contact to my contact list in the outlook .

and this is the message I have wen I go to the import and export

> an error occurred in the Microsoft Excel translator while getting the contents of a file system

The Microsoft excel file
“C:\..............................................xls” has no named ranges.
Use Microsoft excel to name the range of data you want to import

Reply to this Message

Sue Mosher [MVP-Outlook] - 28 Jun 2006 12:48 GMT

So, do what the error message suggests: create a named range. Open the Excel file, select the data you want to import, then choose Insert | Name | Define, and save the file.

Signature

>
>> I have some contacts in Microsoft Excel like for example: Maria +351 96 777
[quoted text clipped - 5 lines]
> C:\..............................................xls has no named ranges.
> Use Microsoft excel to name the range of data you want to import

Reply to this Message