Import from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Did the hour in the board and did not find anything I have not tried so must
ask.
Here is what I have done. Environment is WinXP running Office 2000 with all
patches, have also tried on an unpatched box.

Export Contacts from Outlook as Excel file - re import... e-mail addresses
not present

Export as csv, re import still no e-mail addresses.

played around with the exported files (hide fields, delete fields, import
excel, import csv etc)

I can't seem to get the e-mail addresses to import with the other
information, the notes won't import either. What is going on? Why only the
name, company, title, and phone number?

Very confused, hope someone can help. Thank you in advance.

Aaron
 
SOLUTION FOUND:

When using a seperate custom built document perform the following:

1. Name the range
- Highlight the entire area and name the range by clicking in the box
under "File"
on the menu bar and under the toolbar where the Cell name is (ex. B3)
then
type the name of the range, I used contacts.
2. Continue to click next until you see a button that Maps Fields
3. Drag from left pane to right pane the name of the column you want to map
to the particular fields. It will appear to the right of the Outlook
name in the
right pane.
4. Click next
5. End of task, contacts are imported with appropriate fields mapped and
visible.

Hope this helps others!

Thank you.
 
Back
Top