A Microsoft Outlook email forum. Outlook Banter

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 » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Importing Contacts From Excel - Incomplete Import



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old February 19th 09, 06:52 PM posted to microsoft.public.outlook.contacts
TonyaG
external usenet poster
 
Posts: 1
Default Importing Contacts From Excel - Incomplete Import

Using Outlook 2007, Windows XP Professional
We're currently putting together a marketing database using Outlook and
Outlook Business Contact Manager.

We had a list of developers in Outlook which we exported, we'll call List A
directly into an excel spreadsheet. We then added to List A other names of
developers that we wanted to target and saved the list.

We now are trying to import List A from Excel 07 into Outlook Contacts. For
whatever reason, when we import, the entire list does not come through. I am
not sure what percentage of the list pulls through. I did not mess w/any of
the custom fields (left it as is)

In an earlier post, someone asked a similar question and there was a
response asking about a "named range rcovering entire data set". What does
this mean? Has anyone else had a similar problem w/exporting from Outlook to
Excel and then back into Outlook again?

Is there something I'm overlooking in the steps?
Thanks,
--
TNG
Ads
  #2  
Old February 19th 09, 07:19 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 789
Default Importing Contacts From Excel - Incomplete Import

When exporting Outlook -- Excel, Outlook creates a "named range" covering
the data exported. Adding additional rows that go outside of the "named
range" will result in those rows not getting imported (such as you
describe). Info on "named ranges" can be found in Excel help (i.e. search
for "define and use names" and one of the topics will be related to what you
need).

Alternative option if you don't want to deal with named ranges - save your
worksheet as a .CSV file and import that file into Outlook instead.

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




"TonyaG" wrote in message
...
Using Outlook 2007, Windows XP Professional
We're currently putting together a marketing database using Outlook and
Outlook Business Contact Manager.

We had a list of developers in Outlook which we exported, we'll call List
A
directly into an excel spreadsheet. We then added to List A other names
of
developers that we wanted to target and saved the list.

We now are trying to import List A from Excel 07 into Outlook Contacts.
For
whatever reason, when we import, the entire list does not come through. I
am
not sure what percentage of the list pulls through. I did not mess w/any
of
the custom fields (left it as is)

In an earlier post, someone asked a similar question and there was a
response asking about a "named range rcovering entire data set". What
does
this mean? Has anyone else had a similar problem w/exporting from Outlook
to
Excel and then back into Outlook again?

Is there something I'm overlooking in the steps?
Thanks,
--
TNG



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Contacts from excel Karen Outlook - Using Contacts 4 February 12th 09 05:16 PM
importing contacts from excel Babs Outlook - Using Contacts 4 January 23rd 07 01:53 PM
Incomplete Import/Export options [email protected] Outlook - General Queries 6 September 11th 06 07:22 PM
import Excel to Outlook, each field importing as separate contact ozbrandi Outlook - Using Contacts 4 February 28th 06 05:49 PM
Importing contacts from Excel Joe Soap Outlook - Using Contacts 1 February 23rd 06 05:55 PM


All times are GMT +1. The time now is 03:38 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.