|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: address, book, contacts, create, imported, later, outlook |
|
|
|
Thread Tools | Display Modes |
|
#1
March 18th 06, 06:06 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
create address book to later be imported to contacts in 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. 
|
| Ads |
|
#2
March 18th 06, 06:16 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
create address book to later be imported to contacts in 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 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.
|
|
#3
March 18th 06, 06:24 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
create address book to later be imported to contacts in outlook
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.
|
|
#4
March 18th 06, 07:40 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
create address book to later be imported to contacts in outloo
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.
|
|
#5
March 18th 06, 07:50 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
create address book to later be imported to contacts in outloo
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.
|
|
#6
March 18th 06, 08:51 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
create address book to later be imported to contacts in outloo
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.
|
|
#7
March 18th 06, 09:02 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
create address book to later be imported to contacts in outloo
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.
|
|
#8
March 21st 06, 06:40 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
create address book to later be imported to contacts in outloo
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? "Russ Valentine [MVP-Outlook]" wrote: 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.
|
|
#9
March 21st 06, 08:14 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
create address book to later be imported to contacts in outloo
Nikki wrote:
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. -- Brian Tillman
|
|
#10
March 21st 06, 09:05 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
create address book to later be imported to contacts in outloo
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 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 ... 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? "Russ Valentine [MVP-Outlook]" wrote: 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.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Only some contacts show in Outlook Address Book | sethp | Outlook - Using Contacts | 2 | February 25th 06 11:44 PM |
| Outlook 2003 Contacts & Address Book | Javier | Outlook - Using Contacts | 5 | February 22nd 06 09:44 PM |
| Outlook 2002 Uses email address not in Contacts or Address book | Pagen | Outlook - Using Contacts | 1 | February 1st 06 05:11 PM |
| How to create Hyperlink to launch Address Book? | marcia_mcmahon | Outlook and VBA | 4 | January 26th 06 02:56 PM |
| Contacts as Outlook Address Book | Dan Sullivan | Outlook - Using Contacts | 1 | January 19th 06 05:15 PM |
Linear Mode
