Importing Contacts

B

Bruce

OK I have an Excel 2007 spreadsheet with named ranges to import into Outlook
2007 contacts. However when I open the Import routine in Outlook the only
Excel option is for Excel 97-2003. I've also tried to import from Access
2007 but again Outlook only shows Access 97-2003 formating option available.
Any suggestions?
 
V

Vince Averello

Load the spreadsheet into Excel 2007 and save it as an Excel 2003 file then
use that file
 
B

Bruce

Been there done that. When it imported I got about 400 blank contact entries
and another 156 fof just addresses and no other data.

Bruce
 
K

Karl Timmermans

Most likely cause of blank entries and missing info is an incorrect "Named
Range". Converting from .xlsx to .xls won't cause the data in the worksheet
to change.

You may also try just saving your worksheet as a CSV file and importing that
instead - named ranges are not a factor with CSV files.

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
 

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

import email addresses from Excel spreadsheet 4
excel97-03 into Outlook Contacts 2
Problem importing data from Excel into Outlook 2007 Contacts 3
Import filter for Access 2007 missing 3
merge excel 2007 into Outlook contacts list 2
Outlook 2003 - Importing contacts from Excel: option is missing? 2
Importing contacts 6
Need to import names and email addresses from Excel 97-2003 to Out 1

Top