Import from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I import to outlook contacts a database from excel, each item (name,
company...) appears in a different card.
ex: if I have in excel a data base with 10 contacts (name, e-mail ,phone
number) it result 30 different cards in outlook contacts)
Can you help me please... Many thanks
 
You're really not providing enough info to go on for anyone but to speed up
and simplify the process - this is how your Excel sheet "should" look:

- 1 row = 1 contact
- 1 column = 1 field of information (i.e. name, address, email etc - each
column only has one item in it)
- first row represents the "header row" - i.e. each entry in the column
represents the column's (field's) name
(i.e. column A1 = PersonName, A2 = CompanyName etc etc - field names
depend on what you have in the column)
- you create ONE Excel "named range" that covers the header row and ALL
data rows

Save your file. Import from Outlook making sure you map the fields
individually and you should be on your way :-).

Karl

PS - Not familiar with "Excel named ranges"? You can further simplify your
life by just saving this worksheet in a CSV format and import the .CSV file
instead as long as it follows all the row/column rules.

--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com
 
Here's what worked for me -

Open your excel file.
The first row should contain header titles. Copy this row
and paste it as Row 3, after the first contact in Row 2.

Import the excel file to Outlook, and when you get to the
mapping bit, use the data in the bogus row 3 to map to the
correct outlook fields.
Now finish the import.
You will have a new contact that contains the bogus data
and you can delete that.

Hope this helps, ian
 
Back
Top