 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / February 2008Importing From Excel
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. 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.  SignatureSue 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 >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. 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 > 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. > > >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. 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 >I am having the same problem. I am already doing what Sue suggests. I >tried [quoted text clipped - 14 lines] >> > have no >> > blank lines. I export from Act ot Excel. As save the file as a standrad Excel Worksheet. I have Act 2003 and Office 2003. I updated from Office 2000 a few weeks ago. I name the Columns in Excel, as required. I Import in Outlook from Excel to Outlook Contacts. I Mpa the Fileds, as required. The program starts Importing. After about 30 seconds, I get the standrads Windows Error Box that says the Program must close, etc. I get 10,000 fileds of blank contacts added to my exisitng contacts. My exisiting contacts do not change. Also, I cannot figure out how to save the Excel file as a *.csv file. > Could you define exactly what "It starts to import, then fails" means? > [quoted text clipped - 37 lines] > >> > have no > >> > blank lines. #1 - How to save as a.csv file - with your worksheet open - from menu bar click on ""File --> Save As" - select CSV as the file type in the window that pops up #2 - If you're getting 10,000 blank contacts - then the "Named Range" in use is not correctly set to include <ONLY> those rows & columns that you want to import. Naming columns is different than the "Named Range". If you're not familiar with "Named Ranges" and the objective is to get a file that will result in importing only the required data as quickly as possible - step #1 is the easiest and most straight-forward solution 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 >I export from Act ot Excel. As save the file as a standrad Excel >Worksheet. [quoted text clipped - 55 lines] >> >> > have no >> >> > blank lines. Thank you. I needed to delete my old Excel Contact file first. The CSV method then worked. It was easy and worked. Thank you again. > #1 - How to save as a.csv file - with your worksheet open - from menu bar > click on ""File --> Save As" - select CSV as the file type in the window [quoted text clipped - 74 lines] > >> >> > have no > >> >> > blank lines. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.