![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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 |