Thread
:
Importing From Excel
View Single Post
#
4
February 12th 08, 04:59 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
Posts: 789
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.
Karl Timmermans
View Public Profile
View message headers
Find all posts by Karl Timmermans
Find all threads started by Karl Timmermans
Ads