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
  #11  
Old October 11th, 2007, 12:54 AM posted to microsoft.public.outlook.contacts
worker bee
external usenet poster
 
Posts: 9
Default trying to import from excel to contacts


--
Janice P
your Just in case, I think I might be heading towards what you mention
as a custom form, re my previous response... I guess I don't know what the
Standard Fields are, and will that help here?

thanks

Jp


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???






  #12  
Old October 11th, 2007, 05:54 AM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 682
Default trying to import from excel to contacts

We're very much on the "same page" - follow your import process to the point
where you are encountering the original problem you are asking about.....

#1 - On the "Import A File" screen where the "Map Custom Fields" button
appears - on the left hand portion of that screen you have a listbox under
the title of "The following actions will be performed" where at least one
entry will appear with a checkbox. It is that item that needs to be checked
as per original message in order for the "Map Custom Fields" to activate.

#2 - Contacts does refer to a "folder" which is what you want to import
"into"

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 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???








  #13  
Old October 11th, 2007, 05:58 AM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 682
Default trying to import from excel to contacts

Will keep this simple. If you see all the fields listed that you want to
import to then what I wrote "will not apply" and as such can be ignored.

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
...

--
Janice P
your Just in case, I think I might be heading towards what you mention
as a custom form, re my previous response... I guess I don't know what the
Standard Fields are, and will that help here?

thanks

Jp


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???








  #14  
Old October 11th, 2007, 07:33 PM posted to microsoft.public.outlook.contacts
worker bee
external usenet poster
 
Posts: 9
Default trying to import from excel to contacts

In Outlook, when I click on:
File Menu:
Import & Export
The Wizard loads.
I choose Import from another program or file, Next
I choose Microsoft Excel, Next.
This is where I think I'm going off the rails.
The choices I have here seem to not be the choices that you suggest I should
have.
I can choose "File to import: and browse for it.
and underneath the Options are
* Replace duplicates.
* Allow duplicates
* Do not allow duplicates.

So I have selected the File to import
I click next.

I select the destination Folder, being Contacts, Click Next,
and I get my error message.

"An error has occurred in the Microsoft Excel translator while getting the
contents of a file system. .....file name has no named ranges, Use Excel to
name the range of data you want to import."

I did name the ranges, so I think I haven't given the correct range names?






--
Janice P


"Karl Timmermans" wrote:

We're very much on the "same page" - follow your import process to the point
where you are encountering the original problem you are asking about.....

#1 - On the "Import A File" screen where the "Map Custom Fields" button
appears - on the left hand portion of that screen you have a listbox under
the title of "The following actions will be performed" where at least one
entry will appear with a checkbox. It is that item that needs to be checked
as per original message in order for the "Map Custom Fields" to activate.

#2 - Contacts does refer to a "folder" which is what you want to import
"into"

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 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???









  #15  
Old October 11th, 2007, 07:35 PM posted to microsoft.public.outlook.contacts
Brian Tillman
external usenet poster
 
Posts: 21,988
Default trying to import from excel to contacts

worker bee wrote:

In Outlook, when I click on:
File Menu:
Import & Export
The Wizard loads.
I choose Import from another program or file, Next
I choose Microsoft Excel, Next.
This is where I think I'm going off the rails.
The choices I have here seem to not be the choices that you suggest I
should have.


Have you named the range in the spreadsheet from which you will be
importing? The error you cited indicates you have not and you must. In
Excel, look for "named range" in Help.
--
Brian Tillman [MVP-Outlook]

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

I thought I had, but checked and the Naming had not stuck....spent some more
time on it and am now making progress.
I think I'm almost there.
Thanks for all your help.


--
Janice P


"Brian Tillman" wrote:

worker bee wrote:

In Outlook, when I click on:
File Menu:
Import & Export
The Wizard loads.
I choose Import from another program or file, Next
I choose Microsoft Excel, Next.
This is where I think I'm going off the rails.
The choices I have here seem to not be the choices that you suggest I
should have.


Have you named the range in the spreadsheet from which you will be
importing? The error you cited indicates you have not and you must. In
Excel, look for "named range" in Help.
--
Brian Tillman [MVP-Outlook]


  #17  
Old October 11th, 2007, 09:13 PM posted to microsoft.public.outlook.contacts
worker bee
external usenet poster
 
Posts: 9
Default trying to import from excel to contacts

Brian: Sorry to keep bugging you.
Range Naming.
I have been able to name three of the four columns, but cannot get one
column to accept a name.
I suspect that this may be a problem as this column is a formula combining
two other columns. (first & last names) into one.
I have not been able to get a good understanding of how the steps in the
Insert Menu's, Name... Define, Paste, Create, Apply, & Label are to be
handled or executed....or made to work above, to reference my column of
combined names, or if that is possible.
--
Janice P


"Brian Tillman" wrote:

worker bee wrote:

In Outlook, when I click on:
File Menu:
Import & Export
The Wizard loads.
I choose Import from another program or file, Next
I choose Microsoft Excel, Next.
This is where I think I'm going off the rails.
The choices I have here seem to not be the choices that you suggest I
should have.


Have you named the range in the spreadsheet from which you will be
importing? The error you cited indicates you have not and you must. In
Excel, look for "named range" in Help.
--
Brian Tillman [MVP-Outlook]


  #18  
Old October 12th, 2007, 01:35 AM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 682
Default trying to import from excel to contacts

A very simple alternative to dealing with Named Ranges in Excel for purposes
of importing in Outlook is to simply save your worksheet as a .CSV file and
import that file instead, avoiding Named Ranges entirely. Aside from that -
you assign ONE name to all the columns/rows that you want to import in
Outlook - not one name per column.

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
...
Brian: Sorry to keep bugging you.
Range Naming.
I have been able to name three of the four columns, but cannot get one
column to accept a name.
I suspect that this may be a problem as this column is a formula combining
two other columns. (first & last names) into one.
I have not been able to get a good understanding of how the steps in the
Insert Menu's, Name... Define, Paste, Create, Apply, & Label are to be
handled or executed....or made to work above, to reference my column
of
combined names, or if that is possible.
--
Janice P


"Brian Tillman" wrote:

worker bee wrote:

In Outlook, when I click on:
File Menu:
Import & Export
The Wizard loads.
I choose Import from another program or file, Next
I choose Microsoft Excel, Next.
This is where I think I'm going off the rails.
The choices I have here seem to not be the choices that you suggest I
should have.


Have you named the range in the spreadsheet from which you will be
importing? The error you cited indicates you have not and you must. In
Excel, look for "named range" in Help.
--
Brian Tillman [MVP-Outlook]




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

Okay! Thankyou!...csv, finally got it to work.
Man, was that a trip around the block.
Thanks for this.
--
Janice P


"Karl Timmermans" wrote:

A very simple alternative to dealing with Named Ranges in Excel for purposes
of importing in Outlook is to simply save your worksheet as a .CSV file and
import that file instead, avoiding Named Ranges entirely. Aside from that -
you assign ONE name to all the columns/rows that you want to import in
Outlook - not one name per column.

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
...
Brian: Sorry to keep bugging you.
Range Naming.
I have been able to name three of the four columns, but cannot get one
column to accept a name.
I suspect that this may be a problem as this column is a formula combining
two other columns. (first & last names) into one.
I have not been able to get a good understanding of how the steps in the
Insert Menu's, Name... Define, Paste, Create, Apply, & Label are to be
handled or executed....or made to work above, to reference my column
of
combined names, or if that is possible.
--
Janice P


"Brian Tillman" wrote:

worker bee wrote:

In Outlook, when I click on:
File Menu:
Import & Export
The Wizard loads.
I choose Import from another program or file, Next
I choose Microsoft Excel, Next.
This is where I think I'm going off the rails.
The choices I have here seem to not be the choices that you suggest I
should have.

Have you named the range in the spreadsheet from which you will be
importing? The error you cited indicates you have not and you must. In
Excel, look for "named range" in Help.
--
Brian Tillman [MVP-Outlook]





  #20  
Old October 12th, 2007, 01:52 PM posted to microsoft.public.outlook.contacts
Brian Tillman
external usenet poster
 
Posts: 21,988
Default trying to import from excel to contacts

worker bee wrote:

Brian: Sorry to keep bugging you.
Range Naming.
I have been able to name three of the four columns, but cannot get one
column to accept a name.


You want to have one named range. I don't know why you are naming each
column. Highlight the entire section of data and then give the selection a
single name.
--
Brian Tillman [MVP-Outlook]

 




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 05:35 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.