Trouble importing Excel Spreadsheet into outlook contacts

N

Naomi

I don't inderstand the name a range or field and how that applies to the
exporting of my excel file to outlook. I named each column, and defined
them. When import only a few address show up, without all the other
information and then there are about 1000 blank entries?
 
K

Karl Timmermans

Solution #1
#1 - Delete all your current named ranges that you created for each of your
columns
#2 - highlight all the rows you want to include in your export starting with
the first row that has the column names and assign only ONE name to the
entire area - then import this into Outlook and you will be all set

Solution #2
Save your worksheet as a .CSV file and import the CSV file into Outlook and
that way you don't have to worry about named ranges at all.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

importing excel spreadsheet into contacts 3
How do I import a contact list from excel to Outlook? 8
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Importing contact data from Excel 4
Problems Importing Excel to Outlook 1
Import Contacts From Excel to Outlook Not Working 3
Problem importing data from Excel into Outlook 2007 Contacts 3
Outlook 2007- import contacts from excel spreadsheet???? 3

Top