create address book to later be imported to contacts in outlook

[Guest]

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.

 

[Sue Mosher [MVP-Outlook]]

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Russ Valentine [MVP-Outlook]]

Why do you want to use a format foreign to Outlook?
Why can't you create these Contacts in Outlook?

 

[Guest]

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.

Why do you want to use a format foreign to Outlook?
Why can't you create these Contacts in Outlook?
--
Russ Valentine
[MVP-Outlook]

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.

 

[Russ Valentine [MVP-Outlook]]

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]

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.

Why do you want to use a format foreign to Outlook?
Why can't you create these Contacts in Outlook?
--
Russ Valentine
[MVP-Outlook]

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.

 

[Guest]

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!

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]

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.

Why do you want to use a format foreign to Outlook?
Why can't you create these Contacts in Outlook?
--
Russ Valentine
[MVP-Outlook]
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.

 

[Russ Valentine [MVP-Outlook]]

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]

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!

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]

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.

:

Why do you want to use a format foreign to Outlook?
Why can't you create these Contacts in Outlook?
--
Russ Valentine
[MVP-Outlook]
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.

 

[Guest]

My company blocks us from sharing PST files. I was thinking of creating the
contacts in a Personal Address book and then sharing the PAB file. How would
the person I send the PAB file to access it and save to their outlook
calendar?

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]

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!

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

:

Why do you want to use a format foreign to Outlook?
Why can't you create these Contacts in Outlook?
--
Russ Valentine
[MVP-Outlook]
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.

 

[Brian Tillman]

My company blocks us from sharing PST files. I was thinking of
creating the contacts in a Personal Address book and then sharing the
PAB file. How would the person I send the PAB file to access it and
save to their outlook calendar?

A PAB is a Personal Address Book. It contains Contact items, not Calendar
items.

 

[Sue Mosher [MVP-Outlook]]

Rename the .pst file to .ps_ or .xyz or some other extension and tell the boss to save it and rename it to a .pst.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

My company blocks us from sharing PST files. I was thinking of creating the
contacts in a Personal Address book and then sharing the PAB file. How would
the person I send the PAB file to access it and save to their outlook
calendar?

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]

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!

:

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

:

Why do you want to use a format foreign to Outlook?
Why can't you create these Contacts in Outlook?
--
Russ Valentine
[MVP-Outlook]
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.

 

[Guest]

I meant contacts not calendar.

Is there anyway to create a contact list or address book outside of Outlook
but later import it into outlook?

 

[Brian Tillman]

I meant contacts not calendar.

Is there anyway to create a contact list or address book outside of
Outlook but later import it into outlook?

There are serevral formats that will import into the Contacts folder. A
comma-separated value file (.csv) is one.