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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
"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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |