A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

trying to import from excel to contacts



 
 
Thread Tools Display Modes
  #1  
Old December 1st, 2004, 11:19 PM
okii
external usenet poster
 
Posts: n/a
Default trying to import from excel to contacts

I am trying to import a file from excel to my contacts. I am at a window that
says... the microsoft Excel file has no named ranges. Use Microsoft Excel to
name the range of data you want to import.

what does this mean and what do i do???
  #2  
Old December 2nd, 2004, 05:42 AM
Jocelyn Fiorello [MVP - Outlook]
external usenet poster
 
Posts: n/a
Default

Select the range of cells in Excel that you want to import (say, from A1 to
J12) and while that block is selected, type a name for the range in the box
above the grid, to the left of the formula bar (it usually has a cell number
in it and if you hover over the box it should say Name Box). Now save and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???



  #3  
Old December 27th, 2004, 03:13 AM
aug
external usenet poster
 
Posts: n/a
Default



"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from A1 to
J12) and while that block is selected, type a name for the range in the box
above the grid, to the left of the formula bar (it usually has a cell number
in it and if you hover over the box it should say Name Box). Now save and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???




  #4  
Old December 27th, 2004, 03:21 AM
aug
external usenet poster
 
Posts: n/a
Default

I have the same problem but don't understand the instructions. I have names
in cells A2 through A23 and e-mail addresses in B2:B23 in A1, I have Name. in
B1, E-mail. I tried high lighting A2:B23, then in the box, type any name
and also tried typing A2:B23 in that box. Neither works. What is the
procedure?

"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from A1 to
J12) and while that block is selected, type a name for the range in the box
above the grid, to the left of the formula bar (it usually has a cell number
in it and if you hover over the box it should say Name Box). Now save and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???




  #5  
Old August 31st, 2005, 09:25 PM
Yves B.
external usenet poster
 
Posts: n/a
Default

M. Fiorello have good clue thanks you, it's working good i am now able to
import easily file from excel ... BUT the phone number imported in outlook
are not the right number it seem that there is a format problem. Somebody
know how to coorect that?

"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from A1 to
J12) and while that block is selected, type a name for the range in the box
above the grid, to the left of the formula bar (it usually has a cell number
in it and if you hover over the box it should say Name Box). Now save and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???




  #6  
Old June 22nd, 2006, 11:31 AM posted to microsoft.public.outlook.contacts
bhalla
external usenet poster
 
Posts: 1
Default trying to import from excel to contacts



"okii" wrote:

I am trying to import a file from excel to my contacts. I am at a window that
says... the microsoft Excel file has no named ranges. Use Microsoft Excel to
name the range of data you want to import.

what does this mean and what do i do???

  #7  
Old February 21st, 2007, 11:55 PM posted to microsoft.public.outlook.contacts
PHSMITH
external usenet poster
 
Posts: 1
Default trying to import from excel to contacts

Jocelyn -

Thanks - worked like a charm!!!

"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from A1 to
J12) and while that block is selected, type a name for the range in the box
above the grid, to the left of the formula bar (it usually has a cell number
in it and if you hover over the box it should say Name Box). Now save and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???




  #8  
Old October 10th, 2007, 08:28 PM posted to microsoft.public.outlook.contacts
worker bee
external usenet poster
 
Posts: 9
Default trying to import from excel to contacts

I was able to get this done and have moved to another road block.
I am not able to define the Custom Fields as the Map Custom Fields button,
in Outlook is not available.....I am supposed to have the option "The
following Actions will be performed" from which to choose Import & Map Custom
Fields... and it is not there....???

Help
--
Janice P


"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from A1 to
J12) and while that block is selected, type a name for the range in the box
above the grid, to the left of the formula bar (it usually has a cell number
in it and if you hover over the box it should say Name Box). Now save and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???




  #9  
Old October 10th, 2007, 10:06 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 682
Default trying to import from excel to contacts

Make sure that the checkbox beside the folder you want to import to is
checked - else the "Map Custom Fields" button will not activate.

Just in case this also applies - the term "Map Custom Fields" does not mean
being able to map to any "user-defined fields" with or without a custom
form - only standard fields are accessible for importing using the standard
contact form via Outlook's import/export process.

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



"worker bee" wrote in message
...
I was able to get this done and have moved to another road block.
I am not able to define the Custom Fields as the Map Custom Fields button,
in Outlook is not available.....I am supposed to have the option "The
following Actions will be performed" from which to choose Import & Map
Custom
Fields... and it is not there....???

Help
--
Janice P


"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from A1
to
J12) and while that block is selected, type a name for the range in the
box
above the grid, to the left of the formula bar (it usually has a cell
number
in it and if you hover over the box it should say Name Box). Now save
and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???






  #10  
Old October 11th, 2007, 12:51 AM posted to microsoft.public.outlook.contacts
worker bee
external usenet poster
 
Posts: 9
Default trying to import from excel to contacts

I don't think we are on the same page.
I am trying to Import an Excel file into Contacts, so the importing of a
Folder does not come into play....??...

thanks

jp

--
Janice P


"Karl Timmermans" wrote:

Make sure that the checkbox beside the folder you want to import to is
checked - else the "Map Custom Fields" button will not activate.

Just in case this also applies - the term "Map Custom Fields" does not mean
being able to map to any "user-defined fields" with or without a custom
form - only standard fields are accessible for importing using the standard
contact form via Outlook's import/export process.

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



"worker bee" wrote in message
...
I was able to get this done and have moved to another road block.
I am not able to define the Custom Fields as the Map Custom Fields button,
in Outlook is not available.....I am supposed to have the option "The
following Actions will be performed" from which to choose Import & Map
Custom
Fields... and it is not there....???

Help
--
Janice P


"Jocelyn Fiorello [MVP - Outlook]" wrote:

Select the range of cells in Excel that you want to import (say, from A1
to
J12) and while that block is selected, type a name for the range in the
box
above the grid, to the left of the formula bar (it usually has a cell
number
in it and if you hover over the box it should say Name Box). Now save
and
close the spreadsheet and try to import from Outlook again.

--
Jocelyn Fiorello
MVP - Outlook

*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***


In ,
okii wrote:

I am trying to import a file from excel to my contacts. I am at a
window that says... the microsoft Excel file has no named ranges. Use
Microsoft Excel to name the range of data you want to import.

what does this mean and what do i do???






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook Contacts Do Not display from Fax Wizard DaveoSac Contacts 5 October 4th, 2004 09:46 PM
excel import Filemaker 4 and Mac OS9 Mitsunari New Users 0 August 8th, 2004 07:42 PM
Outlook2000 won't import CSV contacts Greg General Discussions 1 June 21st, 2004 11:59 PM
Help! Tried to import contacts into Outlook 2000.... Emily Contacts 4 May 27th, 2004 02:25 AM
Excel Import Problem Russ Worksheet Functions 1 April 8th, 2004 06:15 PM


All times are GMT +1. The time now is 10:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.