View Single Post
  #4  
Old February 12th 08, 04:59 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default Importing From Excel

Could you define exactly what "It starts to import, then fails" means?

Specifically:

#1) fails how?
#2) With what error message?
#3) do you also get an indeterminate number of blank contacts before "it
fails"

In the interests of time, if your import also results in blank contacts
prior to failure, then the first issue would be the "named range" that's
been defined. One quick thing that you can do to avoid the issue of "named
range" is to save your worksheet as a CSV file and import that and see if
your import still fails.

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


"Russell Pepe" Russell wrote in message
...
I am having the same problem. I am already doing what Sue suggests. I
tried
several times. It starts to import, then fails.

Russell Pepe

"Sue Mosher [MVP-Outlook]" wrote:

You need to set a named range in the worksheet to cover all the rows and
columns to be imported and then in Outlook's Import and Export wizard,
click the Map Custom Fields button to tell Outlook which column's data to
put into which Outlook property.

--
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

"D. Jarrett" wrote in message
...
I have attempted to import contacts from excel but each time i do it
fails
and i have thousands of blank contact fields in access along with
incomplete
contact information. What do i do to import my contacts properly and
have no
blank lines.




Ads