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

Jerry

Yes, from the Outlook end.

FileImportFollow 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

On Sat, 6 Jan 2007 22:24:19 -0500, "JERRY" <[email protected] wrote:

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

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


Gord

On Sat, 06 Jan 2007 21:03:22 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Jerry

Yes, from the Outlook end.

FileImportFollow 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

On Sat, 6 Jan 2007 22:24:19 -0500, "JERRY" <[email protected] wrote:

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

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


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
In addition, if you give your data table in Excel a name through
InsertName
Define you can import directly from the Excel workbook.


Gord

On Sat, 06 Jan 2007 21:03:22 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Jerry

Yes, from the Outlook end.

FileImportFollow 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

On Sat, 6 Jan 2007 22:24:19 -0500, "JERRY" <[email protected] wrote:

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

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
DTHIS
www.nickhodge.co.uk


"JERRY" <[email protected] wrote in message
...
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


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
In addition, if you give your data table in Excel a name through
InsertName
Define you can import directly from the Excel workbook.


Gord

On Sat, 06 Jan 2007 21:03:22 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Jerry

Yes, from the Outlook end.

FileImportFollow 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

On Sat, 6 Jan 2007 22:24:19 -0500, "JERRY" <[email protected] wrote:

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

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


On Sun, 7 Jan 2007 16:52:48 -0500, "JERRY" <[email protected] wrote:

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


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
In addition, if you give your data table in Excel a name through
InsertName
Define you can import directly from the Excel workbook.


Gord

On Sat, 06 Jan 2007 21:03:22 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Jerry

Yes, from the Outlook end.

FileImportFollow 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

On Sat, 6 Jan 2007 22:24:19 -0500, "JERRY" <[email protected] wrote:

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

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 Aguir aka ja202141



"Gord Dibben" wrote:

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


On Sun, 7 Jan 2007 16:52:48 -0500, "JERRY" <[email protected] wrote:

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


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
In addition, if you give your data table in Excel a name through
InsertName
Define you can import directly from the Excel workbook.


Gord

On Sat, 06 Jan 2007 21:03:22 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Jerry

Yes, from the Outlook end.

FileImportFollow 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

On Sat, 6 Jan 2007 22:24:19 -0500, "JERRY" <[email protected] wrote:

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