I need to create an address book that will consist of over 1000 names,
company, address, phone number and email that eventually will have to be
imported to my bosses outlook contacts. I was going to use excel or access
but don't know if this would work or is there a better way to create this
list. I am using office 2000.

Thanks....I appreciate any ideas you can offer.

Excel should work fine. Enter one contact per row, each field in its own column. To import, set a single named range to the entire data set, including column heading rows, and save the .xls file. In Outlook, you'll map those column headings to Outlook field names as part of the import process.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Nikki" wrote in message ...
I need to create an address book that will consist of over 1000 names,
company, address, phone number and email that eventually will have to be
imported to my bosses outlook contacts. I was going to use excel or access
but don't know if this would work or is there a better way to create this
list. I am using office 2000.

Thanks....I appreciate any ideas you can offer.

Why do you want to use a format foreign to Outlook?
Why can't you create these Contacts in Outlook?
--
Russ Valentine
[MVP-Outlook]
"Nikki" wrote in message
...
I need to create an address book that will consist of over 1000 names,
company, address, phone number and email that eventually will have to be
imported to my bosses outlook contacts. I was going to use excel or
access
but don't know if this would work or is there a better way to create this
list. I am using office 2000.

Thanks....I appreciate any ideas you can offer.

I do not have access to my bosses outlook and he does not want to designate
me as a delegate. He wants it in excel or another program so he can import
it to outlook. Any other suggestions.

"Russ Valentine [MVP-Outlook]" wrote:

Why do you want to use a format foreign to Outlook?
Why can't you create these Contacts in Outlook?
--
Russ Valentine
[MVP-Outlook]
"Nikki" wrote in message
...
I need to create an address book that will consist of over 1000 names,
company, address, phone number and email that eventually will have to be
imported to my bosses outlook contacts. I was going to use excel or
access
but don't know if this would work or is there a better way to create this
list. I am using office 2000.

Thanks....I appreciate any ideas you can offer.

But you said you were running Office 2000, right?
If so, just create the Contacts in your version of Outlook and save them as
an Outlook Data File (PST file). Your boss can then open that file in his
installation and copy the data from it. You can also teach your boss that
importing is not a recommended way to transfer data to Outlook if it can be
avoided.
--
Russ Valentine
[MVP-Outlook]
"Nikki" wrote in message
...
I do not have access to my bosses outlook and he does not want to designate
me as a delegate. He wants it in excel or another program so he can
import
it to outlook. Any other suggestions.

"Russ Valentine [MVP-Outlook]" wrote:

Why do you want to use a format foreign to Outlook?
Why can't you create these Contacts in Outlook?
--
Russ Valentine
[MVP-Outlook]
"Nikki" wrote in message
...
I need to create an address book that will consist of over 1000 names,
company, address, phone number and email that eventually will have to
be
imported to my bosses outlook contacts. I was going to use excel or
access
but don't know if this would work or is there a better way to create
this
list. I am using office 2000.

Thanks....I appreciate any ideas you can offer.

Perfect. That will work. Thanks for the help. It saves me a lot of time
and effort. I really do appreciate your time and assistance.

Thanks Russ!

"Russ Valentine [MVP-Outlook]" wrote:

But you said you were running Office 2000, right?
If so, just create the Contacts in your version of Outlook and save them as
an Outlook Data File (PST file). Your boss can then open that file in his
installation and copy the data from it. You can also teach your boss that
importing is not a recommended way to transfer data to Outlook if it can be
avoided.
--
Russ Valentine
[MVP-Outlook]
"Nikki" wrote in message
...
I do not have access to my bosses outlook and he does not want to designate
me as a delegate. He wants it in excel or another program so he can
import
it to outlook. Any other suggestions.

"Russ Valentine [MVP-Outlook]" wrote:

Why do you want to use a format foreign to Outlook?
Why can't you create these Contacts in Outlook?
--
Russ Valentine
[MVP-Outlook]
"Nikki" wrote in message
...
I need to create an address book that will consist of over 1000 names,
company, address, phone number and email that eventually will have to
be
imported to my bosses outlook contacts. I was going to use excel or
access
but don't know if this would work or is there a better way to create
this
list. I am using office 2000.

Thanks....I appreciate any ideas you can offer.

Just to make sure things go smoothly:
1. Make sure the boss knows to OPEN this PST file in his Outlook profile
using the File Open Outlook Data File command. He sounds like he'll
probably be tempted to import it, but he should open it instead (and if you
put this file on a CD, move it to his hard drive and remove its read only
attribute before he tries to open it.)
2. Once the PST file is open in his profile, he can either copy the entire
Contacts Folder to his data store (which will create a separate Contacts
Folder) or, if he wants these Contacts to go to his existing Contacts
Folder, make sure he selects the entire _contents_ of the folder (rather
than the folder itself), then uses the Edit Copy to Folder... command to
copy them to his existing Contacts Folder.
--
Russ Valentine
[MVP-Outlook]
"Nikki" wrote in message
...
Perfect. That will work. Thanks for the help. It saves me a lot of time
and effort. I really do appreciate your time and assistance.

Thanks Russ!

"Russ Valentine [MVP-Outlook]" wrote:

But you said you were running Office 2000, right?
If so, just create the Contacts in your version of Outlook and save them
as
an Outlook Data File (PST file). Your boss can then open that file in his
installation and copy the data from it. You can also teach your boss that
importing is not a recommended way to transfer data to Outlook if it can
be
avoided.
--
Russ Valentine
[MVP-Outlook]
"Nikki" wrote in message
...
I do not have access to my bosses outlook and he does not want to
designate
me as a delegate. He wants it in excel or another program so he can
import
it to outlook. Any other suggestions.

"Russ Valentine [MVP-Outlook]" wrote:

Why do you want to use a format foreign to Outlook?
Why can't you create these Contacts in Outlook?
--
Russ Valentine
[MVP-Outlook]
"Nikki" wrote in message
...
I need to create an address book that will consist of over 1000
names,
company, address, phone number and email that eventually will have
to
be
imported to my bosses outlook contacts. I was going to use excel or
access
but don't know if this would work or is there a better way to create
this
list. I am using office 2000.

Thanks....I appreciate any ideas you can offer.