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  

!!Importing contacts from Excel!!



 
 
Thread Tools Display Modes
  #1  
Old July 5th, 2005, 09:55 PM
LB
external usenet poster
 
Posts: n/a
Default !!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!
Ads
  #2  
Old July 5th, 2005, 10:13 PM
Karl Timmermans
external usenet poster
 
Posts: n/a
Default

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  
Old July 5th, 2005, 11:49 PM
LB
external usenet poster
 
Posts: n/a
Default

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  
Old July 6th, 2005, 08:04 PM
Karl Timmermans
external usenet poster
 
Posts: n/a
Default

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

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
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 02:57 PM
ODBC error exporting contacts to Excel Vin Fichter via OfficeKB.com General Discussion 0 January 14th, 2005 11: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


All times are GMT +1. The time now is 10:47 AM.


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