import contacts from Excel

[Marilyn]

I have created two Contact folders under the Primary Contact folder under
Public Folders. I have an Excel spreadsheet that I would like to import data
into them. During the import process, I do not see Public Folders as a
choice (only my mailbox and Personal Folders). Is it possible to do this?
And, from all the other messages I'm seeing, is this a difficult process? I
have an Exchange 2003 server, client users are on Outlook 2002 and 2003 and
it's an Excel 2002 document. Thanks, Marilyn

 

[Judy Gleeson \(MVP Outlook\)]

Make a Contacts Folder in your Mailbox as the destination. Once the data is
in, you can drag the folder to the Public Folders.

Improting from Excel works fine as long as you name the range and close
Excel, then use file import in Outlook.
--

Regards

Judy Gleeson
MVP Outlook
Trainer and Consultant www.pragmatix.com.au
Outlook 2003 user? Read "7 settings all Outlook 2003 users should change"
on my website.

..

 

[Marilyn]

Judy - I'm having a heck of a time with naming the range. I've been in Excel
help and on the Excel discussion group. two replies took me to documents
that basically say the same thing as Excel help. I've taken the suggested
steps a dozen times and two or three different ways. End result is still the
error that the document has no named ranges and to use Excel to name the
range of data I want to import. Any suggestions? Thanks

 

[Gordon]

Judy - I'm having a heck of a time with naming the range. I've been in
Excel
help and on the Excel discussion group. two replies took me to documents
that basically say the same thing as Excel help. I've taken the suggested
steps a dozen times and two or three different ways. End result is still
the
error that the document has no named ranges and to use Excel to name the
range of data I want to import. Any suggestions? Thanks

All you do is highlight the data and type the name in the box at the top
left hand side of the window, next to the formula bar.....

 

[Marilyn]

Well, that's what I did - several times. It seems so simple and I don't get
why it won't work.

 

[Karl Timmermans]

To avoid the issue of "Named Range" - just save the worksheet as a CSV file
and import that instead.

If you're going to do this on an on-going basis - one of our products may be
of interest:
http://www.contactgenie.com/cg20features.htm
(will import directly into any contact folder - Exch Mailbox, PubFldrs or
PST. You also have the option with DataPorter to "update" pre-existing
contacts)

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com

 

[Marilyn]

Thanks, Karl. I'll try that. Do I just save it as a .csv or does it need
any special formatting. For example, in reading about the named fields, it
said to have the document in a table format. And, does it matter if I have
something like Tulsa, Oklahoma 74133 all in the same cell vs city, state, zip
in different cells? I'll check out your program mentioned for future use.

 

[Karl Timmermans]

In answer to your questions:

#1 - Just save it as CSV
#2 - One cell in Excel = one field.....ergo if you have city, state, and
Zipcode in one cell you are going to have to split those if you want to map
them separately otherwise all will go into the field that you map the cell
too. There are so many ways that addresses can be dealt with - what you
should/need to do really depends on you plan on using that info later on and
how consistent everything is across all of your contacts etc. The cleaner
(and more discrete) your data is - the easier life is going to be all
around.

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com