Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / February 2006

Tip: Looking for answers? Try searching our database.

importing from Excel - getting one field per record

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
KevinHenck - 11 Feb 2006 16:06 GMT
When I attempt to import from Excel into outlook contacts.  I get one field
per record.  It doesn't seem to keep rows together and put them in one
contact record.
Sue Mosher [MVP-Outlook] - 11 Feb 2006 19:03 GMT
Sounds like you might not have either the named range in the worksheet or the mapping set up correctly. THe named range needs to cover all the rows and columns of the data you want to worksheet. And in the Import and Export wizard, you should click the Map Custom Fields button to confirm that the columns are being mapped as you want to appropriate Outlook fields.

Signature

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

> When I attempt to import from Excel into outlook contacts.  I get one field
> per record.  It doesn't seem to keep rows together and put them in one
> contact record.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.