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 | Display Modes |
#1
|
|||
|
|||
Import contact info from excel to Outlook 2003 withing XP envrironment
I have attempted name the columns of contact info in
excell with a colunar header that describes the type of informaiton, i.e. phone no, address, person name, etc. When I attempt to import from excel to an Outlook folder, the named ranges show up individualy but the mapping button is not avaialble. Instead, individual check boxes are noted beside each named range. If the import is allowed to complete, each indivual named range is imported, but not integrated together whereby each contact has all its information in one file. Instead, each named range is imported as if a separate contact, i.e. address, phone numbers, names, etc. When I attempt to reset or define the named ranges in excel, a pop up error box citing MAPI error 0x80070057 appears with no options avaialble. The import processing is halted. It appears that I need help in accurately naming the excell data ranges arranged by columns so that importing can proceed. I have now cleard the name of each range in excel via the INSERT - NAMES - DEFINE options. Any help is appreciated. |
#2
|
|||
|
|||
Import contact info from excel to Outlook 2003 withing XP envrironment
Try the following:
1. Close your excel file 2. From Outlook go to File, Import and Export, Export to a File, Excel File... and give a name for that File 3. Open your first excel file 4. Copy and paste column by column from your first file to the corresponding column in the new file. This is because the colunar header must have the same name. 5. Once you have copied and pasted to the corresponding column, save and close. 6. Go to Outlook, and do the Import process again. The Map soptiopn should now appear, do the mapping and finish. That should work -----Original Message----- I have attempted name the columns of contact info in excell with a colunar header that describes the type of informaiton, i.e. phone no, address, person name, etc. When I attempt to import from excel to an Outlook folder, the named ranges show up individualy but the mapping button is not avaialble. Instead, individual check boxes are noted beside each named range. If the import is allowed to complete, each indivual named range is imported, but not integrated together whereby each contact has all its information in one file. Instead, each named range is imported as if a separate contact, i.e. address, phone numbers, names, etc. When I attempt to reset or define the named ranges in excel, a pop up error box citing MAPI error 0x80070057 appears with no options avaialble. The import processing is halted. It appears that I need help in accurately naming the excell data ranges arranged by columns so that importing can proceed. I have now cleard the name of each range in excel via the INSERT - NAMES - DEFINE options. Any help is appreciated. . |
#3
|
|||
|
|||
Import contact info from excel to Outlook 2003 withing XP envrironment
Two things you can do -
First is to export your excel sheet to a CSV file and import that - that way you don't have to worry about "named ranges". The second is to simply delete all your existing "named ranges" in your Excel sheet - then highlight all the data you want to import including the header row - give that a single range name. You should have no problems importing the file at that point. Karl -- __________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://www.contactgenie.com "Lynn" wrote in message ... I have attempted name the columns of contact info in excell with a colunar header that describes the type of informaiton, i.e. phone no, address, person name, etc. When I attempt to import from excel to an Outlook folder, the named ranges show up individualy but the mapping button is not avaialble. Instead, individual check boxes are noted beside each named range. If the import is allowed to complete, each indivual named range is imported, but not integrated together whereby each contact has all its information in one file. Instead, each named range is imported as if a separate contact, i.e. address, phone numbers, names, etc. When I attempt to reset or define the named ranges in excel, a pop up error box citing MAPI error 0x80070057 appears with no options avaialble. The import processing is halted. It appears that I need help in accurately naming the excell data ranges arranged by columns so that importing can proceed. I have now cleard the name of each range in excel via the INSERT - NAMES - DEFINE options. Any help is appreciated. |
Thread Tools | |
Display Modes | |
|
|