importing address data from excel

  • Thread starter Thread starter carol
  • Start date Start date
C

carol

in my excel spreadsheet, have column for address, city,
state, zip. will it be necessary to concatenate these
columns or is there an easier way to import to proper
outlook contact fields?? thx.
 
All you need to do is create a "named range" for all the data you want to
import in Outlook. If you are not familiar or comfortable with Excel "named
ranges" (and don't feel bad if you're not - many people aren't) - simply
save your file in a .CSV format.

- Import the file and "manually map" each of your fields to the appropriate
Outlook field.
- Make sure that when you get to the screen that says "Import a file" - that
you check the file you want to import and the button "map custom fields"
will become active - click on it and you will then be able to map your
fields. This button enables you to map to any "standard Outlook" field -
which all of yours are. It does not enable mapping to any user-defined
field.

You should have no problem importing this data using the standard Outlook
import engine.

Karl

--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://contactgenie.claxton.com
 
Back
Top