A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Importing Excel to Cont, & it won't import all, just 86 of 215



 
 
Thread Tools Display Modes
  #1  
Old November 7th, 2005, 10:19 PM
Misstine
external usenet poster
 
Posts: n/a
Default Importing Excel to Cont, & it won't import all, just 86 of 215

I'm trying to import contact info from an excel spreadsheet to outlook
contacts. There are 215 contacts, but it will only import 86 of them. I can't
figure out why. I've searched microsoft help, but I'm not able to locate any
answers. HELP!
  #2  
Old November 8th, 2005, 07:16 AM
Milly Staples [MVP - Outlook]
external usenet poster
 
Posts: n/a
Default Importing Excel to Cont, & it won't import all, just 86 of 215

Export your contacts to Excel. Compare the file to your file and massage
it. Chances are, you are trying to import custom fields, which OUtlook does
not support.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Misstine asked:

| I'm trying to import contact info from an excel spreadsheet to outlook
| contacts. There are 215 contacts, but it will only import 86 of them.
| I can't figure out why. I've searched microsoft help, but I'm not
| able to locate any answers. HELP!


  #3  
Old November 8th, 2005, 04:08 PM
Karl Timmermans
external usenet poster
 
Posts: n/a
Default Importing Excel to Cont, & it won't import all, just 86 of 215

Check your named range within Excel to make sure that it covers all your
data rows including the first header row. Likely cause of your problem is
that the named range is incorrectly set for the first 86 rows.

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

"Misstine" wrote in message
...
I'm trying to import contact info from an excel spreadsheet to outlook
contacts. There are 215 contacts, but it will only import 86 of them. I
can't
figure out why. I've searched microsoft help, but I'm not able to locate
any
answers. HELP!



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing from Excel MasqueradeKaraoke Contacts 13 November 19th, 2008 08:46 PM
import excel data to access Kevin Labore Database Design 2 June 15th, 2005 04:20 PM
how do I enable "import text file" excel 2002? jw_schmid General Discussion 2 February 9th, 2005 10:39 PM
Import contact info from excel to Outlook 2003 withing XP envrironment Lynn Contacts 2 June 13th, 2004 08:25 PM
Importing Excel 97 into Outlook 98 John Fode Contacts 1 May 19th, 2004 11:55 PM


All times are GMT +1. The time now is 06:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.