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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lanetloo - 27 Dec 2004 17:57 GMT

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?

Reply to this Message

Sue Mosher [MVP-Outlook] - 13 Jan 2005 14:41 GMT

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

Signature

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

>I am trying to translate an excel address database into Outlook. I created
>a
[quoted text clipped - 3 lines]
> Any
> ideas?

Reply to this Message