Import of Excel file to Outlook takes only first 2 rows of data -.

#1 December 27th, 2004, 05:57 PM

I am trying to translate an excel address database into Outlook. I created a
template by exporting Outlook Contacts to Excel file and copying my fields
into those corresponding to Outlook. When I tried to inport the data, it
only took the first two rows of data and not the next 300 rows of data. Any
ideas?

#2 January 13th, 2005, 02:41 PM

Sounds like your named range in Excel covered only the first two rows. It
needs to cover all data you want to import.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Lanetloo" wrote in message
...
I am trying to translate an excel address database into Outlook. I created
a
template by exporting Outlook Contacts to Excel file and copying my fields
into those corresponding to Outlook. When I tried to inport the data, it
only took the first two rows of data and not the next 300 rows of data.
Any
ideas?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format on data to import to Access tables? (I need your advice)	Niklas Östergren	General Discussion	5	December 13th, 2004 02:54 PM
Word Field Codes in Excel data file	mranz	Mailmerge	7	December 11th, 2004 09:02 AM
How do I import TXT file with more than 65,536 rows into Excel?	Ed Salcedo	General Discussion	2	October 27th, 2004 09:09 PM
Importing Outlook 2000 pst file into Outlook 2002		General Discussion	13	June 6th, 2004 03:50 PM
Productkey problem when installing office 2003 on network	Stefan Schreurs	Setup, Installing & Configuration	1	June 1st, 2004 11:16 PM