Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / January 2004

Tip: Looking for answers? Try searching our database.

importing address data from excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
carol - 30 Jan 2004 19:44 GMT
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.
Karl Timmermans - 31 Jan 2004 01:44 GMT
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

Signature

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

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

Rate this thread:






 
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.