Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Import Excel File to Contacts in Outlook

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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Import Excel File to Contacts in Outlook

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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Import Excel File to Contacts in Outlook

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


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Import Excel File to Contacts in Outlook

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




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,173
Default Import Excel File to Contacts in Outlook

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







  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Import Excel File to Contacts in Outlook

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




  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Import Excel File to Contacts in Outlook

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retaining formats grok Excel Discussion (Misc queries) 11 October 31st 06 07:29 PM
How to link to an Excel file when sending an email in Outlook? BFree Excel Discussion (Misc queries) 2 May 1st 06 11:43 AM
Weird File Open/Save As Behavior [email protected] Excel Discussion (Misc queries) 0 December 9th 05 02:26 AM
Import Excel Data from another workbook or file tamato43 Excel Discussion (Misc queries) 1 February 28th 05 05:26 PM
Excel Exits on File Close with Outlook Erin Searfoss Excel Discussion (Misc queries) 1 January 16th 05 09:43 PM


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"