importing address data from excel

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.
 
K

Karl Timmermans

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top