 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / March 2006create 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. 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.  SignatureSue 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 >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 [quoted text clipped - 3 lines] > > 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? SignatureRuss 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 [quoted text clipped - 4 lines] > > 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. > Why do you want to use a format foreign to Outlook? > Why can't you create these Contacts in Outlook? [quoted text clipped - 6 lines] > > > > 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. SignatureRuss 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 [quoted text clipped - 13 lines] >> > >> > 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! > But you said you were running Office 2000, right? > If so, just create the Contacts in your version of Outlook and save them as [quoted text clipped - 19 lines] > >> > > >> > 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. SignatureRuss 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. [quoted text clipped - 29 lines] >> >> > >> >> > Thanks....I appreciate any ideas you can offer. 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 [quoted text clipped - 41 lines] > >> >> > > >> >> > Thanks....I appreciate any ideas you can offer. > 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. SignatureBrian 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? > > My company blocks us from sharing PST files. I was thinking of > > creating the contacts in a Personal Address book and then sharing the [quoted text clipped - 3 lines] > A PAB is a Personal Address Book. It contains Contact items, not Calendar > items. > 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. SignatureBrian Tillman 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. SignatureSue 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 > 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 [quoted text clipped - 46 lines] >> >> >> > >> >> >> > Thanks....I appreciate any ideas you can offer. |
Reply to this Message |
 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
|
©2009 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.