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
|
|||
|
|||
!!Importing contacts from Excel!!
I have browsed the numerous threads on this topic...
I have fields in columns, and contact records in rows. My first row contains the field names. The data for each field has been named using the same names as in Row 1. When I import, each field is imported as an individual contact. I'm unable to get all the fields for each record into one contact record. Help please! |
#2
|
|||
|
|||
Create (or fix) a named range so that it encompasses all the data you want
to import including the header row and you should be all set. Not sure about "named ranges"? Save your worksheet as a CSV file and import that file instead. Karl __________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://www.contactgenie.com "LB" wrote in message ... I have browsed the numerous threads on this topic... I have fields in columns, and contact records in rows. My first row contains the field names. The data for each field has been named using the same names as in Row 1. When I import, each field is imported as an individual contact. I'm unable to get all the fields for each record into one contact record. Help please! |
#3
|
|||
|
|||
Thanks - it worked!
Why the .csv? I wish Microsoft would just spell this stuff out in the help files. "Karl Timmermans" wrote: Create (or fix) a named range so that it encompasses all the data you want to import including the header row and you should be all set. Not sure about "named ranges"? Save your worksheet as a CSV file and import that file instead. Karl __________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://www.contactgenie.com "LB" wrote in message ... I have browsed the numerous threads on this topic... I have fields in columns, and contact records in rows. My first row contains the field names. The data for each field has been named using the same names as in Row 1. When I import, each field is imported as an individual contact. I'm unable to get all the fields for each record into one contact record. Help please! |
#4
|
|||
|
|||
The only reason for the CSV suggestion is that it's easier for some to deal
with then trying to figure out how to create a "named range" within Excel (named ranges work perfectly if correctly set up for the data you want to import) There is actually a rationale behind the use of "named ranges" which is that it enables you to have your data anywhere within a worksheet. However, many people just have all their data starting in row/col A1 and aren't accustomed to "named ranges" - hence just easier to save it to CSV. Karl __________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://www.contactgenie.com "LB" wrote in message ... Thanks - it worked! Why the .csv? I wish Microsoft would just spell this stuff out in the help files. "Karl Timmermans" wrote: Create (or fix) a named range so that it encompasses all the data you want to import including the header row and you should be all set. Not sure about "named ranges"? Save your worksheet as a CSV file and import that file instead. Karl __________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://www.contactgenie.com "LB" wrote in message ... I have browsed the numerous threads on this topic... I have fields in columns, and contact records in rows. My first row contains the field names. The data for each field has been named using the same names as in Row 1. When I import, each field is imported as an individual contact. I'm unable to get all the fields for each record into one contact record. Help please! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing contacts from an Excel workbook | Eric Kwang | General Discussion | 1 | May 27th, 2005 10:36 PM |
I am having trouble importing an excel file into contacts in outlo | Sue Leffin | Contacts | 8 | February 10th, 2005 01:57 PM |
ODBC error exporting contacts to Excel | Vin Fichter via OfficeKB.com | General Discussion | 0 | January 14th, 2005 10:33 PM |
importing excel file into Outlook contacts | [email protected] | Contacts | 1 | October 7th, 2004 01:57 PM |
Importing Contacts from Excel | Pauline | Contacts | 1 | June 12th, 2004 04:51 PM |