Import Excel File to Contacts in Outlook

[JERRY]

Could some one help me with some directions as to how to import a simple
spread sheet containing names addresses and phone numbers in Excel to my
contacts in Outlook
With Appreciation
Jerry

 

[Gord Dibben]

Jerry

Yes, from the Outlook end.

File>Import>Follow your nose from there.

For some assistance.......................

Browse through this google search result for one method of importing the Excel
contacts to Outlook.

http://snipurl.com/pssw


Gord Dibben MS Excel MVP

 

[Gord Dibben]

In addition, if you give your data table in Excel a name through Insert>Name
Define you can import directly from the Excel workbook.


Gord

 

[JERRY]

I apologize that my post was not clear. I am not referring to Outlook, the
email client. I want to import names, addresses, phone numbers into the
contacts section of Microsoft Office Outlook.

Thank you again for any help herein
Jerry

 

[Nick Hodge]

Jerry

One and the same...go through the import routine detailed and then choose
your contacts folder as the destination in the wizard

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Gord Dibben]

Jerry

I think your post was clear.

My response was directed toward the importing of Excel data into MS Office
Outlook which is Office's email application.

What do you use MS Office Outlook for?


Gord

 

[Guest]

Just to clarify one thing I found out. In addition to the fact that you have
to create a named range if you want to import directlyl from an .xls file,
you must also have your headings matching the ones that the outlook Contacts
folder is searching for.

Examples:
First Name
Last Name
Home Street
Home City
Home State
Home Postal Code

I had put Home Address instead of Home Street so I was unable to see the
entire address in the "Address Cards" View. It frustrated me for awhile, but
I eventually figured it out by using the customer map option during the
import. It allowed me to see the names of each of the fields specifically.

I hope that wasn't too confusing!

Have a great day!

Jason Aguirre: aka ja202141